This is the "parent" ticket for collecting the necessary changes for the Fundraising Operation Center to no longer rely on the "legacy data blob" in donations and memberships for payment information.

• Change queries for listing donations (list view and detail view)
• Change queries for listing memberships (list view and detail view)
• Add payment data to raw fixture data. This needs the following steps:
  1. Collect donation and membership IDs from existing SQL files in test/Fixtures/Analysis
  2. Export the payment entries from production, using the IDs gathered in step 1, into a SQL file. You don't need the payment-specifc tables, only the payment table. Save the SQL in test/Fixtures/Analysis/payments.sql
  3. Identify all places where code uses the donation and membership fixtures. Add code to load the payment SQL before loading donation/membership
• Change queries for reports:
  • CampaignMonotorPerHour
  • CampaignMonotorPerDay
  • DonationsPerCampaign
  • MembershipReport
• Change queries for analytics (query amount and payment type from payment table).
• Change queries for exporting donations to use the payment tables:
• When all the items above are done, move the getLegacyData methods from CreditCardBookingTransformer and PayPalBookingTransformer into the FOC code base and name them getExportData.