Method for automatically filing approval files

Abstract

The invention discloses a method for automatically filing approval files, and relates to the technical field of data management. Comprising the steps that 1, a MySQL database is used for creating a workflow related table which comprises a flow historical record table, a flow application form, a flow basic framework table, a user table, a role table and a configuration table, and 2, role permission corresponding to a user is maintained, specifically, whether the user has the corresponding role permission or not is checked, the user is authorized through the role, and the user is authorized through the role; 3, initiating an approval filing process of the project file, filling related project file information according to the workflow related table, checking the accuracy and authenticity of the project file information, entering the approval filing process, filing the project file, and ending the approval filing process.

Description

Technical Field

[0001] The invention discloses a method for automatically filing approval documents, and relates to the technical field of data management. Background Art

[0002] At present, most enterprises and employees have too many project file archives in their hands, which take up office computer memory, cause computer freezes, reduce work efficiency by half, and make searching for project files cumbersome and time-consuming. This cannot meet the needs of users to quickly find file content. At the same time, the files are stored on the employees' respective computer disks, and sharing is cumbersome. This cannot meet the needs of modern society for unified file management, is not conducive to long-term storage of project file information, and cannot guarantee the security, controllability and stability of file information data, and is prone to loss of project file information. Summary of the invention

[0003] In view of the problems of the prior art, the present invention provides a method for automatically archiving approval documents, which realizes the flexibility of file sharing between users, the convenience, stability and authenticity of users' storage of project files, and the overall uniformity of project file location storage, greatly reduces the excessive working time occupied by users in searching for files, improves the security and controllability of project file storage, and also improves the flexibility and work efficiency of sharing project files and viewing project file contents between users, which has very practical value effects for most enterprises and units.

[0004] The specific scheme proposed by the present invention is:

[0005] A method for automatically archiving approval documents is provided, comprising:

[0006] Step 1: Use MySQL database to create workflow related tables, which include workflow history table, workflow application table, workflow basic framework table, user table, role table and configuration table.

[0007] Step 2: Maintain the user's corresponding role permissions: Check whether the user has the corresponding role permissions, authorize the user through the role, and give the user the permission to modify the information and content of the project file to be approved.

[0008] Step 3: Initiate the approval and archiving process of the project file, fill in the relevant project file information according to the relevant tables of the workflow, verify the accuracy and authenticity of the project file information, and enter the approval and archiving process: lock the project file information, check whether the data of the archived file is correct, and fill in the information description to see if it is consistent with the uploaded file content. If there is a problem, it will be rejected to the user in the first approval node in time, allowing the user to modify and edit, and re-initiate the project archiving process; if there is no problem, it will be approved, and the approval record information of the first approval node will be automatically synchronized to the node to be archived. Check the project file information again, and filter whether the project file information is true and valid and whether the data is accurate and complete according to the opinions of the first approval node. After approval again, the project file will be archived to end the approval and archiving process.

[0009] Furthermore, in step 1 of the method for automatic archiving of approval documents, the flow history record information of the process is recorded through the process history record table, the process application record is recorded through the process application table, the process basic framework table includes the basic table based on the workflow framework, the flow chart is designed through the process basic framework table, the process node information is recorded, the user name, login account, and mobile phone number information are recorded through the user table, the role table includes the basic role information and the operation authority information of the role, through the role table, the corresponding association relationship is established between the user and the role, the respective operation authority of the user is clarified, and the data is prevented from being tampered with, and the configuration information of the project file classification type and the process classification type is recorded through the configuration table.

[0010] Furthermore, in step 3 of the method for automatically archiving approval documents, a visual interface is provided for the user, and the operation management of the approval and archiving process is performed through the visual interface, and all operation information and process configuration data are stored in the MySQL database.

[0011] Furthermore, in step 3 of the method for automatically archiving approval documents, the project files are automatically archived to the FTP server for persistent storage, and after successful archiving, a prompt is given and an indicator of successful archiving is displayed.

[0012] The present invention also provides a system for automatically filing approval documents, including a database management module, a role authority management module and an approval filing module.

[0013] The database management module uses the MySQL database to create workflow-related tables, which include the workflow history table, the workflow application table, the workflow basic framework table, the user table, the role table, and the configuration table.

[0014] The role authority management module maintains the role authority corresponding to the user: checks whether the user has the corresponding role authority, authorizes the user through the role, and enables the user to modify the information and content of the project file to be approved.

[0015] The approval and archiving module initiates the approval and archiving process of the project file, fills in the relevant project file information according to the relevant tables of the workflow, verifies the accuracy and authenticity of the project file information, and enters the approval and archiving process: locks the project file information, checks whether the data of the archived file is correct, and fills in the information description to see whether it is consistent with the uploaded file content. If there is a problem, it will be rejected to the user in the first approval node in time, allowing the user to modify and edit, and re-initiate the project archiving process; if there is no problem, it will be approved, and the approval record information of the first approval node will be automatically synchronized to the node to be archived. Check the project file information again, and filter whether the project file information is true and valid and whether the data is accurate and complete according to the opinions of the first approval node. After approval again, the project file will be archived and the approval and archiving process will end.

[0016] Furthermore, the database management module of the system for automatic archiving of approval documents records the flow history information of the process through a process history record table, records the process application record through a process application table, the process basic framework table contains the basic table based on which the workflow framework is based, the flow chart is designed through the process basic framework table, the process node information is recorded, the user name, login account, and mobile phone number information are recorded through the user table, the role table contains the basic role information and the operation authority information of the role, through the role table, the corresponding association relationship is established between the user and the role, the respective operation authority of the user is clarified, and the data is prevented from being tampered with, and the configuration information of the project file classification type and the process classification type is recorded through the configuration table.

[0017] Furthermore, the approval and archiving module of the system for automatically archiving approval documents provides a visual interface for users to operate and manage the approval and archiving process through the visual interface, and all operation information and process configuration data are stored in the MySQL database.

[0018] Furthermore, the approval archiving module of the system for automatically archiving approval documents automatically archives the project files to the FTP server for persistent storage, and after successful archiving, a prompt is given and an identification mark indicating successful archiving is displayed.

[0019] The benefits of the present invention are:

[0020] Improve efficiency: It can quickly and accurately identify the categories of project files and classify them into the correct location, which greatly reduces the time and labor of manual operations and improves the efficiency of file archiving.

[0021] High accuracy: It can work based on preset rules and algorithms to ensure that files are correctly classified and filed. This accuracy reduces the possibility of incorrect classification and filing, and improves the quality of file management.

[0022] Security enhancement: Usually has strict security measures, such as access control, data encryption, etc., to protect the security of project files. In addition, regular backup and recovery functions can also be provided to prevent data loss or damage.

[0023] Easy to retrieve: Project files can be systematically organized and stored, making retrieval easier and faster. You can quickly find the required files by keyword, tag or date, which improves work efficiency.

[0024] Save storage space: Project files can be stored in electronic form, saving physical storage space. At the same time, the storage and transmission of electronic files are more convenient and faster, which is conducive to remote collaboration and communication of projects.

[0025] Promote knowledge management: It can help organizations better manage project files and knowledge assets. Through automated tagging and classification systems, documents can be systematically organized and stored, allowing team members to easily find the information they need. In addition, advanced search functions and version control features also make it faster and easier to find specific information in a large number of documents. BRIEF DESCRIPTION OF THE DRAWINGS

[0026] Figure 1 It is a schematic diagram of the application framework of the system of the present invention.

[0027] Figure 2 It is a schematic diagram of the approval and filing process in the method of the present invention. DETAILED DESCRIPTION

[0028] The present invention is further described below in conjunction with the accompanying drawings and specific embodiments so that those skilled in the art can better understand the present invention and implement it, but the embodiments are not intended to limit the present invention.

[0029] Example 1

[0030] The present invention provides a method for automatically filing approval documents, comprising:

[0031] Step 1: Use MySQL database to create workflow related tables, which include process history table, process application table, process basic framework table, user table, role table and configuration table.

[0032] The process history record table is used to record the flow history record information of the process, the process application table is used to record the process application record, the process basic framework table contains the basic table based on which the workflow framework is based, the process basic framework table is used to design the flow chart, and the process node information is recorded, the user table is used to record the user name, login account, and mobile phone number information, the role table contains the basic role information and the operation permission information of the role, through the role table, the corresponding association relationship is established between the user and the role, the user's respective operation permissions are clarified, and the data is prevented from being tampered with, and the configuration information of the project file classification type and the process classification type is recorded through the configuration table.

[0033] Step 2: Maintain the user's corresponding role permissions: Check whether the user has the corresponding role permissions, and authorize the user through the role so that the user has the permission to modify the project file information and content to be approved.

[0034] Step 3: Initiate the approval and archiving process of the project file, fill in the relevant project file information according to the relevant tables of the workflow, verify the accuracy and authenticity of the project file information, and enter the approval and archiving process: lock the project file information, check whether the data of the archived file is correct, and fill in the information description to see if it is consistent with the uploaded file content. If there is a problem, it will be rejected to the user in the first approval node in time, allowing the user to modify and edit, and re-initiate the project archiving process; if there is no problem, it will be approved, and the approval record information of the first approval node will be automatically synchronized to the node to be archived. Check the project file information again, and filter whether the project file information is true and valid and whether the data is accurate and complete according to the opinions of the first approval node. After approval again, the project file will be archived to end the approval and archiving process.

[0035] In step 3, a visual interface is provided for users to manage the approval and filing process through the visual interface. All operation information and process configuration data are stored in the MySQL database.

[0036] Automatically archive project files to the FTP server for persistent storage. After successful archiving, a prompt will be given and a successful archiving mark will be displayed.

[0037] Example 2

[0038] The present invention also provides a system for automatically filing approval documents, including a database management module, a role authority management module and an approval filing module.

[0039] The database management module uses the MySQL database to create workflow-related tables, which include the workflow history table, the workflow application table, the workflow basic framework table, the user table, the role table, and the configuration table.

[0040] The role permission management module maintains the role permissions corresponding to the user: checks whether the user has the corresponding role permissions, authorizes the user through the role, and enables the user to modify the information and content of the project file to be approved.

[0041] The approval and archiving module initiates the approval and archiving process of the project file, fills in the relevant project file information according to the relevant tables of the workflow, verifies the accuracy and authenticity of the project file information, and enters the approval and archiving process: locks the project file information, checks whether the data of the archived file is correct, and fills in the information description to see whether it is consistent with the uploaded file content. If there is a problem, it will be rejected to the user in the first approval node in time, allowing the user to modify and edit, and re-initiate the project archiving process; if there is no problem, it will be approved, and the approval record information of the first approval node will be automatically synchronized to the node to be archived. Check the project file information again, and filter whether the project file information is true and valid and whether the data is accurate and complete according to the opinions of the first approval node. After approval again, the project file will be archived and the approval and archiving process will end.

[0042] As the information interaction and execution process between the modules in the above-mentioned system are based on the same concept as the embodiment of the method of the present invention, the specific contents can be found in the description of the embodiment of the method of the present invention and will not be repeated here.

[0043] The benefits of the system of the present invention are:

[0044] Improve efficiency: It can quickly and accurately identify the categories of project files and classify them into the correct location, which greatly reduces the time and labor of manual operations and improves the efficiency of file archiving.

[0045] High accuracy: It can work based on preset rules and algorithms to ensure that files are correctly classified and filed. This accuracy reduces the possibility of incorrect classification and filing, and improves the quality of file management.

[0046] Security enhancement: Usually has strict security measures, such as access control, data encryption, etc., to protect the security of project files. In addition, regular backup and recovery functions can also be provided to prevent data loss or damage.

[0047] Easy to retrieve: Project files can be systematically organized and stored, making retrieval easier and faster. You can quickly find the required files by keyword, tag or date, which improves work efficiency.

[0048] Save storage space: Project files can be stored in electronic form, saving physical storage space. At the same time, the storage and transmission of electronic files are more convenient and faster, which is conducive to remote collaboration and communication of projects.

[0049] Promote knowledge management: It can help organizations better manage project files and knowledge assets. Through automated tagging and classification systems, documents can be systematically organized and stored, allowing team members to easily find the information they need. In addition, advanced search functions and version control features also make it faster and easier to find specific information in a large number of documents.

[0050] It should be noted that not all steps and modules in the above-mentioned processes and system structures are necessary, and some steps or modules can be ignored according to actual needs. The execution order of each step is not fixed and can be adjusted as needed. The system structure described in the above-mentioned embodiments can be a physical structure or a logical structure, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities, or some components in multiple independent devices may be implemented together.

[0051] The above-described embodiments are only preferred embodiments for fully illustrating the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or changes made by those skilled in the art based on the present invention are within the protection scope of the present invention. The protection scope of the present invention shall be subject to the claims.

Claims

1. A method for automatically filing approval documents, characterized in that include: Step 1: Use MySQL database to create workflow related tables, which include workflow history table, workflow application table, workflow basic framework table, user table, role table and configuration table. Step 2: Maintain the user's corresponding role permissions: Check whether the user has the corresponding role permissions, authorize the user through the role, and give the user the permission to modify the information and content of the project file to be approved. Step 3: Initiate the approval and archiving process of the project file, fill in the relevant project file information according to the relevant tables of the workflow, verify the accuracy and authenticity of the project file information, and enter the approval and archiving process: lock the project file information, check whether the data of the archived file is correct, and whether the filled information description is consistent with the uploaded file content. If there is any problem, it will be rejected to the user in time at the first approval node, allowing the user to modify and edit, and re-initiate the project archiving process; If there are no problems, the approval is passed, and the approval record information of the first approval node is automatically synchronized to the node to be archived. The project file information is checked again. According to the opinions of the first approval node, the project file information is filtered to see whether it is true and valid and whether the data is accurate and complete. After the approval is passed again, the project file is archived, and the approval and archiving process ends.

2. A method for automatic archiving of approval documents according to claim 1, characterized in that in step 1, the flow history record information of the process is recorded through the process history record table, the process application record is recorded through the process application table, the process basic framework table contains the basic table based on the workflow framework, the flow chart is designed through the process basic framework table, the process node information is recorded, the user name, login account, and mobile phone number information are recorded through the user table, the role table contains the basic role information and the operation authority information of the role, through the role table, the user and the role establish a corresponding association relationship, clarify the user's respective operation authority, avoid data tampering, and record the configuration information of the project file classification type and the process classification type through the configuration table.

3. According to the method for automatic archiving of approval documents as described in claim 1, it is characterized in that a visual interface is provided to the user in step 3, and the operation management of the approval and archiving process is performed through the visual interface, and all operation information and process configuration data are stored in the MySQL database.

4. According to the method for automatic archiving of approval documents described in claim 1, it is characterized in that in step 3, the project file is automatically archived to the FTP server for persistent storage, and a prompt is given after successful archiving and an indicator of successful archiving is displayed.

5. A system for automatically filing approval documents, characterized by Including database management module, role authority management module and approval archiving module, The database management module uses the MySQL database to create workflow-related tables, which include the workflow history table, the workflow application table, the workflow basic framework table, the user table, the role table, and the configuration table. The role authority management module maintains the role authority corresponding to the user: checks whether the user has the corresponding role authority, authorizes the user through the role, and enables the user to modify the information and content of the project file to be approved. The approval and archiving module initiates the approval and archiving process of project files. Fill in the relevant project file information according to the relevant tables of the workflow, verify the accuracy and authenticity of the project file information, and enter the approval and archiving process: lock the project file information, check whether the data of the archived file is correct, and whether the filled information description is consistent with the uploaded file content. If there is a problem, it will be rejected to the user in time at the first approval node, allowing the user to modify and edit, and re-initiate the project archiving process; If there are no problems, the approval is passed, and the approval record information of the first approval node is automatically synchronized to the node to be archived. The project file information is checked again. According to the opinions of the first approval node, the project file information is filtered to see whether it is true and valid and whether the data is accurate and complete. After the approval is passed again, the project file is archived, and the approval and archiving process ends.

6. The system for automatically filing approval documents according to claim 5 is characterized by: The database management module records the flow history information of the process through the process history table, and records the process application records through the process application table. The process basic framework table contains the basic table based on the workflow framework. The flow chart is designed through the process basic framework table to record the process node information. The user table records the user name, login account, and mobile phone number information. The role table contains the basic role information and the operation permission information of the role. Through the role table, corresponding associations are established between users and roles, and the respective operation permissions of users are clarified to avoid data tampering. The configuration information of project file classification type and process classification type is recorded through the configuration table.

7. The system for automatically filing approval documents according to claim 5 is characterized by: The approval and archiving module provides users with a visual interface for operational management of the approval and archiving process. All operation information and process configuration data are stored in the MySQL database.

8. The system for automatically filing approval documents according to claim 5 is characterized by: The approval archiving module automatically archives project files to the FTP server for persistent storage. After successful archiving, a prompt will be given and a successful archiving mark will be displayed.

Images