Finish/Verify Data Model for Social Layer Emails

[Mephistic]

Problem

We want to ensure that we have all the necessary data for the Social Layer's email notifications available at send time to populate the new email template. It's been quite some time since anyone has touched this code, so to that end, we need to audit the existing code to make sure we have ready access to everything we need.

Success Criteria

• Confirm that all of the dynamic elements of the current email template (https://www.figma.com/design/mpVTvbRTjwxWjrZS9B8HNA/Bills-Details-%26-Mission-Center-V2?node-id=924-3762&t=p26h4zzMmFlZbqpn-0) are available in the sending code at send time. This includes:
  • Bills with counts of new testimonies + basic bill details (Bill ID, Short Bill Summary, Number of Endorse/Oppose/Neutral since last notification) - (Only need top 4 bills by number of new testimonies descending, random is acceptable if that ordering is not easy)
  • Users/Orgs with new submitted testimony (Top X orgs with Top Y testimonies) - (Only need most recent 6 testimonies from orgs, random is acceptable if that ordering is not easy)
• If anything is not available (or just difficult to access), make a list of these elements and post it in #maple-developers so that we can triage the issues and decide whether we can adjust the design to work around it or we need to open a new issue to handle acquiring that data.

Related Links

Email Template: https://www.figma.com/design/mpVTvbRTjwxWjrZS9B8HNA/Bills-Details-%26-Mission-Center-V2?node-id=924-3762&t=p26h4zzMmFlZbqpn-0
Root Issue: https://app.zenhub.com/workspaces/maple-main-629389aa02e9d200139c90b8/issues/gh/codeforboston/maple/1559