Feat Synthese: add advanced status, red lists filters

[jpm-cbna]

See #1492.

[codecov[bot]]

Codecov Report

Base: 66.94% // Head: 67.07% // Increases project coverage by +0.13% :tada:

Coverage data is based on head (7533706) compared to base (df9153d). Patch coverage: 95.00% of modified lines in pull request are covered.

Additional details and impacted files

@@             Coverage Diff             @@
##           develop    #1535      +/-   ##
===========================================
+ Coverage    66.94%   67.07%   +0.13%     
===========================================
  Files           71       71              
  Lines         6038     6069      +31     
===========================================
+ Hits          4042     4071      +29     
- Misses        1996     1998       +2     

Flag	Coverage Δ
pytest	67.07% <95.00%> (+0.13%)	:arrow_up:

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
backend/geonature/core/gn_synthese/routes.py	78.66% <ø> (ø)
backend/geonature/core/gn_synthese/models.py	89.05% <87.50%> (-0.24%)	:arrow_down:
...nature/core/gn_synthese/utils/query_select_sqla.py	73.26% <95.65%> (+2.95%)	:arrow_up:
backend/geonature/utils/config_schema.py	91.83% <100.00%> (+0.24%)	:arrow_up:

Help us with your feedback. Take ten seconds to tell us how you rate us. Have a feature suggestion? Share it here.

:umbrella: View full report at Codecov.
:loudspeaker: Do you have feedback about the report comment? Let us know in this issue.

[amandine-sahl]

Test : voir pour ajouter la bdc_status a l'installation

bdc_statut_cor_text_values n'est pas peuplée : https://github.com/PnX-SI/TaxHub/commit/a95a45a290701de8429133c2b49878049a59859c#diff-f68fe3ea3eb17c5719d2e0218c06ffb83e3adfe734e93f455f7a05a65abc03f6

A voir pour les performances si il y a des optimisations possibles