Create a request access form for a candidate (part 2 of candidate's CenterID refactoring)

[cmadjar]

This will be part 2 of the future for the CenterID field of the candidate table plan (as discussed in September 2018 with @samirdas @driusan and @ridz1208, see meetings notes).

TODOs:

Create a form that will be used to request access to a candidate from another site when the candidate is switching sites so that the data entry people can have access to that candidate.

• Creation of a new table with CandID, CenterID, Project, UserID, Approval (Y,N) and the type of access (view other sites visits for example)
• For the type of access, the field behaviour would be:

1. view candidate metadata + create time point if data entry permission (default behaviour)
2. view the list of all the visits for that candidate (not clickable when not at the Users's site)
   Note, we might need a separate table in SQL candidate_access_type

• Would only see all the visits listed (link disabled for other site so cannot see and change the data already entered)
• [ ]Eventually, we will create a similar table for SessionID, CenterID, Project, UserID, Approval (Y,N) and type of access

Notes:

• modules/create_timepoint/php/create_timepoint.class.inc function _hasAccess will need to be modified as it uses the candidate's RegistrationCenterID in order to be able to create a new visit for a candidate. Will have to take the other tables into account in that query

Future labels for the PR:

• SQL
• [branch] major
• Add to release notes, Document at release and Notes for existing projects*

Comments from the first PR that should be done in this part 2:

• https://github.com/aces/Loris/pull/4078/files#r247707705
• https://github.com/aces/Loris/pull/4078/files#r247708121

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[cmadjar]

@driusan @ridz1208 could we assign this to someone else?

[driusan]

You'll get to it eventually, I believe in you!