|
|
It seems we are double (triple?) counting some bugs due to a sub-optimal query.
I think I will simplify the query with something like:
Index: core/summary_api.php
RCS file: /cvsroot/mantisbt/mantisbt/core/summary_api.php,v
retrieving revision 1.52
diff -u -r1.52 summary_api.php
--- core/summary_api.php 1 Aug 2007 15:20:45 -0000 1.52
+++ core/summary_api.php 4 Aug 2007 14:33:53 -0000
@@ -202,7 +202,6 @@
current project
function summary_resolved_bug_count_by_date( $p_time_length = 1 ) {
$t_bug_table = config_get( 'mantis_bug_table' );
-
$t_bug_history_table = config_get( 'mantis_bug_history_table' );
$t_resolved = config_get( 'bug_resolved_status_threshold' );
$c_time_length = (int)$p_time_length;
@@ -216,13 +215,9 @@
}
$query = "SELECT COUNT(*)
- FROM $t_bug_table b
- LEFT JOIN $t_bug_history_table h
- ON b.id = h.bug_id
- AND h.type = " . NORMAL_TYPE ."
- AND h.field_name = 'status'
- WHERE b.status >= '$t_resolved'
- AND ".db_helper_compare_days(db_now(),"date_modified","<= '$c_time_length'")."
- FROM $t_bug_table
- WHERE " . db_helper_compare_days(db_now(),"last_updated","<= '$c_time_length'") . "
- AND status >= '$t_resolved'
AND $specific_where";
$result = db_query( $query );
return db_result( $result, 0 );
|
