[CALR-69] Individuals list - new core module inception

[eblondel]

Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-69
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: Medium
Status: Done
Date of creation: 2022-03-30T19:02:42.000+0000

A new module with prefix individual_list for R scripts should be de designed,

The module should be similar to the vessel_list module where we want to display the list of individuals in a table with same features as for vessel listing (sorting, filtering, pagination). R code business logic from vessel_list can be recycled as much as possible.

The table should be based on a SQL query that will bring the following columns on display:

• salutation (as i18n label), to fetch from reg_entity_individuals table / CL_APP_SALUTATION_ID reference field
• First / middle / suffix names, to fetch using reg_entity_individuals table / FIRST_NAME / MIDDLE_NAME / SUFFIX_NAME fields
• Last name, to fetch using reg_entities table / NAME
• Gender (as i18n label), to fetch using reg_entity_individuals table / CL_APP_GENDER_ID reference field

The module will have to be internationalized with json files for static vocabulary (eg. table headers), setting vocabulary in english as starter; and the SQL performed should be internationalized, so we can grab local labels (eg. for saluation, gender)

Expected new files for this task:

• individual_list_ui.R
• individual_list_server.R
• individual_list_i18n_en.json
• individual_list.json

This module will be extended with additional fields, in consultation with [~yann.laurent] . Other JIRAs will be set-up for that