[STORY]: Invalidate upload - subrecipients

Full User Story

As a staff or admin user, I don't want new subrecipients from invalidated uploads to be included in treasury reports.

Why is this issue important?

When you invalidate an upload, it is not included in the treasury report. However, this currently does not apply to subrecipients who were added, meaning that new subrecipients from invalidated files will still appear in treasury reports incorrectly.

Action Plan

[ ] Initial design drafted
[ ] Initial acceptance criteria drafted
[ ] High level technical approach & feature flag use determined
[ ] Designs & Acceptance criteria finalized
[ ] Eng task breakout complete
[ ] Assessment of whether partner training & communication actions are needed
[ ] Acceptance criteria testing completed & passed in staging
[ ] Feature flags enabled in production
[ ] Feature flags are removed once the feature is deemed stable

Engineering Tasks

tbd

copied from out of date version of invalidate issue: When Invalidate button is clicked it must:

create a UploadValidation record in the database where the record.passed = false and record.results = [ { "message": "Manually invalidated by User: ", "tab": "N/A", "row": "N/A", "col": "N/A", "severity": "err" }

Acceptance Criteria

When you click "Invalidate" on a valid file:

if an upload is invalidated and has new subrecipients in it (i.e. they were first reported in that reporting period), those records will be removed.
if you upload two files in one reporting period, and the second one updates the subrecipient data, and then the second file is invalidated, the subrecipient data should reflect the data from only the latest valid file.

When you click "Re-validate,"

If an upload is re-validated in that reporting period or a future one, and it the subrecipients included in the file do not exist (i.e. have not been added via other upload files), the subrecipients will be considered "new" again.

Notes from 7/25 call

Sequence of events

## Typical Scenario

Upload 1
Subrecipient 1 - abc - active

Upload 2
Subrecipient 1 - def - active

Upload 2 invalidated
Subrecipient 1 - abc - active (this is fine if it was Name/UEI/TIN then we want to modify it on the subrecipient record)

Upload 1 invalidated
Subrecipient 1 - abc - archived

## Complicated Scenario

Upload 1
Subrecipient 1 - abc - active

Upload 2
Subrecipient 1 - def - active

Upload 3
Subrecipient 2 - abc - active (Should this subrecipient be validated against the latest version of subrecipient 1 or _all_ versions of subrecipient 1?)

Upload 2 invalidated
Subrecipient 1 - abc - active (this is fine if it was Name/UEI/TIN then we want to modify it on the subrecipient record)

Upload 1 invalidated
Subrecipient 1 - abc - archived

usdigitalresponse / cpf-reporter