User Management - Githubissues

CCAFS / ccafs-ap

CCAFS P&R is a platform to assist in the planning and reporting of CCAFS-related research projects. Migrated from https://code.google.com/p/ccafs-ap/

GNU General Public License v3.0

2 stars 1 forks source link

User Management #344

Closed htobon closed 9 years ago

htobon commented 9 years ago

Develop User Management:

[x] Relate projects table with user ids (not employees anymore).
[x] Create table liaison_institutions (id, institution_id, name, acronym and populate it).
[x] Create table liaison_users that will relate users and liaisons_institutions.
[x] Update model User so it can have more than one role at same time (Array of roles).
[x] Create table user_roles_projects that relates the specific roles for a user on a specific project
[x] Load table user_roles_projects into the JAVA Model (somehosw).

hernandcb commented 9 years ago

It was added the table liaison_institution_id which contains the list of institutions that can be management liaison of a project. At this moment most of the records are linked to CIAT, then we still need:

[ ] Search to which institution is linked each flagship and region program and adjust the value in the table accordingly (Perhaps the finance team can give us this info).

htobon commented 9 years ago

I asked Jose David and I got the following information: FP1 - CIAT FP2 - U. of Columbia FP3 - U. of Vermont FP4 - IFPRI LAM - CIAT

Perhaps Angela?

htobon commented 9 years ago

EA - ILRI WA - ICRISAT SEA - IRRI SA - IWMI

htobon commented 9 years ago

@Jorgesolis1989

htobon commented 9 years ago

@hernandcb did you make this changes already? if so, please update the issue.

hernandcb commented 9 years ago

No, I didn't made the changes yet.

@Jorgesolis1989 Could you please make these changes?

Jorgesolis1989 commented 9 years ago

Issue solved. https://github.com/CCAFS/ccafs-ap/commit/e16a8e6441634eb1603cdb03e566c19b174aa7ed

Observation: for solve this issue, selected the headquarters of the centers because someone have different institution ids.

IFPRI = Washington (id=89). IRRI = Los Banos, Filipinas (id=5). IWNI = Barrantamulla, Sri Lanka (id=172).

hernandcb commented 9 years ago

Great, thank you Jorge.

htobon commented 9 years ago

No, it is not finished. What about the regions? https://github.com/CCAFS/ccafs-ap/issues/344#issuecomment-109354946

Jorgesolis1989 commented 9 years ago

Fixed the missing update : WA-> ICRISAT. (UPDATE liaison_institutions SET institution_id='103' WHERE id='10'); db30fac4ee4a6a93a8085aa978388581ea26fa3a.

htobon commented 9 years ago

great. thks.