feat: adding preference sheets to lottery export

[YazeedLoonat]

This PR addresses #4056

• [x] Addresses the issue in full

Description

This adds the preference sheets to the lottery export as well as a few other things:

• preference sheets
  • added
• demographics
  • now based on role just like application csv export
• columns
  • added preference rank
  • still need to double check column order
• permissions
  • UI is now hooked up to do a partner export

How Can This Be Tested/Reviewed?

• head to the partners site
• on a closed listing with applications and preferences on the listing (and to make it easier claimed preferences on at least some of the applications)
• generate the lottery results
• get the spreadsheet export

you should notice individual sheets for each preference as well as the original raw sheet

Author Checklist:

• [ ] Added QA notes to the issue with applicable URLs
• [x] Reviewed in a desktop view
• [ ] Reviewed in a mobile view
• [ ] Reviewed considering accessibility
• [ ] 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]]

✅ Deploy Preview for partners-bloom-dev ready!

Name	Link
🔨 Latest commit	62ec0127ad03067d5518f9444a55bf1bffa0cf2c
🔍 Latest deploy log	https://app.netlify.com/sites/partners-bloom-dev/deploys/66ba73fc2c5bdc00086732a4
😎 Deploy Preview	https://deploy-preview-4233--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]]

✅ Deploy Preview for bloom-exygy-dev ready!

Name	Link
🔨 Latest commit	62ec0127ad03067d5518f9444a55bf1bffa0cf2c
🔍 Latest deploy log	https://app.netlify.com/sites/bloom-exygy-dev/deploys/66ba73fce7c72d0008899c15
😎 Deploy Preview	https://deploy-preview-4233--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.

[ludtkemorgan]

@mcgarrye the bug with all showing the same rank has been fixed. There was a = instead of ===. I'll also add some tests around that

[emilyjablonski]

The sample export has a slightly different column order with the raw rank coming first

[ludtkemorgan]

@mcgarrye nice catch. I have fixed the columns to have the right data