Join tracking table list and detail view of donations
Open, Needs TriagePublic
Actions

Assigned To

None

Authored By

	gabriel-wmde
	Jun 8 2023, 9:14 PM

Description

Both list and detail view use the class DatabaseDonationQueries to query the database via the ORM.

The smallest change here would be as follows:

change the deprecated DoctrineORMDonationRepository queries to join the Tracking entity (with an eager fetch to avoid the 1+N query problem)
add a tracking key in DatabaseDonationQueries::createRowFromDoctrineDonation that uses the Tracking entity
Remove tracking from DatabaseDonationQueries::getLegacyData

A better approach would be to replace the DoctrineORMDonationRepository dependency and use Doctrine DBAL directly.

Status	Assigned	Task
Open	None	T203654 Improve Code and Architecture of Fundraising Frontend
Open	None	T203684 Improve code and architecture of Fundraising Operation Center
Open	None	T203679 Refactor fundraising database schema
Open	None	T328075 Move tracking out of donation data blob
Resolved	None	T328076 Investigate improvements of donation queries in Fundraising Operation Center
Open	None	T338519 Join tracking table list and detail view of donations