CN112508540A

CN112508540A - Form collaboration tool and authority design method thereof

Info

Publication number: CN112508540A
Application number: CN202011576736.5A
Authority: CN
Inventors: 翟文莉; 江燕; 玄德
Original assignee: Inspur Cloud Information Technology Co Ltd
Current assignee: Inspur Cloud Information Technology Co Ltd
Priority date: 2020-12-28
Filing date: 2020-12-28
Publication date: 2021-03-16

Abstract

The invention discloses a form collaboration tool and an authority design method thereof, and belongs to the technical field of electronic form authorities. The form collaboration tool comprises a design entry and a collaboration entry, collaboration personnel create workbooks and set permissions from the design entry, and the collaboration personnel view the contents of the workbooks with the permissions from the collaboration entry. The form cooperation tool can support online office cooperation, meanwhile, the authority control of the workbook and the worksheet is achieved, and the form cooperation tool has good popularization and application values.

Description

Form collaboration tool and authority design method thereof

Technical Field

The invention relates to the technical field of electronic form authorities, and particularly provides a form cooperation tool and an authority design method thereof.

Background

The electronic form is one of platforms for data calculation and analysis, and can process common data in daily life and work. The electronic spreadsheet integrates the optimal data calculation and analysis functions, is convenient and easy to learn in an intelligent operation mode, enables a user to create the electronic spreadsheet according to own thought, and excellently completes work tasks with the help of the electronic spreadsheet, thereby becoming a powerful assistant in work and life of people.

Nowadays, an online collaborative office model has become a popular trend, society gradually reports the complexity of transmitting files for many times through software such as mails and chat tools, and electronic forms serving as common office software also follow the trend.

However, when team members use the collaboration tool to collaborate and edit the spreadsheet file online, since the security degree of the spreadsheet file and the identity role of the office worker are different, how to open different levels of authority for different collaboration persons becomes a problem to be solved urgently for developers of the online spreadsheet collaboration tool, and further research is needed.

Disclosure of Invention

The technical task of the invention is to provide a form cooperation tool which can support online office cooperation and simultaneously realize authority control of a workbook and a worksheet.

The invention further provides a permission design method of the form cooperation tool.

In order to achieve the purpose, the invention provides the following technical scheme:

a form collaboration tool comprises a design entry and a collaboration entry, collaboration personnel create workbooks and set permissions from the design entry, and the collaboration personnel view the contents of the workbooks with the permissions from the collaboration entry.

The method is realized based on the form collaboration tool, each collaboration person can be used as a manager for creating a workbook, and the manager manages the authority of the workbook and the worksheet.

Preferably, the administrator shares the management authority to other cooperative personnel, so that the other cooperative personnel perform authority management.

Preferably, after entering from the design entry, the workbook administrator queries all workbooks with management authority from the database workbook authority data table according to the current login user ID by the background, and displays the workbooks in a page in a list form.

Preferably, the workbook administrator manages the authority of the workbook in the list, displays all the collaborators in the list, selects the collaborators with the editing authority of the workbook, and stores the user ID and the workbook ID of the authorized collaborators in the workbook authority data table. Wherein the default newly created workbook is invisible to all collaborators except the administrator.

Preferably, after the workbook is opened at the design entrance, the workbook administrator sets the authority of the worksheet, acquires all the worksheets of the workbook, acquires the collaborators with the marked authority of the workbook, displays the collaborators in a list, and sets the editing, read-only and invisible work authorities.

Preferably, after the work authority setting is finished, the workbook ID, the worksheet ID, the authority type and the collaborator user ID are stored in the data sheet corresponding to the worksheet authority. Wherein collaborators for which the workbook has editing rights default to the editing rights.

Preferably, after the collaborators enter from the collaboration entrance, the background searches all workbooks with editing authority according to the user IDs of the collaborators and displays the lists.

Preferably, when the collaborators open the workbooks in the list, the background queries all corresponding worksheet authorities according to the workbook ID and the collaborator user ID, and the front end controls the editing, read-only or invisible of all the workbooks according to the result returned by the background.

By the permission design method of the form cooperative tool, permission control of thinning to a worksheet (Sheet page) during online form cooperative work can be realized, permission control over a workbook is supported, permission control over the worksheet is also supported, and on one hand, after an administrator creates an online workbook, editing permission of the workbook can be authorized to users in a system. On the other hand, the administrator can set the authority of "edit", "read only", and "invisible" for all the worksheets in the workbook to the user who owns the editing authority of the workbook. Editing and invisible authority control of workbooks by different collaborators, editing and read-only and invisible authority control of different worksheets by collaborators with workbook editing authority.

Compared with the prior art, the permission design method of the form collaboration tool has the following outstanding beneficial effects: the permission design method of the form cooperation tool supports online office cooperation, controls the permissions of the workbook, supports online office cooperation, controls the permissions of the worksheet, enables a workbook creator, namely a manager of the workbook, to share the permissions of the manager to other collaborators, enables the manager to authorize the editing permissions of the workbook to other collaborators, achieves the permission control of the workbook, and has good popularization and application values.

Drawings

FIG. 1 is a flowchart of the administrator's right management of a workbook according to the right design method of the form collaboration tool of the present invention;

FIG. 2 is a flowchart of the administrator performing authorized management of the authority for collaborators in the authority design method of the form collaboration tool according to the present invention;

FIG. 3 is a flowchart of setting permissions on a worksheet by an administrator of the permission design method of the form collaboration tool according to the present invention.

FIG. 4 is a flowchart of the work sheet permissions possessed by the collaborators in the permission design method of the form collaboration tool according to the present invention.

Detailed Description

The form collaboration tool and the method for designing the authority thereof according to the present invention will be described in further detail with reference to the accompanying drawings and embodiments.

Examples

The form collaboration tool comprises a design entry and a collaboration entry, collaboration personnel create workbooks and set permissions from the design entry, and the collaboration personnel view the contents of the workbooks with the permissions from the collaboration entry.

The permission design method of the form collaboration tool is realized based on the form collaboration tool. Each cooperative person can be used as a manager for creating the workbook, and the manager manages the authority of the workbook and the worksheet. And sharing the management authority to other cooperative personnel by the administrator, so that the other cooperative personnel carry out authority management. As shown in fig. 1, the administrator creates or uploads a workbook, then the administrator performs authority sharing, and records the authority setting result to the administrator data table.

After entering from a design entrance, a workbook manager queries all workbooks with management authority from a database workbook authority data table according to the current login user ID by a background and displays the workbooks in a page in a list form. And the workbook manager manages the authority of the workbooks in the list, displays all the collaborators in the list, selects the collaborators endowed with the workbook editing authority, and stores the user IDs and the workbook IDs of the authorized collaborators into a workbook authority data table. Wherein the default newly created workbook is invisible to all collaborators except the administrator. As shown in fig. 2, the administrator enters the design page, queries the workbook with management authority according to the administrator user ID, authorizes the collaborators, and stores the authorized user ID and the workbook ID in the workbook authority data table.

And after a workbook administrator opens a workbook at a design entrance, the administrator sets the authority of the worksheet, acquires all the worksheets of the workbook, acquires the collaborators with the workbook marking authority, displays the collaborators in a list, and sets the editing, reading-only and invisible working authorities. And after the work authority setting is finished, storing the workbook ID, the worksheet ID, the authority type and the collaborator user ID into a data sheet corresponding to the worksheet authority. Wherein collaborators for which the workbook has editing rights default to the editing rights. As shown in fig. 3, the administrator opens the workbook, queries and lists all workbooks and all users having the editing right of the workbook, performs workbook editing, read-only or invisible right setting on the users, and stores the set records in the data table corresponding to the worksheet right.

And after the cooperative personnel enter from the cooperative entry, the background searches all workbooks with editing authority according to the user IDs of the cooperative personnel to display the list. When the cooperative staff open the workbooks in the list, the background inquires all corresponding worksheet authorities according to the workbook ID and the cooperative staff user ID, and the front end controls the editing, read-only or invisible of all the workbooks according to the result returned by the background. As shown in fig. 4, the collaborator opens the collaboration entry page, background queries and returns the workbook with editing right, the collaborator opens the workbook, background queries and returns all worksheet rights, and the front end controls editing, read-only or invisible of the worksheet.

The above-described embodiments are merely preferred embodiments of the present invention, and general changes and substitutions by those skilled in the art within the technical scope of the present invention are included in the protection scope of the present invention.

Claims

1. A form collaboration tool, comprising: the method comprises a design entry and a collaborative entry, wherein collaborative personnel create workbooks and set authorities from the design entry, and meanwhile, the collaborative personnel view the contents of the workbooks with the authorities from the collaborative entry.

2. A permission design method of a form collaboration tool is characterized in that: the method is realized based on the form collaboration tool of claim 1, each collaboration person can be used as an administrator for creating the workbook, and the administrator manages the authority of the workbook and the worksheet.

3. The method for designing authority of form collaboration tool as claimed in claim 2, wherein: and sharing the management authority to other cooperative personnel by the administrator, so that the other cooperative personnel carry out authority management.

4. The method for designing authority of form collaboration tool as claimed in claim 3, wherein: after entering from a design entrance, a workbook manager queries all workbooks with management authority from a database workbook authority data table according to the current login user ID by a background and displays the workbooks in a page in a list form.

5. The method for designing authority of form collaboration tool as claimed in claim 4, wherein: and the workbook manager manages the authority of the workbooks in the list, displays all the collaborators in the list, selects the collaborators endowed with the workbook editing authority, and stores the user IDs and the workbook IDs of the authorized collaborators into a workbook authority data table.

6. The method for designing authority of form collaboration tool as claimed in claim 5, wherein: and after a workbook administrator opens a workbook at a design entrance, the administrator sets the authority of the worksheet, acquires all the worksheets of the workbook, acquires the collaborators with the workbook marking authority, displays the collaborators in a list, and sets the editing, reading-only and invisible working authorities.

7. The method for designing authority of form collaboration tool as claimed in claim 6, wherein: and after the work authority setting is finished, storing the workbook ID, the worksheet ID, the authority type and the collaborator user ID into a data sheet corresponding to the worksheet authority.

8. The method for designing authority of form collaboration tool as claimed in claim 7, wherein: and after the cooperative personnel enter from the cooperative entry, the background searches all workbooks with editing authority according to the user IDs of the cooperative personnel to display the list.

9. The method for designing authority of form collaboration tool as claimed in claim 8, wherein: when the cooperative staff open the workbooks in the list, the background inquires all corresponding worksheet authorities according to the workbook ID and the cooperative staff user ID, and the front end controls the editing, read-only or invisible of all the workbooks according to the result returned by the background.