0034041: MantisGraph: last resolved issue not computed in Issue Trends graph

ID	Project	Category	View Status	Date Submitted	Last Update

0034041	mantisbt	reports	public	2024-03-13 14:05	2024-09-29 13:15

Reporter	dregad	Assigned To	dregad
Priority	normal	Severity	minor	Reproducibility	always
Status	closed	Resolution	fixed
Target Version	2.27.0	Fixed in Version	2.27.0

Summary	0034041: MantisGraph: last resolved issue not computed in Issue Trends graph
Description	In MantisGraph plugin's Issue Trends graph, the count of resolved issues is incorrect, see attached screenshots.
Tags	No tags attached.
Attached Files	filter_shows_7_resolved_issues.png (27,555 bytes) filter_shows_7_resolved_issues.png (27,555 bytes) issue_trend_graph_reports_only_6_resolved_issues.png (37,974 bytes) issue_trend_graph_reports_only_6_resolved_issues.png (37,974 bytes)

dregad 2024-03-13 14:21 developer ~0068651	PR https://github.com/mantisbt/mantisbt/pull/1975 See attached the graph including the fix for the same data set as for the initial report. fixed_resolved_issue_count.png (38,009 bytes) fixed_resolved_issue_count.png (38,009 bytes)

dregad 2024-03-13 14:26 developer ~0068654	Changing target to 2.27.0 as the fix relies on PHP 7.4 syntax for heredocs, and I can't be bothered to make 2 versions of the fix...

MantisBT: master f109d15d 2024-03-13 14:13 dregad Details Diff	Optimize create_cumulative_bydate() function Until today, the function was executing simple SQL queries returning atomic data, and PHP code had to loop over each row to compute the total number of reported and resolved Issues. This reports the effort to aggregate the data on the database server, greatly simplifying the PHP code It also fixes a bug where the last resolved issue was sometimes not computed, resulting in an incorrect result set. Fixes 0034041,0034042		Affected Issues 0034041, 0034042
	mod - plugins/MantisGraph/core/graph_api.php		Diff File