Add Multiselect Supervisees Combobox to Edit User Form

[Dark-Developer93]

Description

We need to add a new multiselect combobox field called "Supervisees" to the Edit User form. This combobox should list all users in the app, allowing the selection of multiple supervisees for each user. The selected supervisees should be stored as an array of user IDs in the database.

Tasks

1. Update the database schema to add a new "supervisees" field to the User table, capable of storing an array of user IDs.
2. Modify the Edit User form in the frontend to include the new multiselect Supervisees combobox.
3. Populate the Supervisees combobox with all users from the app, displaying names but associating each with their user ID.
4. Implement search functionality within the combobox for easier user selection.
5. Update the backend API to handle the new supervisees field when editing a user, ensuring it saves the array of user IDs.
6. Implement proper validation and error handling for the new field.

Acceptance Criteria

• The User table in the database has a new "supervisees" field that stores an array of user IDs.
• The Edit User form displays a multiselect Supervisees combobox.
• The Supervisees combobox is populated with all users in the app, showing names but linked to user IDs.
• Users can search for and select multiple supervisees from the combobox and save the changes.
• The backend API correctly processes and stores the supervisee information as an array of user IDs.
• Appropriate error handling and validation are in place.

Additional Notes

• Ensure the UI clearly indicates that multiple supervisees can be selected.
• Implement efficient search functionality within the combobox for quick user selection.
• Ensure that circular dependencies are prevented (e.g., a user cannot be their own supervisee).
• Update any relevant documentation or user guides to reflect this new multiselect combobox feature.
• Consider performance implications when loading and searching through all users for large organizations.
• Coordinate with the Supervisors feature to ensure consistency in the relationship between users.
• When displaying supervisees elsewhere in the app, remember to resolve the user IDs to display names or other relevant information.