Description

Currently, in the email report, "Ignored / Read / Failed emails" does not provide accurate information because it always reflects only the information of the email_stats1 record.

The query executed in StatRepository's getIgnoredReadFailed is as follows:

SELECT count(es.id) as sent, count(CASE WHEN es.is_read THEN 1 ELSE null END) as "read", count(CASE WHEN es.is_failed THEN 1 ELSE null END) as failed FROM email_stats es LEFT JOIN emails e ON e.id = es.email_id WHERE (es.date_sent IS NULL OR (es.date_sent BETWEEN :dateFrom AND :dateTo)) AND (e.is_published = :i0ceispublished) GROUP BY es.id;

The query itself is not a big problem. However, the problem is that because of the "GROUP BY es.id;" statement, there is only one piece of email_stats information per row, but getIgnoredReadFailed only uses that one row of data.
As a result, the pie chart always only provides information for one email.

This PR solves the problem by removing the group by statement from the query, allowing getIgnoredReadFailed to execute the desired query.

📋 Steps to test this PR:

1. Open this PR on Gitpod or pull down for testing locally (see docs on testing PRs here)
2. Open the reports screen and check the "Ignored / Read / Failed emails" pie chart.