feat: public lottery view, totals data

emilyjablonski commented 3 weeks ago

Related to merge of: https://github.com/bloom-housing/bloom/pull/4275

This PR addresses #4224

[x] Addresses the issue in full
[ ] Addresses only certain aspects of the issue

Description

Adds in the total number of applicants and number of applicants per preference into the public site lottery results page.

I created a new table that stores the totals in a very similar way to how we store lottery positions. I had performance concerns over querying the lottery positions table every time a user needs to see their results page as it will have 1000s of rows after just one lottery is run.

There's also some misc. test coverage.

How Can This Be Tested/Reviewed?

Submit an application to a listing and claim a preference. Run and release the lottery. Ensure that the total number of applications and number of applications that claimed that preference are correct.

Handling listings without preferences or a user who doesn't claim any is a separate ticket.

Author Checklist:

[x] Added QA notes to the issue with applicable URLs
[x] Reviewed in a desktop view
[x] Reviewed in a mobile view
[x] Reviewed considering accessibility
[x] Added tests covering the changes
[ ] Made corresponding changes to the documentation
[ ] Ran yarn generate:client and/or created a migration when required

Review Process:

Read and understand the issue
Ensure the author has added QA notes
Review the code itself from a style point of view
Pull the changes down locally and test that the acceptance criteria is met
Either (1) explicitly ask a clarifying question, (2) request changes, or (3) approve the PR, even if there are very small remaining changes, if you don't need to re-review after the updates

netlify[bot] commented 2 weeks ago

Deploy Preview for partners-bloom-dev ready!

Name	Link
Latest commit	76e29cc2c20134a649ab735ae446a7777d822378
Latest deploy log	https://app.netlify.com/sites/partners-bloom-dev/deploys/66e2ff6592c5ce00086995de
Deploy Preview	https://deploy-preview-4279--partners-bloom-dev.netlify.app
Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify site configuration.

netlify[bot] commented 2 weeks ago

Deploy Preview for bloom-exygy-dev ready!

Name	Link
Latest commit	76e29cc2c20134a649ab735ae446a7777d822378
Latest deploy log	https://app.netlify.com/sites/bloom-exygy-dev/deploys/66e2ff6593ba010008b0137b
Deploy Preview	https://deploy-preview-4279--bloom-exygy-dev.netlify.app
Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify site configuration.

bloom-housing / bloom