un-fao / calipseo-shiny

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-46] Vessel Details module - implement vessel characteristics history #46

Closed eblondel closed 6 months ago

eblondel commented 6 months ago

Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-46 Creator/Reporter: Emmanuel Blondel @eblondel Assignee: Brian Ojok @brianandy Priority: Medium Status: Done Date of creation: 2021-12-20T11:54:18.000+0000

Background

The openfismis/calipseo plateform supports tracking/history of vessel characteristics changes in time. This is handled in the table _reg_vessel_historicalcharacteristics.

Changes are classified by type using the _cl_app_vessel_historical_characteristictypes, with these types of changes: |Registration Number| |Name| |Owner| |Length of vessel| |Other|

In addition, the table _reg_vessel_historicalcharacteristics stores changes with different columns depending on what has been changed:

Task

To implement a vertical tab 'History' in the vessel details module. The tab should be the first tab in the list (before 'Ownership').

The content of that tab should be a table (with DT and all export usual features) that list the historical changes done on this vessel with the following columns:

For old/new values, values should be fetched from different table columns as explained above.

Data to use for testing

The Suriname database already includes some historical data sample that can be used for implementation.