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-80] Vessel list - Add a column for License status #80
Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-80
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: Medium
Status: Done
Date of creation: 2022-04-08T06:53:35.000+0000
We should add a license status column in the vessel list, to show either if it is missing (no license at all for the vessel), expired (vessel had licenses before, but it is expired), or valid at current date.
Let's try to decouple it from the SQL query that we do for listing the vessels, and try to handle this status separately (by vessel ID) and then do a join in R to get the extended vessel list.
We should also try do the list of vessel ID / license status directly in through SQL query; as this should then feed work of Java team to design proper API to do the same.
From the UI perspective, the column will be applied with icons / color scheme:
cross icon for both expired/missing license + text label; all in red
valid icon for valid licenses + text label; all in green
We should add a license status column in the vessel list, to show either if it is missing (no license at all for the vessel), expired (vessel had licenses before, but it is expired), or valid at current date.
Let's try to decouple it from the SQL query that we do for listing the vessels, and try to handle this status separately (by vessel ID) and then do a join in R to get the extended vessel list.
We should also try do the list of vessel ID / license status directly in through SQL query; as this should then feed work of Java team to design proper API to do the same.
From the UI perspective, the column will be applied with icons / color scheme: