This may or may not be needed, it depends on the questions in #1214 about whether we need to store data for multiple surveys at a single org in a single month separately, or whether we'll be combining them together, and when that'll happen.
I think the most likely thing is that we'll need to store survey's separately (so one for A&E, one for Maternity, etc) but then display them as one. Therefore, we'll need a (some) clever method(s) on the related manager which connects surveys to orgs, to enable us to say "get me all the surveys for this month and mash them together as if there were one survey per month" - so that we can easily get the following data:
overall score for each month in the last six months
current month's overall score
current month's score broken down by response
If we don't need to combine different surveys to get one in this way, and instead we show each survey individually (so have a tab for A&E, tab for Maternity, etc), we won't need this ticket at all, as it's just standard queries of the surveys against a particular org with the survey department filtered appropriately for each tab.
Related to #1213
This may or may not be needed, it depends on the questions in #1214 about whether we need to store data for multiple surveys at a single org in a single month separately, or whether we'll be combining them together, and when that'll happen.
I think the most likely thing is that we'll need to store survey's separately (so one for A&E, one for Maternity, etc) but then display them as one. Therefore, we'll need a (some) clever method(s) on the related manager which connects surveys to orgs, to enable us to say "get me all the surveys for this month and mash them together as if there were one survey per month" - so that we can easily get the following data:
If we don't need to combine different surveys to get one in this way, and instead we show each survey individually (so have a tab for A&E, tab for Maternity, etc), we won't need this ticket at all, as it's just standard queries of the surveys against a particular org with the survey department filtered appropriately for each tab.