Calipseo is FAO web- based platform for national Fisheries Authorities to streamline management of fisheries data and the production, analysis and reporting of fishery statistics.
1
stars
0
forks
source link
[CALR-69] Individuals list - new core module inception #69
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_entityindividuals table / CL_APP_SALUTATION_ID reference field
First / middle / suffix names, to fetch using _reg_entityindividuals table / FIRST_NAME / MIDDLE_NAME / SUFFIX_NAME fields
Last name, to fetch using _regentities table / NAME
Gender (as i18n label), to fetch using _reg_entityindividuals 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
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:
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:
This module will be extended with additional fields, in consultation with [~yann.laurent] . Other JIRAs will be set-up for that