Cell permission updating method and device, equipment and storage medium
By responding to user's permission update request in the permission table, determining the functional cell type and performing corresponding permission updates, the problem of insufficient selectivity for cell permission updates in the existing technology is solved, and diversified permission updates and updates are achieved. Good user experience.
Patent Information
- Application Number
- CN202411599935.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-11-11
- Publication Date
- 2025-02-11
AI Technical Summary
The modification or update of cell permissions in existing tables is not diverse enough to meet the user's multiple update needs, resulting in poor user experience.
Provides a cell permission update method to determine the functional cell type by responding to a user's permission update request in a pre-built permission table. If it is a role cell, all permission cells are updated; if it is a batch modified cell, the user can batch select the target row and/or the target column and update according to the batch permission value.
It realizes diversified permission update selection, meets users' different update needs, enhances user experience, and expands the scope of application.
Smart Images
Figure CN119416243A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the technical field of cell permission update, and in particular to a cell permission update method, device, equipment and storage medium. Background Art
[0002] Nowadays, digital office has been deeply applied to all walks of life, with spreadsheets being the most prominent. Spreadsheets are a powerful data processing tool that can be used for business management, assessment statistics, financial analysis, scientific research data processing, etc. In complex business scenarios, accurate management of permissions for each cell in the spreadsheet becomes crucial. As the importance of data continues to increase, different users often require different levels of access and operating permissions when processing spreadsheets. For example, access to certain sensitive data may need to be strictly restricted to ensure data security and confidentiality; for example, in a collaborative work environment, people from different departments may need different permissions to enter, edit or view cell data in a specific area to improve work efficiency and avoid erroneous operations.
[0003] The existing options for modifying or updating the permissions of cells in a table are not diverse enough, and often cannot meet the multi-mode or multi-select update requirements of users, resulting in a poor user experience. Summary of the invention
[0004] In view of this, the present application provides a cell permission update method, apparatus, device and storage medium to solve the problem that the existing options for modifying or updating cell permissions in a table are not diverse enough, often cannot meet the user's requirements for multi-mode or multi-select updates, and have a poor user experience.
[0005] To achieve the above objectives, the proposed solution is as follows:
[0006] In a first aspect, a method for updating cell permissions includes:
[0007] In response to a request instruction for updating permissions initiated by a user in a pre-built permissions table, determining a functional cell corresponding to the request instruction;
[0008] If the functional cell is a role cell, obtaining the role ID newly selected by the user, and updating all the permission cells in the permission table using the newly selected role ID;
[0009] If the functional cell is a batch modification cell, the user is provided with batch selection of target rows and / or target columns;
[0010] The batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value.
[0011] Preferably, the process of constructing the permission table includes:
[0012] Set the number of rows and columns to form each permission cell;
[0013] Set functional cells for each row of permission cells and each column of permission cells respectively, and set role cells separately;
[0014] Defining a sequence number field, a content field and a permission field for each of the permission cells and functional cells to obtain a blank table template;
[0015] Defining a plurality of role IDs for the role cell, and setting a corresponding authority value for each of the role IDs;
[0016] Based on each of the role IDs and the corresponding permission values, permission configuration is performed on each permission cell in the blank table template to obtain a constructed permission table.
[0017] Preferably, setting a corresponding permission value for each role ID includes:
[0018] Define multiple permission values and obtain user permission requirements;
[0019] For each of the role IDs, a corresponding authority value is selected from the authority values according to the user authority requirement;
[0020] The role ID is combined with the corresponding permission value.
[0021] Preferably, the permission configuration of each permission cell in the blank table template is performed based on each of the role IDs and the corresponding permission values to obtain a constructed permission table, including:
[0022] For each of the permission cells, setting a role ID for the permission cell;
[0023] Define a callback method, and use the callback method to extract the permission value corresponding to the role ID, the row value of the cell, and the column value of the cell;
[0024] Using the row value and column value, locate the cell in the blank table template;
[0025] After locating, the permission value corresponding to the role ID is used to configure the permission of the permission cell.
[0026] Preferably, the updating of all permission cells in the permission table using the newly selected role ID includes:
[0027] For each of the permission cells, obtaining a current permission value of the permission cell as a first permission value;
[0028] Determine the permission value corresponding to the newly selected role ID as the second permission value;
[0029] The first permission value is updated to the second permission value.
[0030] Preferably, updating each permission cell corresponding to each target row and / or each target column based on the batch permission value includes:
[0031] Determine and select each of the target rows and / or each of the target columns selected in batches by the user;
[0032] The batch permission values are used to update the permission cells corresponding to the target rows and / or the target columns.
[0033] Preferably, the determining and selecting each of the target rows and / or each of the target columns selected in batches by the user comprises:
[0034] Set the first row parameters and the second row parameters;
[0035] Determine the first serial number of each permission cell in each target row selected by the user in batches by using the first row parameter and the second row parameter;
[0036] Storing each of the first serial numbers into a preset first variable;
[0037] Set the first column parameters and the second column parameters;
[0038] Determine the second serial number of each permission cell in each target column selected by the user in batches by using the first column parameter and the second column parameter;
[0039] storing each of the second serial numbers into a preset second variable;
[0040] The first variable and the second variable are used to batch select the permission cells corresponding to the first cell and the second cell respectively.
[0041] In a second aspect, a cell authority updating device includes:
[0042] A response module, configured to respond to a request instruction for updating permissions initiated by a user in a pre-built permission table, and determine a functional cell corresponding to the request instruction;
[0043] A first updating module, configured to obtain a role ID newly selected by the user if the functional cell is a role cell, and update all permission cells in the permission table using the newly selected role ID;
[0044] A target row and column selection module, for allowing the user to batch select each target row and / or each target column if the functional cell is a batch modification cell;
[0045] The second updating module is used to determine the batch permission value selected by the user, and update each permission cell corresponding to each target row and / or each target column based on the batch permission value.
[0046] In a third aspect, a cell permission update device includes a memory and a processor;
[0047] The memory is used to store programs;
[0048] The processor is used to execute the program to implement each step of the cell permission updating method as described in any one of the first aspects.
[0049] In a fourth aspect, a storage medium stores a computer program thereon, and when the computer program is executed by a processor, the steps of the cell permission update method as described in any one of the first aspects are implemented.
[0050] It can be seen from the above technical scheme that the present application determines the functional cell corresponding to the request instruction for permission update initiated by the user in the pre-built permission table; if the functional cell is a role cell, the newly selected role ID of the user is obtained, and all the permission cells in the permission table are updated using the newly selected role ID; if the functional cell is a batch modification cell, the user is provided with batch selection of each target row and / or each target column; the batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value. The present application allows users to select according to their needs. Users can click on functional cells with different functions to trigger different permission update processes, including updating all permission cells in the permission table based on the role cell, and also including determining the target row and / or target column selected by the user based on the batch modification cell, and batch updating the target row and / or target column, thereby meeting the different update needs of users, enhancing user experience, and expanding the scope of application. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying creative work.
[0052] Figure 1 An optional flow chart of a cell permission update method provided in an embodiment of the present application;
[0053] Figure 2 A schematic diagram of a permission table provided for an embodiment of the present application;
[0054] Figure 3 A schematic diagram of a code flow provided for an embodiment of the present application;
[0055] Figure 4 A schematic diagram of another permission table provided in an embodiment of the present application;
[0056] Figure 5 A schematic diagram of a pop-up window provided in an embodiment of the present application;
[0057] Figure 6 A schematic diagram of the structure of a cell authority updating device provided in an embodiment of the present application;
[0058] Figure 7 A schematic diagram of the structure of a cell permission update device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0059] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, not all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of this application.
[0060] The embodiment of the present invention provides a method for updating cell permissions. The method can be applied to various computer terminals or smart terminals. The execution subject can be a processor or server of the computer terminal or smart terminal. The method flow chart of the method is as follows: Figure 1 As shown, specifically including:
[0061] S1: In response to a request instruction for updating permissions initiated by a user in a pre-built permission table, a functional cell corresponding to the request instruction is determined.
[0062] The permission table in this application is pre-built. The permission table can be regarded as a table specifically used to control the permission content. For example, for a permission table in the e-commerce field, the construction process of the permission table is as follows:
[0063] It includes four employee identities, namely ordinary employees, platform line managers, and dual-line managers. Different employees have different identities, and different identities correspond to different permissions.
[0064] Set the number of rows and columns of the permission table to form multiple permission cells, and set a title for each row and column. Each title can also be used as a cell, and permissions are configured for each permission cell. You can use the table component and the Select component to display the permission table. Each cell contains a select component with four permissions to choose from. This application uses permission values to represent permissions. For example, 1, 2, 3, and 4 represent four different permissions, namely required, optional, view only, and non-viewable. The data format of each cell is an object, and the object attribute is the role ID, and the value is the permission value. For example, the permissions of a cell are as follows:
[0065]
[0066] All cell objects are stored in an array, and each item represents a cell. The data format of the entire permission table is as follows:
[0067]
[0068] As shown in the above code, it represents the data structure of a row module. It is an array structure. Each item in the array represents a row module. A module may have multiple rows. Title represents the title of this module. RowContent represents the rows in this module. It is also an array. The number of items represents the number of rows. RowData represents cells. It is also an array. Each item represents a cell. The number of cells depends on the number of columns.
[0069] The permission table constructed according to the above process is as follows Figure 2 As shown, the role ID of the table is ordinary employee, and the titles of each row and column include value expression, indicator definition, data source, data collection caliber, and scoring rules.
[0070] When a user needs to change cell permissions, he can click in the permission table to initiate an instruction. Then, in response to the permission update request instruction initiated by the user in the permission table, the functional cell corresponding to the request instruction can be determined first, such as determining the functional cell corresponding to the user's click position. A functional cell is a cell that can determine the user's update intention, including but not limited to role cells and batch modification cells. Next, different permission updates can be performed based on different user choices.
[0071] S2: If the functional cell is a role cell, obtain the role ID newly selected by the user, and use the newly selected role ID to update all the permission cells in the permission table.
[0072] If the functional cell selected by the user is a role cell, it can be considered that the user wants to update the corresponding permissions by changing the current role ID. This is because different role IDs correspond to different permission values. If different role IDs correspond to different permission values, the updated permission values will also change.
[0073] S3: If the functional cell is a batch modification cell, the user is provided with batch selection of target rows and / or target columns.
[0074] If the functional cell selected by the user is a batch modification cell, it can be considered that the user wants to update the permission values in batches, such as selecting one or more rows of cells, or selecting one or more columns of cells, and updating them in batches, which can save update time and improve efficiency.
[0075] S4: Determine the batch permission value selected by the user, and update each permission cell corresponding to each target row and / or each target column based on the batch permission value.
[0076] The batch permission value is the permission value that the user wants to update uniformly for the batch selected rows and / or columns, that is, the current permission value of each row and / or column is updated to the batch permission value.
[0077] It can be seen from the above technical scheme that the present application determines the functional cell corresponding to the request instruction for permission update initiated by the user in the pre-built permission table; if the functional cell is a role cell, the newly selected role ID of the user is obtained, and all the permission cells in the permission table are updated using the newly selected role ID; if the functional cell is a batch modification cell, the user is provided with batch selection of each target row and / or each target column; the batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value. The present application allows users to select according to their needs. Users can click on functional cells with different functions to trigger different permission update processes, including updating all permission cells in the permission table based on the role cell, and also including determining the target row and / or target column selected by the user based on the batch modification cell, and batch updating the target row and / or target column, thereby meeting the different update needs of users, enhancing user experience, and expanding the scope of application.
[0078] In the method provided in the embodiment of the present invention, the process of constructing the permission table is specifically described as follows:
[0079] Set the number of rows and columns to form each permission cell;
[0080] Set functional cells for each row of permission cells and each column of permission cells respectively, and set role cells separately;
[0081] Defining a sequence number field, a content field and a permission field for each of the permission cells and functional cells to obtain a blank table template;
[0082] Defining a plurality of role IDs for the role cell, and setting a corresponding authority value for each of the role IDs;
[0083] Based on each of the role IDs and the corresponding permission values, permission configuration is performed on each permission cell in the blank table template to obtain a constructed permission table.
[0084] Specifically, first, the number of rows and columns can be set according to user needs, such as according to the number of titles of the permission table. After setting, multiple permission cells are formed. It can be understood that each row or column of the permission table will correspond to a title. In this application, the cell where the title is located is used as a functional cell, and the role cell is a corresponding role ID in a permission table. Therefore, a permission table will contain a role cell, multiple functional cells and multiple permission cells. After setting the above-mentioned multiple cells, it is also necessary to set the content, including defining the serial number field columnIndex for the permission cell and the functional cell (each serial number represents the position of this cell in this row, and the back end can also be sorted according to this field), Content field data and permission field dataPermission; for role cells, multiple role IDs can be set for them, and corresponding permission values can be set for each role ID. Since the permission table will have different permission values in different processes, such as the permission table listed in S1 above, some permissions are not viewable or can only be viewed but not edited for certain roles. Therefore, this application can implement different permissions for different cells, and the permission values corresponding to each role ID are composed into an object. The key value represents the role ID, and the value value represents the permission ID (i.e., the permission value). When setting permissions for a permission cell, the permission value is assigned to the corresponding role ID, so that permissions can be updated and rendered according to different permission cells. The permission field is an object that stores permission values. Each permission cell will have an object to store permission values. Then, based on each role ID and its corresponding permission value, the permissions of each permission cell in the blank table template can be configured to obtain a constructed permission table.
[0085] The process of setting a corresponding permission value for each role ID may include:
[0086] Define multiple permission values and obtain user permission requirements;
[0087] For each of the role IDs, a corresponding authority value is selected from the authority values according to the user authority requirement;
[0088] The role ID is combined with the corresponding permission value.
[0089] Specifically, users can set multiple permission values according to project, assessment and other requirements, and each user ID can correspond to one or more permission values. For example, for a role ID, if a functional cell is "Indicator Definition", then the permission value of the role ID under the functional cell is "4"; if a functional cell is "Data Source", then the permission value of the role ID under the functional cell is "1", so the role ID corresponds to at least two permission values. Therefore, the role ID is combined with the corresponding permission value to achieve the corresponding purpose, and it can be displayed accordingly in the permission table.
[0090] The process of performing permission configuration on each permission cell in the blank table template based on each role ID and each corresponding permission value to obtain a constructed permission table may specifically include:
[0091] For each of the permission cells, setting a role ID for the permission cell;
[0092] Define a callback method, and use the callback method to extract the permission value corresponding to the role ID, the row value of the cell, and the column value of the cell;
[0093] Using the row value and column value, locate the cell in the blank table template;
[0094] After locating, the permission value corresponding to the role ID is used to configure the permission of the permission cell.
[0095] Specifically, for each permission cell, first set the role ID for the permission cell. After the select component in the permission cell selects the corresponding permission value, you can define a callback method to trigger the onChange event of the select component. The onChange event will pass in three parameters: the permission value corresponding to the role ID, the row value of the row where the cell is located, and the column value of the column where it is located. Through these parameters, you can modify the array index and locate the corresponding position of the permission cell in the array to achieve the purpose of permission configuration.
[0096] When traversing and displaying permission values in the permission table, you can also first set a variable curRole to obtain the role ID currently corresponding to each permission cell, and then assign the role ID to the variable. The role ID corresponds to the attribute in dataPermission. The corresponding permission value will be selected from dataPermission for each role ID and displayed using the select component. A method defaultAuth can be defined to implement this, and three parameters are passed in, namely _rowIndex: row coordinates, _cellIndex: column coordinates, and _index: the module number. These three parameters are used to locate the permission cell.
[0097] The following is a detailed description of the steps of updating all the permission cells in the permission table using the newly selected role ID in the present application.
[0098] For each of the permission cells, obtaining a current permission value of the permission cell as a first permission value;
[0099] Determine the permission value corresponding to the newly selected role ID as the second permission value;
[0100] The first permission value is updated to the second permission value.
[0101] Specifically, each permission cell currently has a corresponding role ID and a corresponding permission value. If the user newly selects a different role ID, all permission cells in the permission table need to be updated. Focus on a permission cell, obtain the current permission value of the permission cell as the first permission value, and then determine the permission value corresponding to the newly selected role ID as the second permission value, and then update the first permission value of the permission cell to the second permission value. For example, you can select other role IDs through the drop-down in the permission table. After the selection, the value of curRole will also be updated accordingly. Since the display of the permission table is bound to curRole, when the value of curRole is updated, the defaultAuth method can be used to update the permission value of each permission cell in the permission table. The relevant code diagram is as follows: Figure 3 shown.
[0102] Furthermore, the process of updating each permission cell corresponding to each target row and / or each target column based on the batch permission value of the present application may specifically include:
[0103] Determine and select each of the target rows and / or each of the target columns selected in batches by the user;
[0104] The batch permission values are used to update the permission cells corresponding to the target rows and / or the target columns.
[0105] Wherein, the determining and selecting each of the target rows and / or each of the target columns selected in batches by the user includes:
[0106] Set the first row parameters and the second row parameters;
[0107] Determine the first serial number of each permission cell in each target row selected by the user in batches by using the first row parameter and the second row parameter;
[0108] Storing each of the first serial numbers into a preset first variable;
[0109] Set the first column parameters and the second column parameters;
[0110] Determine the second serial number of each permission cell in each target column selected in batch by the user by using the first column parameter and the second column parameter;
[0111] storing each of the second serial numbers into a preset second variable;
[0112] The first variable and the second variable are used to batch select the permission cells corresponding to the first cell and the second cell respectively.
[0113] Specifically, the present application can provide a batch update function, which is convenient for users to set the same new permission value for the permission cells of rows / columns at one time, which can reduce repeated operations, save time and improve efficiency. In the implementation process, a checkBox component can be added before the functional cells of the title type, and the callback when the checkBox component is selected can be used to determine which cells are selected.
[0114] For the method of selecting the target row, set the first row parameter e and the second row parameter rowIndex, and can also include the third row parameter _index. The first row parameter indicates selection / unselection, the second row parameter indicates the row number, and the third row parameter indicates the module number. After one or more rows are selected, the first serial number of each permission cell in each target row is stored in the first variable rowSelects. rowSelects can be regarded as an array, and the array and the includes method can be used to determine the permission cells in each target row selected in batches.
[0115] For the method of selecting the target column, set the first column parameter e and the second column parameter columnIndex. The first column parameter indicates selection / unselection, and the second column parameter indicates the column number. After one or more columns are selected, the second serial number of each permission cell in each target column is stored in the second variable colUmnSelects. You can also regard colUmnSelects as an array, and use the array and the includes method to determine the permission cells in each target column selected in batches.
[0116] Specific as Figure 4 As shown, the user can click on the batch edit cell from the current interface shown in the figure. The cell is a functional cell and pops up the following Figure 5 In the window shown, after the permission selection (permission value selection) is completed, click Confirm, and you can see that the target rows selected by the user are the third and fifth rows, and the target columns are the second and fourth columns. Then you can call the onFinish method to modify the permission values of each permission cell in the selected target rows and columns. The onFinish method will pass in the selected permission value, and traverse the target rows and columns through colUmnSelects and rowSelects. When the sequence number (the first sequence number or the second sequence number) of the permission cell in the target row and column is in colUmnSelects and rowSelects, the permission value of the permission cell will be modified to the new permission value selected by the user in the pop-up window.
[0117] and Figure 1 Corresponding to the method described above, the embodiment of the present invention also provides a cell authority updating device for updating Figure 1 In the specific implementation of the method, the cell authority updating device provided in the embodiment of the present invention can be used in a computer terminal or various mobile devices, combined with Figure 6 , introduce the cell permission update device, such as Figure 6 As shown, the device may include:
[0118] A response module 10, configured to respond to a request instruction for updating permissions initiated by a user in a pre-built permission table, and determine a functional cell corresponding to the request instruction;
[0119] A first updating module 20, configured to obtain a role ID newly selected by the user if the functional cell is a role cell, and update all permission cells in the permission table using the newly selected role ID;
[0120] A target row and column selection module 30 is used for allowing the user to batch select each target row and / or each target column if the functional cell is a batch modification cell;
[0121] The second updating module 40 is used to determine the batch permission value selected by the user, and update each permission cell corresponding to each target row and / or each target column based on the batch permission value.
[0122] It can be seen from the above technical scheme that the present application determines the functional cell corresponding to the request instruction for permission update initiated by the user in the pre-built permission table; if the functional cell is a role cell, the newly selected role ID of the user is obtained, and all the permission cells in the permission table are updated using the newly selected role ID; if the functional cell is a batch modification cell, the user is provided with batch selection of each target row and / or each target column; the batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value. The present application allows users to select according to their needs. Users can click on functional cells with different functions to trigger different permission update processes, including updating all permission cells in the permission table based on the role cell, and also including determining the target row and / or target column selected by the user based on the batch modification cell, and batch updating the target row and / or target column, thereby meeting the different update needs of users, enhancing user experience, and expanding the scope of application.
[0123] Furthermore, the embodiment of the present application provides a cell authority update device. Optionally, Figure 7 The hardware structure diagram of the cell authority update device is shown in FIG. Figure 7 The hardware structure of the cell authority update device may include: at least one processor 01, at least one communication interface 02, at least one memory 03 and at least one communication bus 04.
[0124] In the embodiment of the present application, the number of the processor 01 , the communication interface 02 , the memory 03 , and the communication bus 04 is at least one, and the processor 01 , the communication interface 02 , and the memory 03 communicate with each other through the communication bus 04 .
[0125] The processor 01 may be a central processing unit (CPU), or an application specific integrated circuit (ASIC), or one or more integrated circuits configured to implement the embodiments of the present invention.
[0126] The memory 03 may include a high-speed RAM memory, and may also include a non-volatile memory (non-volatile memory), etc., such as at least one disk memory.
[0127] The memory stores a program, and the processor can call the program stored in the memory, and the program is used to execute the following cell permission update method, including:
[0128] In response to a request instruction for updating permissions initiated by a user in a pre-built permissions table, determining a functional cell corresponding to the request instruction;
[0129] If the functional cell is a role cell, obtaining the role ID newly selected by the user, and updating all the permission cells in the permission table using the newly selected role ID;
[0130] If the functional cell is a batch modification cell, the user is provided with batch selection of target rows and / or target columns;
[0131] The batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value.
[0132] Optionally, the detailed functions and extended functions of the program may refer to the description of the cell permission updating method in the method embodiment.
[0133] The embodiment of the present application further provides a storage medium, which may store a program suitable for execution by a processor, and when the program is running, controls the device where the storage medium is located to execute the following cell permission update method, including:
[0134] In response to a request instruction for updating permissions initiated by a user in a pre-built permissions table, determining a functional cell corresponding to the request instruction;
[0135] If the functional cell is a role cell, obtaining the role ID newly selected by the user, and updating all the permission cells in the permission table using the newly selected role ID;
[0136] If the functional cell is a batch modification cell, the user is provided with batch selection of target rows and / or target columns;
[0137] The batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value.
[0138] Specifically, the storage medium may be a computer-readable storage medium, and the computer-readable storage medium may be an electronic memory such as a flash memory, an EEPROM (Electrically Erasable Programmable Read-Only Memory), an EPROM, a hard disk or a ROM.
[0139] Optionally, the detailed functions and extended functions of the program may refer to the description of the cell permission updating method in the method embodiment.
[0140] In addition, the functional modules in the various embodiments of the present disclosure can be integrated together to form an independent part, or each module can exist separately, or two or more modules can be integrated to form an independent part. If the function is implemented in the form of a software functional module and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present disclosure is essentially or the part that contributes to the prior art or the part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes a number of instructions for a computer device (which can be a personal computer, a live broadcast device, or a network device, etc.) to perform all or part of the steps of the methods of the various embodiments of the present disclosure.
[0141] Finally, it should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the presence of other identical elements in the process, method, article or device including the elements.
[0142] The various embodiments in this specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same or similar parts between the various embodiments can be referenced to each other.
[0143] The above description of the disclosed embodiments enables those skilled in the art to implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.
Claims
1. A method for updating cell permissions, characterized in that: include: In response to a request instruction for updating permissions initiated by a user in a pre-built permissions table, determining a functional cell corresponding to the request instruction; If the functional cell is a role cell, obtaining the role ID newly selected by the user, and updating all the permission cells in the permission table using the newly selected role ID; If the functional cell is a batch modification cell, the user is provided with batch selection of target rows and / or target columns; The batch permission value selected by the user is determined, and each permission cell corresponding to each target row and / or each target column is updated based on the batch permission value.
2. The method according to claim 1, characterized in that The process of constructing the permission table includes: Set the number of rows and columns to form each permission cell; Set functional cells for each row of permission cells and each column of permission cells respectively, and set role cells separately; Defining a sequence number field, a content field and a permission field for each of the permission cells and functional cells to obtain a blank table template; Defining a plurality of role IDs for the role cell, and setting a corresponding authority value for each of the role IDs; Based on each of the role IDs and the corresponding permission values, permission configuration is performed on each permission cell in the blank table template to obtain a constructed permission table.
3. The method according to claim 2, characterized in that The setting of a corresponding permission value for each role ID includes: Define multiple permission values and obtain user permission requirements; For each of the role IDs, a corresponding authority value is selected from the authority values according to the user authority requirement; The role ID is combined with the corresponding permission value.
4. The method according to claim 2, characterized in that: The permission configuration is performed on each permission cell in the blank table template based on each role ID and each corresponding permission value to obtain a constructed permission table, including: For each of the permission cells, setting a role ID for the permission cell; Define a callback method, and use the callback method to extract the permission value corresponding to the role ID, the row value of the cell, and the column value of the cell; Using the row value and column value, locate the cell in the blank table template; After locating, the permission value corresponding to the role ID is used to configure the permission of the permission cell.
5. The method according to claim 1, characterized in that The updating of all permission cells in the permission table using the newly selected role ID includes: For each of the permission cells, obtaining a current permission value of the permission cell as a first permission value; Determine the permission value corresponding to the newly selected role ID as the second permission value; The first permission value is updated to the second permission value.
6. The method according to claim 1, characterized in that The updating of each permission cell corresponding to each target row and / or each target column based on the batch permission value includes: Determine and select each of the target rows and / or each of the target columns selected in batches by the user; The batch permission values are used to update the permission cells corresponding to the target rows and / or the target columns.
7. The method according to claim 6, characterized in that The determining and selecting each of the target rows and / or each of the target columns selected in batches by the user includes: Set the first row parameters and the second row parameters; Determine the first serial number of each permission cell in each target row selected by the user in batches by using the first row parameter and the second row parameter; Storing each of the first serial numbers into a preset first variable; Set the first column parameters and the second column parameters; Determine the second serial number of each permission cell in each target column selected in batch by the user by using the first column parameter and the second column parameter; storing each of the second serial numbers into a preset second variable; The first variable and the second variable are used to batch select the permission cells corresponding to the first cell and the second cell respectively.
8. A cell authority updating device, characterized in that: include: A response module, configured to respond to a request instruction for updating permissions initiated by a user in a pre-built permission table, and determine a functional cell corresponding to the request instruction; A first updating module, configured to obtain a role ID newly selected by the user if the functional cell is a role cell, and update all permission cells in the permission table using the newly selected role ID; A target row and column selection module, for allowing the user to batch select each target row and / or each target column if the functional cell is a batch modification cell; The second updating module is used to determine the batch permission value selected by the user, and update each permission cell corresponding to each target row and / or each target column based on the batch permission value.
9. A cell authority updating device, characterized in that: including memory and processor; The memory is used to store programs; The processor is used to execute the program to implement each step of the cell permission updating method as described in any one of claims 1 to 7.
10. A storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, each step of the cell permission updating method as described in any one of claims 1 to 7 is implemented.