Provide a report to show the number of forms in each race in each stage of the count. Perhaps this could be presented as a table, with stages on the x and races on the y.
Functional requirements
[ ] Create a table report showing forms progress. The table will consist of the following columns:
Race Type
Total forms
Unsubmitted
Intake
Data Entry 1
Data Entry 2
Corrections
Quality Control
Archived
Clearance
Audit
[ ] On the form state columns display count of forms in that stage vs count of unprocessed forms in that stage. The unprocessed forms count should be a link to the forms list table that will show the remaining forms. NB: The unprocessed forms count does not apply to the review stages which include:
Clearance
Audit
Acceptance creteria
[ ] A table report showing race types and count of forms in each stage per race types.
[ ] A clickable count of unprocessed forms per form state except for the Clearance and Audit stages
[ ] A list of unprocessed forms per form stage.
Task check list
[ ] Create a django view that will run the following queries on the Result Form model.
[ ] Filter result forms by tally.
[ ] Group result forms by race type. Check group by example here.
[ ] Annotate number of forms per form state. This will also use a SubQuery similar to this.
[ ] Annotate number of unprocessed forms per state except for the Clearance and Audit stages. Formula for this query will be:
Exclude forms that are already in the stage and those that have already passed the current stage.
Count the remaining one's.
[ ] Update the render_column method to render the unprocessed count as a link. The link should have the form state and race type as a query params.
[ ] The following updates will be done on forms list filter_queryset method so that it can return unprocessed forms per stage.
[ ] Check if form_state and race_type kwargs has been passed.
[ ] Use the form_state and race_type values to filter forms that are already in that stage and those that have already passed the stage.
[ ] Update the form list template to have the following details on the header:
User story
Provide a report to show the number of forms in each race in each stage of the count. Perhaps this could be presented as a table, with stages on the x and races on the y.
Functional requirements
Acceptance creteria
Task check list
Related to:
https://github.com/onaio/tally-ho/issues/357