CN117556796A - Project document processing method, device, computer equipment and storage medium - Google Patents
Project document processing method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN117556796A CN117556796A CN202311432817.1A CN202311432817A CN117556796A CN 117556796 A CN117556796 A CN 117556796A CN 202311432817 A CN202311432817 A CN 202311432817A CN 117556796 A CN117556796 A CN 117556796A
- Authority
- CN
- China
- Prior art keywords
- document
- project
- template
- cell
- annotation
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 62
- 230000008569 process Effects 0.000 claims abstract description 29
- 238000012545 processing Methods 0.000 claims abstract description 27
- 238000004364 calculation method Methods 0.000 claims description 8
- 238000007726 management method Methods 0.000 description 13
- 238000012986 modification Methods 0.000 description 8
- 230000004048 modification Effects 0.000 description 8
- 238000000605 extraction Methods 0.000 description 5
- 238000004891 communication Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 230000009286 beneficial effect Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 230000000007 visual effect Effects 0.000 description 3
- 230000006835 compression Effects 0.000 description 2
- 238000007906 compression Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000003491 array Methods 0.000 description 1
- 238000010224 classification analysis Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000013502 data validation Methods 0.000 description 1
- 238000013079 data visualisation Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 235000019800 disodium phosphate Nutrition 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000835 fiber Substances 0.000 description 1
- 238000007667 floating Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000001932 seasonal effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 230000001360 synchronised effect Effects 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
- G06F40/186—Templates
-
- 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/20—Natural language analysis
- G06F40/205—Parsing
- G06F40/216—Parsing using statistical methods
-
- 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
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Strategic Management (AREA)
- General Engineering & Computer Science (AREA)
- Artificial Intelligence (AREA)
- Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- Probability & Statistics with Applications (AREA)
- Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Document Processing Apparatus (AREA)
Abstract
The embodiment of the application belongs to the technical field of project management, and relates to a project document processing method, which comprises the following steps: receiving a generation instruction for a project document; when the project document is generated for the first time, acquiring a template document according to the project associated with the project document; loading a template document, wherein each cell in the template document is provided with an annotation, and the annotation is used for describing the cell; receiving first editing information aiming at a template document, filling the template document according to the annotation correspondence in the first editing information to obtain a project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document; setting the project document and the editable file as reporting approval accessories of the project, and adding the reporting approval accessories to the reporting approval process of the project; and counting the project document according to the notes in the project document to obtain document statistical information. The application also provides a project document processing device, computer equipment and a storage medium. The method and the device improve the processing efficiency of the project document.
Description
Technical Field
The present disclosure relates to the field of project management technologies, and in particular, to a method and apparatus for processing a project document, a computer device, and a storage medium.
Background
In various institutions, each department needs to store items regularly and fill out a declaration form of the item store. The project reserve declaration form contains basic information of the project, and in the process of examining and approving the project, project documents containing project detailed information are filled in to serve as declaration evidence materials, so that each level of management layers or examination and approval institutions conduct examination and approval of the necessity and feasibility of the project.
In the current project management system, a project document is often manufactured by a user, the speed is low, the project document is easily subjectively influenced by the user, the project document can only be used as a flow attachment, synchronous editing and flow approval with a project reserve declaration cannot be realized, and the user is required to perform data statistics of the project document, so that the project document processing efficiency is low.
Disclosure of Invention
An object of the embodiments of the present application is to provide a method, an apparatus, a computer device, and a storage medium for processing a project document, so as to solve the problem of low processing efficiency of the project document.
In order to solve the above technical problems, the embodiments of the present application provide a method for processing a project document, which adopts the following technical scheme:
Receiving a generation instruction for a project document;
when the project document is generated for the first time, acquiring a template document according to the project associated with the project document;
loading the template document, wherein each cell in the template document is provided with an annotation, and the annotation is used for describing the cell;
receiving first editing information aiming at the template document, correspondingly filling the template document according to the annotation in the first editing information to obtain the project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document;
setting the project document and the editable file as a declaration approval accessory of the project, and adding the declaration approval accessory to a declaration process of the project;
and counting the project document according to the notes in the project document to obtain document statistical information.
Further, before the step of receiving the generation instruction for the project document, the method further includes:
acquiring primary template documents of various items;
for each primary template document, acquiring a placeholder of each cell in the primary template document, wherein the placeholder declares the cell type, name, data type and read-write state of the cell;
Generating a template document according to the primary template document and the corresponding placeholder thereof, wherein when the template document is loaded, the placeholder in the template document is used as the annotation of the cell in the template document.
Further, after the step of receiving the generation instruction for the project document, the method further includes:
acquiring a key value of the project document;
and determining whether the project document is generated for the first time according to the key value.
Further, the step of loading the template document includes:
loading the template document through a SpreadJS, setting the annotation of each cell in the template document to be in an invisible state during loading, and setting the editing authority of each cell according to the annotation of each cell.
Further, the step of receiving first editing information for the template document includes:
acquiring a project reserve declaration form of the project, and analyzing the project reserve declaration form to acquire first editing information of the template document; the method comprises the steps of,
and acquiring project information input by a user in the editing page, and taking the acquired project information as first editing information of the template document.
Further, the step of counting the project document according to the annotations in the project document to obtain document statistical information includes:
Acquiring a preset document statistical mode in the project document;
and extracting data from each cell according to the document statistical mode and the annotation of each cell in the project document, and carrying out statistical calculation to obtain the document statistical information of the project document.
Further, after the step of receiving the generation instruction for the project document, the method further includes:
when the project document is generated for adjustment, acquiring an editable file associated with the project document;
loading the editable file;
receiving second editing information aiming at the editable file, and editing the editable file according to the second editing information;
and updating the project document according to the edited editable file.
In order to solve the above technical problems, the embodiments of the present application further provide a project document processing apparatus, which adopts the following technical scheme:
the instruction receiving module is used for receiving a generation instruction aiming at the project document;
the template acquisition module is used for acquiring a template document according to the project associated with the project document when the project document is generated for the first time;
the template loading module is used for loading the template document, each cell in the template document is provided with an annotation, and the annotation is used for describing the cell;
The template filling module is used for receiving first editing information aiming at the template document, correspondingly filling the template document according to the annotation in the first editing information to obtain the project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document;
the attachment adding module is used for setting the project document and the editable file as the reporting approval attachment of the project and adding the reporting approval attachment to the reporting approval flow of the project;
and the project statistics module is used for counting the project document according to the notes in the project document to obtain document statistics information.
To solve the above technical problem, embodiments of the present application further provide a computer device, where the computer device includes a memory and a processor, where the memory stores computer readable instructions, and the processor executes the computer readable instructions to implement the steps of the project document processing method as described above.
To solve the above technical problem, embodiments of the present application further provide a computer readable storage medium having computer readable instructions stored thereon, which when executed by a processor, implement the steps of the project document processing method described above.
Compared with the prior art, the embodiment of the application has the following main beneficial effects: receiving a generation instruction aiming at a project document, and acquiring a template document according to a project associated with the project document when the project document is generated for the first time; the template document is uploaded in advance, and can be flexibly adapted to various projects through the template; loading a template document, wherein each cell in the template document is provided with an annotation for describing the cell, so that the accuracy of input information is ensured; receiving first editing information, filling a template document according to annotation correspondence in the first editing information to obtain a project document, generating an editable file of the project document, and adding the project document and the editable file as accessories to a declaration approval process of the project, so that approval, rollback and editing can be carried out along with the process; the information in the editable file is consistent with the information in the project document, the project document can be updated through the editable file, and the safety and traceability of the data are ensured; according to the notes in the project document, information extraction and statistics can be automatically carried out on the project document, and document statistical information can be rapidly generated; according to the method and the device, the project document can be accurately and rapidly generated and information statistics can be carried out through the template document and the cell annotation, and the processing efficiency of the project document is improved.
Drawings
For a clearer description of the solution in the present application, a brief description will be given below of the drawings that are needed in the description of the embodiments of the present application, it being obvious that the drawings in the following description are some embodiments of the present application, and that other drawings may be obtained from these drawings without inventive effort for a person of ordinary skill in the art.
FIG. 1 is an exemplary system architecture diagram in which the present application may be applied;
FIG. 2 is a flow chart of one embodiment of a project document processing method according to the present application;
FIG. 3 is a schematic diagram of an embodiment of a project document processing apparatus according to the present application;
FIG. 4 is a schematic structural diagram of one embodiment of a computer device according to the present application.
Detailed Description
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs; the terminology used in the description of the applications herein is for the purpose of describing particular embodiments only and is not intended to be limiting of the application; the terms "comprising" and "having" and any variations thereof in the description and claims of the present application and in the description of the figures above are intended to cover non-exclusive inclusions. The terms first, second and the like in the description and in the claims or in the above-described figures, are used for distinguishing between different objects and not necessarily for describing a sequential or chronological order.
Reference herein to "an embodiment" means that a particular feature, structure, or characteristic described in connection with the embodiment may be included in at least one embodiment of the present application. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments. Those of skill in the art will explicitly and implicitly appreciate that the embodiments described herein may be combined with other embodiments.
In order to better understand the technical solutions of the present application, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings.
As shown in fig. 1, a system architecture 100 may include terminal devices 101, 102, 103, a network 104, and a server 105. The network 104 is used as a medium to provide communication links between the terminal devices 101, 102, 103 and the server 105. The network 104 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
The user may interact with the server 105 via the network 104 using the terminal devices 101, 102, 103 to receive or send messages or the like. Various communication client applications, such as a web browser application, a shopping class application, a search class application, an instant messaging tool, a mailbox client, social platform software, etc., may be installed on the terminal devices 101, 102, 103.
The terminal devices 101, 102, 103 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablet computers, electronic book readers, MP3 players (Moving Picture Experts Group Audio Layer III, dynamic video expert compression standard audio plane 3), MP4 (Moving Picture Experts Group Audio Layer IV, dynamic video expert compression standard audio plane 4) players, laptop and desktop computers, and the like.
The server 105 may be a server providing various services, such as a background server providing support for pages displayed on the terminal devices 101, 102, 103.
It should be noted that, the method for processing a project document provided in the embodiments of the present application is generally executed by a server, and accordingly, the project document processing device is generally disposed in the server.
It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
With continued reference to FIG. 2, a flow chart of one embodiment of a project document processing method according to the present application is shown. The project document processing method comprises the following steps:
Step S201, a generation instruction for a project document is received.
In this embodiment, the electronic device (for example, the server shown in fig. 1) on which the project document processing method operates may communicate with the terminal device through a wired connection or a wireless connection. It should be noted that the wireless connection may include, but is not limited to, 3G/4G/5G connection, wiFi connection, bluetooth connection, wiMAX connection, zigbee connection, UWB (ultra wideband) connection, and other now known or later developed wireless connection.
Specifically, the generation instruction is for instructing the server to generate a project document of the project. In the process of reporting and approving the project, a project reserve report form and a project document are involved, wherein the project reserve report form contains basic information of the project, and the project document contains detailed information of the project. Project documents in this application include, but are not limited to: project proposal, other template documents related to the project, template documents of other business types, etc. Since a template document is generally associated with a certain project, various template documents used are collectively referred to as project documents.
It should be noted that, the reporting and approval process of the item is an application scenario of the present application, but the present application is not limited to the reporting and approval process of the item. The method and the device can be widely applied to scenes of generating project documents through template documents.
The declaration approval process of the item may include a plurality of process nodes, for example, including: the departments offer projects, first-level reporting approval, second-level reporting approval and third-level reporting approval, and each flow node can generate project documents according to the generation instructions. In one embodiment, each process node is configured with a parameter of "whether to generate a proposal" according to which it can be determined whether each process node can generate a project document, and whether a button of "generate project document" in a declaration approval page of each process node is visible/effective is determined, so as to control authority of each department for generating project documents.
Further, before the step S201, the method may further include: acquiring primary template documents of various items; for each primary template document, acquiring a placeholder of each cell in the primary template document, wherein the placeholder declares the cell type, name, data type and read-write state of the cell; a template document is generated from the primary template document and its corresponding placeholders, and when the template document is loaded, the placeholders in the template document will serve as annotations for cells in the template document.
Specifically, the project management system in the application has a template management function, a template document uses a primary template document of which each project can be created through a visual operation by a user, and each project corresponds to at least one primary template document; alternatively, the template document may be retrieved from elsewhere by the user using the template document and uploaded to the project management system.
In template management, for each primary template document, the template document uses placeholders that a user can configure cells in the primary template document. The placeholder may be represented by a string and have a special beginning to declare the placeholder (e.g., beginning with @).
The placeholder declares the cell type (normal, column phenotype, and merge), name (name has uniqueness under each cell type of the template document), data type (numerical, character, enumeration, and date), and read-write status (whether the cell is read-only).
Different types of cells have different characteristics and uses in the template document, thereby meeting various data processing requirements. A common type of cell is a standard cell in a template document, typically containing text, numbers, or other general information, commonly used to input and display general data for items.
List cells are used to create a table or list in a template document, which may contain multiple lines of data, and may present repeatable information. Cells of this type are often used to list a number of details or options for an item.
Merging cells refers to merging multiple common cells into one larger cell that can be used to create a title, subtitle, or other portion that needs to be emphasized. The merged cells may create visual separation or emphasis in the document.
Based on the primary template document and its corresponding placeholder, a template document may be generated that is saved to a database of the project management system. The template document can be in a word format, and can contain word tables, text, graphics, images and other types of information.
When the template document is loaded, placeholders in the template document will serve as annotations to cells in the template document, thereby describing and managing the cells.
In the embodiment, primary template documents of various items are obtained, placeholders of various cells in the primary template documents are obtained, the placeholders declare the cell types, names, data types and read-write states of the cells, and the cells are described; and generating a template document according to the primary template document and the corresponding placeholders thereof, wherein when the template document is loaded, the placeholders in the template document are used as the notes of the cells in the template document, so that the document description and management are convenient.
Further, after the step S201, the method may further include: acquiring a key value of a project document; and determining whether the project document is generated for the first time according to the key value.
Specifically, the project document has a unique key value (key), which may be a project target identity (each project may have a unique project document), a user/department identity (ensuring that the project documents generated by different users/departments do not interfere with each other), and a project declaration form identity (ensuring that the project declaration form is associated with a specific project declaration form).
And acquiring a key value from the generation instruction, inquiring the key value in the project management system, and determining whether the project document to be generated at this time is generated for the first time. The generation of the project document includes a first generation and an adjustment generation. The adjustment generation will be described in detail below.
In this embodiment, the project document has a unique key value, and whether the project document is generated for the first time can be queried according to the key value, so that the generation mode of the project document is selected.
Step S202, when the project document is generated for the first time, acquiring the template document according to the project associated with the project document.
Specifically, when the project document is first generated, the template document is acquired from a database of the project management system according to the project associated with the project document.
Step S203, loading a template document, wherein each cell in the template document is provided with an annotation, and the annotation is used for describing the cell.
Specifically, the server transmits the template document to the terminal so that the terminal loads the template document and displays the template document through the terminal, at which time the template document displayed by the terminal may be regarded as a blank project document or a project document containing a small amount of project information.
Further, the step of loading the template document may include: loading the template document through the SpreadJS, setting the annotation of each cell in the template document to be in an invisible state during loading, and setting the editing authority of each cell according to the annotation of each cell.
Specifically, the template document may be a word document, which mainly includes a word table, so that the terminal may load the template document through the sprejs.
SpreadJS is a JavaScript spreadsheet library for creating and managing spreadsheets, data grids, and interactive data tables similar to Excel in Web applications. It allows developers to embed spreadsheets similar to Microsoft Excel on web pages and provide rich functions such as formula calculation, data validation, data screening, charts, etc. The SpreadJS may be used to develop a variety of Web-based applications, particularly applications that require the presentation and editing of data tables.
When loading, the placeholders of the cells in the template document are used as the notes of the cells, and the notes are set to be in invisible states, so that the definition of the page is maintained, and the interference to users is reduced.
When loading, editing authority of each cell is set according to the annotation of each cell. For example, when the annotation display cell is in a read-only state, the loaded cell is in a read-only state and does not support user editing. The annotation of cells may also determine how to implement the table editing, for example, if the cells of the previous row in the table are all column phenotypes, then the operation of "adding a row" may be performed after the previous row, thereby preserving the original structure of the template document.
In this embodiment, the template document is loaded through the sprejss, and during loading, the annotation of each cell in the template document is set to an invisible state to maintain the definition of the page, and the editing authority of each cell is set according to the annotation of each cell, so as to ensure that the structure and the integrity of the template document are not damaged when a user edits the project document, thereby being beneficial to maintaining the consistency of the template document, and ensuring that the generated project document meets the required format and requirement.
Step S204, receiving first editing information aiming at the template document, so as to fill the template document according to the annotation in the first editing information to obtain the project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document.
Specifically, first editing information for the template document is received, each piece of information in the first editing information also having an annotation corresponding to the annotation of the cell in the template document. The annotation of each piece of information in the first editing information indicates which cells in the template document were edited, and how the editing was performed.
And filling and editing the template document according to the annotation correspondence in the first editing information to obtain the project document, generating an editable file of the project document, and generating the editable file according to the project document and the first editing information for updating the project document subsequently. In one embodiment, the editable file may be an excel file. It should be noted that the editable file is also annotated, thereby facilitating modification of the project document.
Further, the step of receiving the first editing information for the template document may include: acquiring a project reserve declaration form of a project, and analyzing the project reserve declaration form to acquire first editing information of a template document; and acquiring project information input by a user in the editing page, and taking the acquired project information as first editing information of the template document.
Specifically, a project reserve declaration form of a project is acquired, the project reserve declaration form is parsed to acquire basic information of the project in the project reserve declaration form, and the basic information is used as first editing information of a template document. The project reservation declaration form can be provided with notes, the notes of the project reservation declaration form and the notes in the template document are in the same system, and the notes in the first editing information obtained according to the project reservation declaration form can be seamlessly switched into the template document.
The user may also make visual edits to the loaded template document in the edit page to enter project information that will also be the first edit information of the template document. Since the project information is entered on the basis of the template document, there is also an annotation.
In one embodiment, the project information may also be automatically generated, for example, the user may upload a project-related file (image or text, etc.), and the project management system may automatically parse the project-related file to obtain the project information, and use the project information as the first editing information.
In this embodiment, a project reservation declaration form of a project is acquired, and the project reservation declaration form is parsed to take basic information of the project as first editing information; project information input by a user in the editing page can be acquired, and the project information is used as first editing information of the template document, so that generation of a subsequent project document is ensured.
In one embodiment, when the terminal loads the template document, the basic information of the item in the item reserve declaration form can be acquired, and the basic information is presented in the loaded template document. And only acquiring the project information input by the user in the editing page.
Step S205, setting the project document and the editable file as the reporting approval attachment of the project, and adding the reporting approval attachment to the reporting process of the project.
Specifically, the project document and the editable file are set as the declaration approval attachment of the project, and added to the declaration approval process of the project. The project document and the editable file will be circulated along with the process change (supporting rollback process), supporting online preview, downloading, adjustment and modification, etc.
In the embodiment, the project document and the editable file are set as the reporting examination and approval attachment of the project and added to the reporting examination and approval flow of the project, so that the flow circulation, modification and adjustment of the project document and the editable file can be supported.
Step S206, counting the project document according to the notes in the project document to obtain document statistical information.
Specifically, the annotation in the project document describes each cell, and according to the annotation, information in the project document can be automatically summarized and counted, so that document statistical information can be quickly generated.
Further, the step S206 may include: acquiring a preset document statistical mode in a project document; and extracting data from each cell according to the document statistics mode and the notes of each cell in the project document, and carrying out statistics calculation to obtain the document statistics information of the project document.
Specifically, a document statistical mode is preset for each template document, and after a project document is generated based on the template document, the preset document statistical mode is obtained. Document statistics include what statistics need to be performed (e.g., data analysis, data visualization, automated report generation, monitoring and tracking, data summarization and archiving, etc.), and what cells of data need to be obtained at the time of statistics. The annotation of the cell may display the cell type (normal, column phenotype and merge), name, data type (numerical, character, enumeration and date), belonging row and column, and specific data is stored in the cell. According to the document statistics mode and the notes of each cell in the project document, data are extracted from each cell and are subjected to statistics calculation, and document statistics information of the project document can be automatically generated.
For example, the project document may be a annual financial report of a company that contains various financial data, such as revenue, expense, profit, and the like. For annual financial reporting, document statistics include revenue trend analysis, expense classification analysis, profit calculation, and automated report generation. According to the cell annotation, income data in the statistical report can be obtained, and the income change trend of each quarter or each month is known to obtain seasonal change and development trend of the business; the expenditure data can be counted, and the expenditure conditions of different expenditure items can be known; annual profit can be automatically calculated by counting income and expenditure data, and the accuracy and efficiency of reporting are improved; the statistics may be used to automatically generate financial reports without manually writing the reports, thereby reducing the amount of manual work and reducing the risk of errors.
In the embodiment, a preset document statistics mode in the project document is acquired, wherein the document statistics mode comprises what statistics is carried out on the project document and what data need to be acquired; and according to the annotation of each cell, data can be automatically extracted from the cell and counted, so that document counting information of the project document is rapidly generated, and project counting is realized.
Further, after the step of receiving the generation instruction for the project document, the method may further include: when the project document is generated for adjustment, acquiring an editable file associated with the project document; loading an editable file; receiving second editing information aiming at the editable file, and editing the editable file according to the second editing information; and updating the project document according to the edited editable file.
Specifically, the project document supports modifications, rollback modifications, etc., at this point, is the regulatory generation of the project document. And acquiring an editable file associated with the project document, and loading the editable file by the terminal. The user can check various items of information of the items in the editable file through the terminal, and enter second editing information aiming at the editable file. The input process is also a process of editing the editable file, editing and storing the editable file, and the server updates the project document according to the new editable file.
In the application, the template document supports issuing and collecting, the template document can be sent to related personnel, the related personnel edit the template document, and the project document and the editable file are retrieved.
When the user inputs the first editing information and the second editing information, after the cell is selected, the annotation of the cell can be displayed in a floating window or in a specific area, so that the user can correctly input information according to the annotation, and the information input by the user can be automatically detected according to the annotation, so that the rationality of the information input by the user is ensured.
In the embodiment, when the project document is generated for adjustment, an editable file associated with the project document is acquired; loading an editable file, receiving second editing information aiming at the editable file, and editing the editable file according to the second editing information; updating the project document according to the edited editable file, so as to realize the modification and adjustment of the project document; the editable file is used for carrying editing operation, so that the integrity and consistency of data and the traceability of user editing are maintained, potential errors are reduced, and the safety and controllability of project document data are ensured.
In the embodiment, a generation instruction for a project document is received, and when the project document is generated for the first time, a template document is acquired according to a project associated with the project document; the template document is uploaded in advance, and can be flexibly adapted to various projects through the template; loading a template document, wherein each cell in the template document is provided with an annotation for describing the cell, so that the accuracy of input information is ensured; receiving first editing information, filling a template document according to annotation correspondence in the first editing information to obtain a project document, generating an editable file of the project document, and adding the project document and the editable file as accessories to a declaration approval process of the project, so that approval, rollback and editing can be carried out along with the process; the information in the editable file is consistent with the information in the project document, the project document can be updated through the editable file, and the safety and traceability of the data are ensured; according to the notes in the project document, information extraction and statistics can be automatically carried out on the project document, and document statistical information can be rapidly generated; according to the method and the device, the project document can be accurately and rapidly generated and information statistics can be carried out through the template document and the cell annotation, and the processing efficiency of the project document is improved.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by computer readable instructions stored in a computer readable storage medium that, when executed, may comprise the steps of the embodiments of the methods described above. The storage medium may be a nonvolatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a random access Memory (Random Access Memory, RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
With further reference to fig. 3, as an implementation of the method shown in fig. 2, the present application provides an embodiment of a project document processing apparatus, where the embodiment of the apparatus corresponds to the embodiment of the method shown in fig. 2, and the apparatus is particularly applicable to various electronic devices.
As shown in fig. 3, the project document processing apparatus 300 according to the present embodiment includes: an instruction receiving module 301, a template obtaining module 302, a template loading module 303, a template filling module 304, an accessory adding module 305 and an item counting module 306, wherein:
the instruction receiving module 301 is configured to receive a generation instruction for a project document.
The template obtaining module 302 is configured to obtain, when the project document is generated for the first time, a template document according to a project associated with the project document.
The template loading module 303 is configured to load a template document, where each cell in the template document has an annotation, and the annotation is used to describe the cell.
The template filling module 304 is configured to receive first editing information for a template document, to fill the template document according to the annotation in the first editing information to obtain a project document, and to generate an editable file of the project document, where the editable file is used to update the project document.
The attachment adding module 305 is configured to set the project document and the editable file as a reporting approval attachment of the project, and add the reporting approval attachment to a reporting flow of the project.
The project statistics module 306 is configured to perform statistics on the project document according to the annotations in the project document, so as to obtain document statistics information.
In the embodiment, a generation instruction for a project document is received, and when the project document is generated for the first time, a template document is acquired according to a project associated with the project document; the template document is uploaded in advance, and can be flexibly adapted to various projects through the template; loading a template document, wherein each cell in the template document is provided with an annotation for describing the cell, so that the accuracy of input information is ensured; receiving first editing information, filling a template document according to annotation correspondence in the first editing information to obtain a project document, generating an editable file of the project document, and adding the project document and the editable file as accessories to a declaration approval process of the project, so that approval, rollback and editing can be carried out along with the process; the information in the editable file is consistent with the information in the project document, the project document can be updated through the editable file, and the safety and traceability of the data are ensured; according to the notes in the project document, information extraction and statistics can be automatically carried out on the project document, and document statistical information can be rapidly generated; according to the method and the device, the project document can be accurately and rapidly generated and information statistics can be carried out through the template document and the cell annotation, and the processing efficiency of the project document is improved.
In some optional implementations of this embodiment, the project document processing apparatus 300 may further include: the system comprises a primary acquisition module, a placeholder acquisition module and a template generation module, wherein:
and the primary acquisition module is used for acquiring the primary template document of each item.
And the placeholder acquisition module is used for acquiring placeholders of all the cells in the primary template document for each primary template document, and the placeholders declare the cell types, names, data types and read-write states of the cells.
The template generation module is used for generating a template document according to the primary template document and the corresponding placeholders, and when the template document is loaded, the placeholders in the template document are used as the notes of the cells in the template document.
In the embodiment, primary template documents of various items are obtained, placeholders of various cells in the primary template documents are obtained, the placeholders declare the cell types, names, data types and read-write states of the cells, and the cells are described; and generating a template document according to the primary template document and the corresponding placeholders thereof, wherein when the template document is loaded, the placeholders in the template document are used as the notes of the cells in the template document, so that the document description and management are convenient.
In some optional implementations of this embodiment, the project document processing apparatus 300 may further include: the key value acquisition module and the generation judgment module, wherein:
and the key value acquisition module is used for acquiring the key value of the project document.
And the generation judging module is used for determining whether the project document is generated for the first time according to the key value.
In this embodiment, the project document has a unique key value, and whether the project document is generated for the first time can be queried according to the key value, so that the generation mode of the project document is selected.
In some optional implementations of this embodiment, the template loading module 303 may be further configured to load the template document through the SpreadJS, and set the annotation of each cell in the template document to an invisible state during loading, and set the editing authority of each cell according to the annotation of each cell.
In this embodiment, the template document is loaded through the sprejss, and during loading, the annotation of each cell in the template document is set to an invisible state to maintain the definition of the page, and the editing authority of each cell is set according to the annotation of each cell, so as to ensure that the structure and the integrity of the template document are not damaged when a user edits the project document, thereby being beneficial to maintaining the consistency of the template document, and ensuring that the generated project document meets the required format and requirement.
In some alternative implementations of the present embodiment, template populating module 304 may include: a declaration form acquisition sub-module and an information acquisition sub-module, wherein:
and the declaration form acquisition sub-module is used for acquiring a project reserve declaration form of a project and analyzing the project reserve declaration form to acquire first editing information of the template document.
The information acquisition sub-module is used for acquiring project information input by a user in the editing page and taking the acquired project information as first editing information of the template document.
In this embodiment, a project reservation declaration form of a project is acquired, and the project reservation declaration form is parsed to take basic information of the project as first editing information; project information input by a user in the editing page can be acquired, and the project information is used as first editing information of the template document, so that generation of a subsequent project document is ensured.
In some alternative implementations of the present embodiment, the project statistics module 305 may include: the method comprises the steps of obtaining a sub-module and an item statistics sub-module, wherein:
the mode acquisition sub-module is used for acquiring a preset document statistical mode in the project document.
And the project statistics sub-module is used for extracting data from each cell and carrying out statistics calculation according to the document statistics mode and the annotation of each cell in the project document to obtain the document statistics information of the project document.
In the embodiment, a preset document statistics mode in the project document is acquired, wherein the document statistics mode comprises what statistics is carried out on the project document and what data need to be acquired; and according to the annotation of each cell, data can be automatically extracted from the cell and counted, so that document counting information of the project document is rapidly generated, and project counting is realized.
In some optional implementations of this embodiment, the project document processing apparatus 300 may further include: the system comprises a file acquisition module, a file loading module, an editing receiving module and an updating module, wherein:
and the file acquisition module is used for acquiring the editable file associated with the project document when the project document is generated for adjustment.
And the file loading module is used for loading the editable file.
And the editing receiving module is used for receiving second editing information aiming at the editable file and editing the editable file according to the second editing information.
And the updating module is used for updating the project document according to the edited editable file.
In the embodiment, when the project document is generated for adjustment, an editable file associated with the project document is acquired; loading an editable file, receiving second editing information aiming at the editable file, and editing the editable file according to the second editing information; updating the project document according to the edited editable file, so as to realize the modification and adjustment of the project document; the editable file is used for carrying editing operation, so that the integrity and consistency of data and the traceability of user editing are maintained, potential errors are reduced, and the safety and controllability of project document data are ensured.
In order to solve the technical problems, the embodiment of the application also provides computer equipment. Referring specifically to fig. 4, fig. 4 is a basic structural block diagram of a computer device according to the present embodiment.
The computer device 4 comprises a memory 41, a processor 42, a network interface 43 communicatively connected to each other via a system bus. It should be noted that only computer device 4 having components 41-43 is shown in the figures, but it should be understood that not all of the illustrated components are required to be implemented and that more or fewer components may be implemented instead. It will be appreciated by those skilled in the art that the computer device herein is a device capable of automatically performing numerical calculations and/or information processing in accordance with predetermined or stored instructions, the hardware of which includes, but is not limited to, microprocessors, application specific integrated circuits (Application Specific Integrated Circuit, ASICs), programmable gate arrays (fields-Programmable Gate Array, FPGAs), digital processors (Digital Signal Processor, DSPs), embedded devices, etc.
The computer equipment can be a desktop computer, a notebook computer, a palm computer, a cloud server and other computing equipment. The computer equipment can perform man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch pad or voice control equipment and the like.
The memory 41 includes at least one type of readable storage medium including flash memory, hard disk, multimedia card, card memory (e.g., SD or DX memory, etc.), random Access Memory (RAM), static Random Access Memory (SRAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), programmable Read Only Memory (PROM), magnetic memory, magnetic disk, optical disk, etc. In some embodiments, the storage 41 may be an internal storage unit of the computer device 4, such as a hard disk or a memory of the computer device 4. In other embodiments, the memory 41 may also be an external storage device of the computer device 4, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash Card (Flash Card) or the like, which are provided on the computer device 4. Of course, the memory 41 may also comprise both an internal memory unit of the computer device 4 and an external memory device. In this embodiment, the memory 41 is typically used to store an operating system and various types of application software installed on the computer device 4, such as computer readable instructions for a project document processing method. Further, the memory 41 may be used to temporarily store various types of data that have been output or are to be output.
The processor 42 may be a central processing unit (Central Processing Unit, CPU), controller, microcontroller, microprocessor, or other data processing chip in some embodiments. The processor 42 is typically used to control the overall operation of the computer device 4. In this embodiment, the processor 42 is configured to execute computer readable instructions stored in the memory 41 or process data, such as computer readable instructions for executing the project document processing method.
The network interface 43 may comprise a wireless network interface or a wired network interface, which network interface 43 is typically used for establishing a communication connection between the computer device 4 and other electronic devices.
The computer device provided in the present embodiment can execute the above-described project document processing method. The project document processing method here may be the project document processing method of each of the above embodiments.
In the embodiment, a generation instruction for a project document is received, and when the project document is generated for the first time, a template document is acquired according to a project associated with the project document; the template document is uploaded in advance, and can be flexibly adapted to various projects through the template; loading a template document, wherein each cell in the template document is provided with an annotation for describing the cell, so that the accuracy of input information is ensured; receiving first editing information, filling a template document according to annotation correspondence in the first editing information to obtain a project document, generating an editable file of the project document, and adding the project document and the editable file as accessories to a declaration approval process of the project, so that approval, rollback and editing can be carried out along with the process; the information in the editable file is consistent with the information in the project document, the project document can be updated through the editable file, and the safety and traceability of the data are ensured; according to the notes in the project document, information extraction and statistics can be automatically carried out on the project document, and document statistical information can be rapidly generated; according to the method and the device, the project document can be accurately and rapidly generated and information statistics can be carried out through the template document and the cell annotation, and the processing efficiency of the project document is improved.
The present application also provides another embodiment, namely, a computer-readable storage medium storing computer-readable instructions executable by at least one processor to cause the at least one processor to perform the steps of the project document processing method as described above.
In the embodiment, a generation instruction for a project document is received, and when the project document is generated for the first time, a template document is acquired according to a project associated with the project document; the template document is uploaded in advance, and can be flexibly adapted to various projects through the template; loading a template document, wherein each cell in the template document is provided with an annotation for describing the cell, so that the accuracy of input information is ensured; receiving first editing information, filling a template document according to annotation correspondence in the first editing information to obtain a project document, generating an editable file of the project document, and adding the project document and the editable file as accessories to a declaration approval process of the project, so that approval, rollback and editing can be carried out along with the process; the information in the editable file is consistent with the information in the project document, the project document can be updated through the editable file, and the safety and traceability of the data are ensured; according to the notes in the project document, information extraction and statistics can be automatically carried out on the project document, and document statistical information can be rapidly generated; according to the method and the device, the project document can be accurately and rapidly generated and information statistics can be carried out through the template document and the cell annotation, and the processing efficiency of the project document is improved.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk), comprising several instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method described in the embodiments of the present application.
It is apparent that the embodiments described above are only some embodiments of the present application, but not all embodiments, the preferred embodiments of the present application are given in the drawings, but not limiting the patent scope of the present application. This application may be embodied in many different forms, but rather, embodiments are provided in order to provide a more thorough understanding of the present disclosure. Although the present application has been described in detail with reference to the foregoing embodiments, it will be apparent to those skilled in the art that modifications may be made to the embodiments described in the foregoing, or equivalents may be substituted for elements thereof. All equivalent structures made by the specification and the drawings of the application are directly or indirectly applied to other related technical fields, and are also within the protection scope of the application.
Claims (10)
1. A method of project document processing comprising the steps of:
receiving a generation instruction for a project document;
when the project document is generated for the first time, acquiring a template document according to the project associated with the project document;
loading the template document, wherein each cell in the template document is provided with an annotation, and the annotation is used for describing the cell;
receiving first editing information aiming at the template document, correspondingly filling the template document according to the annotation in the first editing information to obtain the project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document;
setting the project document and the editable file as a declaration approval accessory of the project, and adding the declaration approval accessory to a declaration process of the project;
and counting the project document according to the notes in the project document to obtain document statistical information.
2. The method of claim 1, further comprising, prior to the step of receiving the generation instruction for the project document:
acquiring primary template documents of various items;
For each primary template document, acquiring a placeholder of each cell in the primary template document, wherein the placeholder declares the cell type, name, data type and read-write state of the cell;
generating a template document according to the primary template document and the corresponding placeholder thereof, wherein when the template document is loaded, the placeholder in the template document is used as the annotation of the cell in the template document.
3. The method of claim 1, further comprising, after the step of receiving the generation instruction for the project document:
acquiring a key value of the project document;
and determining whether the project document is generated for the first time according to the key value.
4. The method of claim 1, wherein the step of loading the template document comprises:
loading the template document through a SpreadJS, setting the annotation of each cell in the template document to be in an invisible state during loading, and setting the editing authority of each cell according to the annotation of each cell.
5. The method of claim 1, wherein the step of receiving first editing information for the template document comprises:
Acquiring a project reserve declaration form of the project, and analyzing the project reserve declaration form to acquire first editing information of the template document; the method comprises the steps of,
and acquiring project information input by a user in the editing page, and taking the acquired project information as first editing information of the template document.
6. The method of claim 1, wherein the step of counting the project document based on the annotations in the project document to obtain document statistics comprises:
acquiring a preset document statistical mode in the project document;
and extracting data from each cell according to the document statistical mode and the annotation of each cell in the project document, and carrying out statistical calculation to obtain the document statistical information of the project document.
7. The method according to claim 3, further comprising, after the step of receiving the generation instruction for the project document:
when the project document is generated for adjustment, acquiring an editable file associated with the project document;
loading the editable file;
receiving second editing information aiming at the editable file, and editing the editable file according to the second editing information;
And updating the project document according to the edited editable file.
8. A project document processing apparatus, comprising:
the instruction receiving module is used for receiving a generation instruction aiming at the project document;
the template acquisition module is used for acquiring a template document according to the project associated with the project document when the project document is generated for the first time;
the template loading module is used for loading the template document, each cell in the template document is provided with an annotation, and the annotation is used for describing the cell;
the template filling module is used for receiving first editing information aiming at the template document, correspondingly filling the template document according to the annotation in the first editing information to obtain the project document, and generating an editable file of the project document, wherein the editable file is used for updating the project document;
the attachment adding module is used for setting the project document and the editable file as the reporting approval attachment of the project and adding the reporting approval attachment to the reporting approval flow of the project;
and the project statistics module is used for counting the project document according to the notes in the project document to obtain document statistics information.
9. A computer device comprising a memory having stored therein computer readable instructions which when executed by a processor implement the steps of the project document processing method of any of claims 1 to 7.
10. A computer readable storage medium having stored thereon computer readable instructions which when executed by a processor implement the steps of the project document processing method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311432817.1A CN117556796A (en) | 2023-10-31 | 2023-10-31 | Project document processing method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311432817.1A CN117556796A (en) | 2023-10-31 | 2023-10-31 | Project document processing method, device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN117556796A true CN117556796A (en) | 2024-02-13 |
Family
ID=89822396
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311432817.1A Pending CN117556796A (en) | 2023-10-31 | 2023-10-31 | Project document processing method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117556796A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118095294A (en) * | 2024-04-25 | 2024-05-28 | 广东汉佳信息技术有限公司 | Project document generation method and device based on artificial intelligence and electronic equipment |
-
2023
- 2023-10-31 CN CN202311432817.1A patent/CN117556796A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118095294A (en) * | 2024-04-25 | 2024-05-28 | 广东汉佳信息技术有限公司 | Project document generation method and device based on artificial intelligence and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP6033235B2 (en) | Formatting data by example | |
| US9182963B2 (en) | Computerized migration tool and method | |
| US10210142B1 (en) | Inserting linked text fragments in a document | |
| US20230198920A1 (en) | Conversation-enabled document system and method | |
| US20170010869A1 (en) | Multistage customizing of web-based application in a browser independent of platform and operating system | |
| JP7209306B2 (en) | Online work system for Excel documents based on templates | |
| CN113590102B (en) | Zero-code rapid software development method, system, medium and equipment | |
| CN110968996A (en) | Document making method, device, equipment and storage medium | |
| CN113076731A (en) | Report file generation method and device, computer equipment and storage medium | |
| CN112463154A (en) | Page generation method, device and system and electronic equipment | |
| CN113378538A (en) | Document structured information input method, electronic equipment and storage medium | |
| CN109614143B (en) | Development method for automatically generating fault flow chart in IETM browser | |
| CN103838575A (en) | Plug-in type page customization implementation method based on EXTJS frame | |
| CN116227454A (en) | Universal automatic report generation method and system | |
| CN117556796A (en) | Project document processing method, device, computer equipment and storage medium | |
| JP6098685B2 (en) | Workflow system, workflow system control method and program, workflow server, workflow server control method and program | |
| CN115409014A (en) | Document template generation method and device, computer equipment and storage medium | |
| WO2018206819A1 (en) | Data storage method and apparatus | |
| CN111832254B (en) | Drawing annotation display processing method and device | |
| CN114201157A (en) | Method and system for customizing target service module by low code | |
| CN114239525A (en) | Contract template editing method and device, computer equipment and storage medium | |
| US10627997B1 (en) | System and method for highlighting dependent slides while editing master slides of a presentation | |
| CN108228688B (en) | Template generation method, system and server based on XBRL | |
| CN111352917A (en) | Information input method and device, electronic equipment and storage medium | |
| US20100250621A1 (en) | Financial-analysis support apparatus and financial-analysis support method |
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 |