New function for Department Management

[quan-tv]

Description

SW360 allows user belong to multiple department. But although there is function for User Management, the function for Department Management is not available yet.

I think that it would be nice if we implement function for Department Management.

There are two points I would like to remark - I am not sure that the matter of Toshiba only, or other companies also are sharing the same thing:

• There are many departments, and it would be good if departments and their members can be created/assigned automatically based on information from input files (Excel/CSV) via a kind of scheduled job.
• All members will have the same fixed 'Primary Department', so in the context of this new function, we allow to assign Secondary Departments only. Default Role will be 'User'.

Screenshots

Here is my ideal for this function.

1. Add new item in Admin menu:
   

2. Click the new menu item to open screen 'Department List'
   

3. Screen design for Department Edit
   

4. How data is stored in DB:
   I noticed that in the design of current table 'User', database 'sw360users', the field 'secondaryDepartmentsAndRoles' is ready for this new function. Here is one sample:
   

[tienlee]

I would like to share the demo.
SW360-20220406 - Demo1439.pptx