Data authority management method based on road detection data management system

Abstract

The invention discloses a data authority management method based on a road detection data management system. The method comprises the following steps: step 1, role function page and function button authority endowing; step 2, role data authority endowing; step 3, user role endowing; according to the method disclosed by the invention, radar original detection data and processed radar disease data are taken as input, a user-role-function-data four-level permission model is established, data and system security can be better protected through multi-layer permission control, and risks of data leakage and abuse are reduced.

Description

Technical Field

[0001] The present invention belongs to the field of shallow surface space and target detection, and in particular relates to a data authority management method based on a road detection data management system in this field. Background Art

[0002] In the field of shallow surface space and target detection, ground penetrating radar ultra-wideband high-frequency electromagnetic waves are used to inject low-loss media, and the changes in electrical parameters such as dielectric constant and conductivity trigger changes in echo energy to achieve underground target detection and positioning. With the development of ground penetrating radar technology and the generation of massive detection data, the requirements for data and system security are becoming increasingly higher based on responsibilities and permissions. Optimizing software function pages, function button permissions, and data permissions to reduce management confusion and data leakage and abuse have become issues that need to be addressed. Summary of the invention

[0003] The technical problem to be solved by the present invention is to provide a data authority management method based on a road detection data management system. By providing the functions of granting authority to role function pages and function buttons, granting authority to role data, granting user roles, and dynamically generating user login function pages and buttons, a four-level authority model of user-role-function-data is established to achieve a fine division of organizational responsibilities and authorities and a fine management of radar data, ensuring that the selected radar data is only allowed to be browsed and operated by users with designated roles, ensuring data usage security, and improving overall efficiency.

[0004] The present invention adopts the following technical solution: A data authority management method based on a road detection data management system, the improvement of which is that it includes the following steps: Step 1: Grant permissions to the role function page and function buttons: When a role is created, all function pages managed in the system and the function buttons in the function pages are displayed in a multi-select tree list below it. Select multiple function pages and function buttons in the pages to grant permissions to the role function pages and function buttons in the role function pages. Step 2: Grant role data permissions: Visit the radar data management function page, select the data for which you want to set permissions, click the "Data Permissions" button, and under the selected data, file or folder, all roles in the system and the default permissions of the roles to the data will be displayed in a list. Click the operation button, select whether the data is visible or invisible in the pop-up drop-down box, and click OK; Step 3: Assign user roles: When creating a user, in addition to entering the user name and password, all the role information in the system is displayed in a multi-select list below the user. Click one or more roles and click OK. Step 4: Dynamically generate the user login function page and button: The system matches the information in the user information table based on the entered user name and password information. If the match fails, the system refuses to log in. If the match succeeds, the system searches for permissions based on the user, queries the function permissions based on the permissions, and dynamically generates the function pages visible within the user permissions and the function buttons within the function pages; Step 5, view user permission data: According to the data permissions set for roles in the system, when a user logs in and clicks on the data management page within the permissions, the system returns the data that is granted visible permissions to the role to which the user belongs based on the query conditions. Data with invisible permissions is not displayed on the page.

[0005] Furthermore, step 1 includes function page and function button data entry, system function page and function button query, and role authority assignment.

[0006] Furthermore, the steps for entering data for function pages and function buttons are as follows: first, click the function page and button management function page, click the Add button, select the data type as function page or function button, and enter the data. For the function page, the request address and resource path must be set, and for the function button, the parent node must be selected to determine the parent-child relationship, that is, to determine the function page where the function button is located; The steps of querying the system function page and function button are as follows: the system performs data query in the function page and function button data table, queries all visible function pages and function buttons and their parent-child relationships, and generates a multi-select function page and button tree on the interface; The steps for assigning role permissions are as follows: On the role management page, click the Add button, enter the role name, and then in the multi-select tree list below, select multiple function pages and function buttons on the pages. After clicking OK, the system will establish an association between the role and the function, and record the role permission data in the role function permission data table.

[0007] Furthermore, step 2 includes road detection data import, road detection data query and role data permission assignment.

[0008] Further, the road detection data importing steps are as follows: the road detection data importing is divided into structured and unstructured data. When the structured data is imported, click the road damage data management function page, click the import button, select the road damage data file to be imported from the hard disk, and then read the structured data in batches, and insert the data into the corresponding data information table one by one; when the unstructured data is imported, read the structured parameters from the parameter description file, insert them into the corresponding data information table, and copy the folder data as a whole to the system default directory, and at the same time, add the directory location of the folder and the hierarchical relationship between the folder and the sub-files to the database file information hierarchical relationship table; The steps for querying road detection data are as follows: click on the radar data management function page, set the query conditions, and directly display the data in the form of a list after querying the radar data that meets the conditions from the database table. Among them, the unstructured data should also be supplemented with matching folders and file icons according to the nature of the queried data. Click on a folder in the list data to display the next level of data according to the folder hierarchy relationship; The steps for assigning role data permissions are as follows: select a certain data that has been queried, click the "Data Permissions" button, the page will jump, and under the selected data, file or folder, the system will query all role information in the role information table, and display all roles in the system and the role's default permissions for the data in a list. Click the operation button, select whether the data is visible or invisible in the drop-down box that pops up, and click OK. The system will establish an association between the role and the data, and record the role data permissions in the role data permissions table.

[0009] Furthermore, step 3 includes role data query and user role assignment; The steps of role data query are: query all role information in the role information table of the database and display it in the form of a multiple-selection list; The steps for assigning user roles are as follows: when a user is created, in addition to entering the user name and password, select one or more roles in the role information multi-select list below the user, click OK, and the system will establish an association between the user and the role, and record the user role data in the user role data table.

[0010] Furthermore, step 4 includes user login verification and dynamic generation of user function pages and function buttons.

[0011] Furthermore, the user login verification step is as follows: the system checks whether the user exists in the database user information table based on the user name and password information entered on the login page. If the user does not exist, the login is directly rejected. If the user exists, the user name and password are encrypted according to the hash encryption algorithm and then matched with the password information stored in the user information table. If the match fails, the system rejects the login. If the match succeeds, the subsequent steps are carried out. The steps for dynamically generating user function pages and function buttons are as follows: after the user logs in successfully, the system queries the user's assigned role ID array in the user role data table based on the user ID, and then queries the role's assigned function pages and function buttons in the role function permission data table based on the role ID. Multiple role functions are taken as the union, and the system uses dynamic routing technology to dynamically generate function pages visible within the user's permissions and function buttons within the function pages based on the queried function page and function button data and their parent-child relationships.

[0012] Furthermore, step 5 includes general data query and permission data query.

[0013] Furthermore, the steps of ordinary data query are as follows: after the user logs in, he clicks on the radar data management page within the authority to browse the radar data, and the system organizes the query statement to query the data according to the query conditions set in the interface; The steps for querying permission data are as follows: the system queries the user's assigned role ID array in the user role data table based on the user ID, and then queries the role's assigned visible permission data information in the role data permission data table based on the role ID, and takes the union of multiple role data; the two query results take the intersection, return the query results and display the radar data information within the queried permission in list form.

[0014] The beneficial effects of the present invention are: The method disclosed in the present invention uses radar original detection data and processed radar disease data as input to establish a four-level permission model of user-role-function-data. Through multi-layer permission control, data and system security can be better protected and the risk of data leakage and abuse can be reduced; role setting can better divide the responsibilities and permissions of the organization, form a clear organizational structure, and reduce management chaos; achieve more refined management and collaboration, avoid conflicts, better work together, and improve overall efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 It is a schematic flow diagram of the method of the present invention; Figure 2 It is a schematic flow diagram of step 1 of the method of the present invention; Figure 3 It is a schematic flow diagram of step 2 of the method of the present invention; Figure 4 It is a schematic flow diagram of step 3 of the method of the present invention; Figure 5 is a schematic flow diagram of step 4 of the method of the present invention; Figure 6 It is a schematic flow diagram of step 5 of the method of the present invention. DETAILED DESCRIPTION

[0016] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.

[0017] Embodiment 1, this embodiment discloses a data authority management method based on a road detection data management system, which can achieve more refined management and collaboration, avoid conflicts, better collaborative work, and improve overall efficiency in response to the road detection data management system's demand for refined management of massive data authority. Figure 1 As shown, the following steps are included: Step 1: Grant permissions to the role function page and function buttons: According to the function page information and page function button information managed in real time in the system, when a role is created, all function pages managed in the system and the function buttons in the function pages are displayed in a multi-select tree list below it. By selecting multiple function pages and function buttons in the pages with the left mouse button, the role function page permissions and the role function page function button permissions can be granted. like Figure 2 As shown, step 1 includes function page and function button data entry, system function page and function button query, and role authority assignment.

[0018] The steps for entering function page and function button data are as follows: first click on the function page and button management function page, click the Add button, select the data type as function page or function button, enter the name, logo and other data. The function page must set the request address and resource path to facilitate dynamic page generation. The function button must select the parent node to determine the parent-child relationship, that is, to determine the function page where the function button is located; click OK, and the function page and function button data are added to the function page and button data table.

[0019] The steps of querying the system function page and function button are as follows: the system performs data query in the function page and function button data table, queries all visible function pages and function buttons and their parent-child relationships, and generates a multi-select function page and button tree on the interface; The steps for assigning role permissions are as follows: On the role management page, click the Add button, enter the role name, and in the multi-select tree list below, use the left mouse button to select multiple function pages and function buttons on the pages, which are the function pages and function button permissions to be assigned to the role. After clicking OK, the system establishes an association between the role and the function, and records the role permission data in the role function permission data table.

[0020] Step 2: Grant role data permissions: By default, the road detection data management system grants super administrators all function button permissions on all function pages, and data visibility permissions for all types of data. Based on the data information imported into the system in advance, when you enter the road detection data management system with super administrator permissions to set role data permissions, access the radar data management function page, and the system displays all radar raw data in the form of an explorer file list according to the query conditions. Select the data for which permissions to be set, click the "Data Permissions" button, and the page will jump. Under the selected data, file, or folder, all roles in the system and the default permissions of the roles for this data are displayed in list form. Click the operation button, select whether the data is visible or invisible in the pop-up drop-down box, and click OK to implement the role data permission granting function; like Figure 3 As shown, step 2 includes road detection data import, road detection data query and role data permission assignment.

[0021] The steps for importing road detection data are as follows: the import of road detection data is divided into structured and unstructured data. When importing structured data, click the road damage data management function page with the mouse, click the import button, select the road damage data file to be imported from the hard disk, and the software will batch read the structured data from the file and insert the data one by one into the corresponding data information table; the unstructured data imported by the road detection data management system is usually radar project folder data with parameter descriptions. When importing unstructured data, click the radar data management function page, and the software will read the structured parameters from the parameter description file, such as project name, acquisition time, number of radar channels, etc., and insert them into the corresponding data information table, and copy the folder data as a whole to the system default directory, and at the same time add the folder directory location and the hierarchical relationship between the folder and the sub-files to the database file information hierarchical relationship table; The steps for querying road detection data are as follows: click on the radar data management function page with the mouse, set query conditions such as project name and creation time, and directly display the data in the form of a list after querying the radar data that meets the conditions from the database table. Among them, unstructured data should also be supplemented with matching folders and file icons according to the nature of the queried data. Click on a folder in the list data, and the software will display the next level of data according to the folder hierarchy relationship; The steps for assigning role data permissions are as follows: In the radar data management function page, select a radar engineering data that has been queried, click the "Data Permissions" button, the page will jump, and under the selected data, file or folder, the system will query all role information in the role information table, and display all roles in the system and the role's default permissions for the data in a list. Click the operation button, select visible or invisible data in the pop-up drop-down box, and click OK. The system will establish an association between the role and the data, and record the role data permissions in the role data permission data table.

[0022] Step 3: Assign user roles: According to the role information entered in advance in the system, when a user is created, in addition to entering basic information such as user name and password, all role information in the system is displayed in a multi-select list below the user. Select one or more roles with the mouse and click OK to implement the user role assignment function; like Figure 4 As shown, step 3 includes role data query and user role assignment; The steps of role data query are as follows: the software queries all role information in the role information table of the database and displays it in the form of a multiple-selection list; The steps for assigning user roles are as follows: when a user is created, click the user management function page, click the Add button, in addition to entering basic information such as user name and password, select one or more roles in the role information multi-select list below the user, click OK, the system will establish an association between the user and the role, and record the user role data in the user role data table.

[0023] Step 4: Dynamically generate the user login function page and button: The system matches the information in the user information table based on the entered username and password information. If the match fails, the system refuses to log in. If the match succeeds, the system searches for permissions based on the user, queries the function permissions based on the permissions, and uses dynamic routing technology to dynamically generate the function pages visible within the user permissions and the function buttons within the function pages; like Figure 5 As shown, step 4 includes user login verification and dynamic generation of user function pages and function buttons.

[0024] The steps of user login verification are as follows: the system checks whether the user exists in the database user information table according to the user name and password information entered on the login page. If the user does not exist, the login is directly rejected. If the user exists, the user name and password are encrypted according to the hash encryption algorithm and matched with the password information stored in the user information table. If the match fails, the system rejects the login. If the match succeeds, the subsequent steps are carried out. The steps for dynamically generating user function pages and function buttons are as follows: after the user logs in successfully, the system queries the user's assigned role ID array in the user role data table based on the user ID, and then queries the role's assigned function pages and function buttons in the role function permission data table based on the role ID. Multiple role functions are taken as the union, and the system uses dynamic routing technology to dynamically generate function pages visible within the user's permissions and function buttons within the function pages based on the queried function page and function button data and their parent-child relationships.

[0025] Step 5, view user permission data: According to the data permissions set for roles in the system, when a user logs in and clicks on the radar data management function page within the permissions, the system returns the data that the user's role is granted visible permissions to based on the query conditions. Data with invisible permissions will not be displayed on the page.

[0026] like Figure 6 As shown, step 5 includes common data query and permission data query.

[0027] The steps of general data query are as follows: after logging in, the user clicks on the radar data management page within the permission to browse radar data. The system organizes query statements to query data according to the query conditions such as project name and creation time set on the interface, and finds the data set that meets the conditions; The steps for querying permission data are as follows: the system queries the user's assigned role ID array in the user role data table based on the user ID, and then queries the role's assigned visible permission data information in the role data permission data table based on the role ID, and takes the union of multiple role data; the two query results take the intersection, return the query results and display the radar data information within the queried permission in list form.

Claims

1. A data authority management method based on a road detection data management system, characterized in that: The steps include: Step 1: Grant permissions to the role function page and function buttons: When a role is created, all function pages managed in the system and the function buttons in the function pages are displayed in a multi-select tree list below it. Select multiple function pages and function buttons in the pages to grant permissions to the role function pages and function buttons in the role function pages. Step 2: Grant role data permissions: Visit the radar data management function page, select the data for which you want to set permissions, click the "Data Permissions" button, and under the selected data, file, or folder, all roles in the system and the default permissions of the roles for the data will be displayed in a list. Click the Operation button, select whether the data is visible or invisible in the pop-up drop-down box, and click OK; Step 3: Assign user roles: When creating a user, in addition to entering the user name and password, all the role information in the system is displayed in a multi-select list below the user. Click one or more roles and click OK. Step 4: Dynamically generate the user login function page and button: The system matches the information in the user information table based on the entered user name and password information. If the match fails, the system refuses to log in. If the match succeeds, the system searches for permissions based on the user, queries the function permissions based on the permissions, and dynamically generates the function pages visible within the user permissions and the function buttons within the function pages; Step 5, view user permission data: According to the data permissions set for roles in the system, when a user logs in and clicks on the data management page within the permissions, the system returns the data that is granted visible permissions to the role to which the user belongs based on the query conditions. Data with invisible permissions is not displayed on the page.

2. The data authority management method based on the road detection data management system according to claim 1 is characterized by: Step 1 includes function page and function button data entry, system function page and function button query, and role authority assignment.

3. The data authority management method based on the road detection data management system according to claim 2 is characterized by: The steps for entering function page and function button data are as follows: first click the function page and button management function page, click the Add button, select the data type as function page or function button, and enter the data. The function page needs to set the request address and resource path, and the function button needs to select the parent node to determine the parent-child relationship, that is, determine the function page where the function button is located; The steps of querying the system function page and function button are as follows: the system performs data query in the function page and function button data table, queries all visible function pages and function buttons and their parent-child relationships, and generates a multi-select function page and button tree on the interface; The steps for assigning role permissions are as follows: On the role management page, click the Add button, enter the role name, and then in the multi-select tree list below, select multiple function pages and function buttons on the pages. After clicking OK, the system will establish an association between the role and the function, and record the role permission data in the role function permission data table.

4. The data authority management method based on the road detection data management system according to claim 1 is characterized by: Step 2 includes road detection data import, road detection data query and role data permission assignment.

5. The data authority management method based on the road detection data management system according to claim 4 is characterized in that: The steps for importing road detection data are as follows: importing road detection data is divided into structured and unstructured data. When importing structured data, click the road damage data management function page, click the import button, select the road damage data file to be imported from the hard disk, and then read the structured data in batches, and insert the data into the corresponding data information table one by one; when importing unstructured data, read the structured parameters from the parameter description file, insert them into the corresponding data information table, and copy the folder data as a whole to the system default directory, and at the same time add the folder directory location and the hierarchical relationship between the sub-files and the sub-files to the database file information hierarchical relationship table; The steps for querying road detection data are as follows: click on the radar data management function page, set the query conditions, and directly display the data in the form of a list after querying the radar data that meets the conditions from the database table. Among them, the unstructured data should also be supplemented with matching folders and file icons according to the nature of the queried data. Click on a folder in the list data to display the next level of data according to the folder hierarchy relationship; The steps for assigning role data permissions are as follows: select a certain data that has been queried, click the "Data Permissions" button, and the page will jump. Under the selected data, file, or folder, the system will query all role information in the role information table and display all roles in the system and the role's default permissions for the data in a list. Click the operation button, select whether the data is visible or invisible in the pop-up drop-down box, and click OK. The system will then establish an association between the role and the data, and record the role data permissions in the role data permissions table.

6. The data authority management method based on the road detection data management system according to claim 1 is characterized by: Step 3 includes role data query and user role assignment; The steps of role data query are: query all role information in the role information table of the database and display it in the form of a multiple-selection list; The steps for assigning user roles are as follows: when a user is created, in addition to entering the user name and password, select one or more roles in the role information multi-select list below the user, click OK, and the system will establish an association between the user and the role, and record the user role data in the user role data table.

7. The data authority management method based on the road detection data management system according to claim 1 is characterized by: Step 4 includes user login verification and dynamic generation of user function pages and function buttons.

8. The data authority management method based on the road detection data management system according to claim 7 is characterized by: The steps of user login verification are as follows: the system checks whether the user exists in the database user information table according to the user name and password information entered on the login page. If the user does not exist, the login is directly rejected. If the user exists, the user name and password are encrypted according to the hash encryption algorithm and matched with the password information stored in the user information table. If the match fails, the system rejects the login. If the match succeeds, the subsequent steps are carried out. The steps for dynamically generating user function pages and function buttons are as follows: after the user logs in successfully, the system queries the user's assigned role ID array in the user role data table based on the user ID, and then queries the role's assigned function pages and function buttons in the role function permission data table based on the role ID. Multiple role functions are taken as the union, and the system uses dynamic routing technology to dynamically generate function pages visible within the user's permissions and function buttons within the function pages based on the queried function page and function button data and their parent-child relationships.

9. The data authority management method based on the road detection data management system according to claim 1 is characterized by: Step 5 includes general data query and permission data query.

10. The data authority management method based on the road detection data management system according to claim 9, characterized in that: The steps of general data query are as follows: after logging in, the user clicks on the radar data management page within the authority to browse radar data. The system organizes query statements to query data according to the query conditions set on the interface; The steps of querying permission data are as follows: the system searches the user role data table for the role ID array assigned to the user according to the user ID, and then searches the role data permission data table for the data information with visible permissions assigned to the role according to the role ID, and takes the union of multiple role data; The intersection of the two query results is taken, and the query results are returned and the radar data information within the queried authority is displayed in a list form.

Images