.
/**
* Display Project Roadmap
*
* @package MantisBT
* @copyright Copyright 2000 - 2002 Kenzaburo Ito - kenito@300baud.org
* @copyright Copyright 2002 MantisBT Team - mantisbt-dev@lists.sourceforge.net
* @link http://www.mantisbt.org
*
* @uses core.php
* @uses access_api.php
* @uses authentication_api.php
* @uses bug_api.php
* @uses category_api.php
* @uses config_api.php
* @uses constant_inc.php
* @uses database_api.php
* @uses error_api.php
* @uses filter_api.php
* @uses filter_constants_inc.php
* @uses gpc_api.php
* @uses helper_api.php
* @uses html_api.php
* @uses lang_api.php
* @uses print_api.php
* @uses project_api.php
* @uses string_api.php
* @uses user_api.php
* @uses utility_api.php
* @uses version_api.php
*/
require_once( 'core.php' );
require_api( 'access_api.php' );
require_api( 'authentication_api.php' );
require_api( 'bug_api.php' );
require_api( 'category_api.php' );
require_api( 'config_api.php' );
require_api( 'constant_inc.php' );
require_api( 'database_api.php' );
require_api( 'error_api.php' );
require_api( 'filter_api.php' );
require_api( 'filter_constants_inc.php' );
require_api( 'gpc_api.php' );
require_api( 'helper_api.php' );
require_api( 'html_api.php' );
require_api( 'lang_api.php' );
require_api( 'print_api.php' );
require_api( 'project_api.php' );
require_api( 'string_api.php' );
require_api( 'user_api.php' );
require_api( 'utility_api.php' );
require_api( 'version_api.php' );
/**
* Print header for the specified project version.
* @param array $p_version_row Array containing project version data.
* @return void
*/
function print_version_header( array $p_version_row ) {
$t_project_id = $p_version_row['project_id'];
$t_version_id = $p_version_row['id'];
$t_version_name = $p_version_row['version'];
$t_project_name = project_get_field( $t_project_id, 'name' );
$t_release_title = '' . string_display_line( $t_project_name ) . ' - ' . string_display_line( $t_version_name ) . '';
$t_version_timestamp = $p_version_row['date_order'];
if( config_get( 'show_roadmap_dates' ) && !date_is_null( $t_version_timestamp ) ) {
$t_scheduled_release_date = ' (' . lang_get( 'scheduled_release' ) . ' ' . string_display_line( date( config_get( 'short_date_format' ), $t_version_timestamp ) ) . ')';
} else {
$t_scheduled_release_date = '';
}
echo '';
echo '
', $t_release_title, $t_scheduled_release_date, lang_get( 'word_separator' );
print_bracket_link( 'view_all_set.php?type=1&temporary=y&' . FILTER_PROPERTY_PROJECT_ID . '=' . $t_project_id . '&' . filter_encode_field_and_value( FILTER_PROPERTY_TARGET_VERSION, $t_version_name ), lang_get( 'view_bugs_link' ) );
echo '
';
$t_release_title_without_hyperlinks = $t_project_name . ' - ' . $t_version_name . $t_scheduled_release_date;
echo utf8_str_pad( '', utf8_strlen( $t_release_title_without_hyperlinks ), '=' ), '
';
}
/**
* print project header
* @param string $p_project_name Project name.
* @return void
*/
function print_project_header_roadmap( $p_project_name ) {
echo '
', string_display( $p_project_name ), ' - ', lang_get( 'roadmap' ), '
';
}
$t_issues_found = false;
$t_user_id = auth_get_current_user_id();
$f_project = gpc_get_string( 'project', '' );
if( is_blank( $f_project ) ) {
$f_project_id = gpc_get_int( 'project_id', -1 );
} else {
$f_project_id = project_get_id_by_name( $f_project );
if( $f_project_id === 0 ) {
error_parameters( $f_project );
trigger_error( ERROR_PROJECT_NOT_FOUND, ERROR );
}
}
$f_version = gpc_get_string( 'version', '' );
if( is_blank( $f_version ) ) {
$f_version_id = gpc_get_int( 'version_id', -1 );
# If both version_id and project_id parameters are supplied, then version_id take precedence.
if( $f_version_id == -1 ) {
if( $f_project_id == -1 ) {
$t_project_id = helper_get_current_project();
} else {
$t_project_id = $f_project_id;
}
} else {
$t_project_id = version_get_field( $f_version_id, 'project_id' );
}
} else {
if( $f_project_id == -1 ) {
$t_project_id = helper_get_current_project();
} else {
$t_project_id = $f_project_id;
}
$f_version_id = version_get_id( $f_version, $t_project_id );
if( $f_version_id === false ) {
error_parameters( $f_version );
trigger_error( ERROR_VERSION_NOT_FOUND, ERROR );
}
}
if( ALL_PROJECTS == $t_project_id ) {
$t_project_ids_to_check = user_get_all_accessible_projects( $t_user_id, ALL_PROJECTS );
$t_project_ids = array();
foreach ( $t_project_ids_to_check as $t_project_id ) {
$t_roadmap_view_access_level = config_get( 'roadmap_view_threshold', null, null, $t_project_id );
if( access_has_project_level( $t_roadmap_view_access_level, $t_project_id ) ) {
$t_project_ids[] = $t_project_id;
}
}
} else {
access_ensure_project_level( config_get( 'roadmap_view_threshold' ), $t_project_id );
$t_project_ids = user_get_all_accessible_subprojects( $t_user_id, $t_project_id );
array_unshift( $t_project_ids, $t_project_id );
}
$t_project_id_for_access_check = $t_project_id;
html_page_top( lang_get( 'roadmap' ) );
version_cache_array_rows( $t_project_ids );
category_cache_array_rows_by_project( $t_project_ids );
foreach( $t_project_ids as $t_project_id ) {
$t_project_name = project_get_field( $t_project_id, 'name' );
$t_can_view_private = access_has_project_level( config_get( 'private_bug_threshold' ), $t_project_id );
$t_limit_reporters = config_get( 'limit_reporters' );
$t_user_access_level_is_reporter = ( config_get( 'report_bug_threshold', null, null, $t_project_id ) == access_get_project_level( $t_project_id ) );
$t_resolved = config_get( 'bug_resolved_status_threshold' );
$t_version_rows = array_reverse( version_get_all_rows( $t_project_id ) );
# cache category info, but ignore the results for now
category_get_all_rows( $t_project_id );
$t_project_header_printed = false;
foreach( $t_version_rows as $t_version_row ) {
if( $t_version_row['released'] == 1 ) {
continue;
}
# Skip all versions except the specified one (if any).
if( $f_version_id != -1 && $f_version_id != $t_version_row['id'] ) {
continue;
}
$t_issues_planned = 0;
$t_issues_resolved = 0;
$t_issues_counted = array();
$t_version_header_printed = false;
$t_version = $t_version_row['version'];
$t_query = 'SELECT sbt.*, {bug_relationship}.source_bug_id, dbt.target_version as parent_version FROM {bug} sbt
LEFT JOIN {bug_relationship} ON sbt.id={bug_relationship}.destination_bug_id AND {bug_relationship}.relationship_type=2
LEFT JOIN {bug} dbt ON dbt.id={bug_relationship}.source_bug_id
WHERE sbt.project_id=' . db_param() . ' AND sbt.target_version=' . db_param() . ' ORDER BY sbt.status ASC, sbt.last_updated DESC';
$t_description = $t_version_row['description'];
$t_first_entry = true;
$t_result = db_query( $t_query, array( $t_project_id, $t_version ) );
$t_issue_ids = array();
$t_issue_parents = array();
$t_issue_handlers = array();
while( $t_row = db_fetch_array( $t_result ) ) {
# hide private bugs if user doesn't have access to view them.
if( !$t_can_view_private && ( $t_row['view_state'] == VS_PRIVATE ) ) {
continue;
}
bug_cache_database_result( $t_row );
# check limit_Reporter (Issue #4770)
# reporters can view just issues they reported
if( ON === $t_limit_reporters && $t_user_access_level_is_reporter &&
!bug_is_user_reporter( $t_row['id'], $t_user_id )) {
continue;
}
$t_issue_id = $t_row['id'];
$t_issue_parent = $t_row['source_bug_id'];
$t_parent_version = $t_row['parent_version'];
if( !helper_call_custom_function( 'roadmap_include_issue', array( $t_issue_id ) ) ) {
continue;
}
if( !isset( $t_issues_counted[$t_issue_id] ) ) {
$t_issues_planned++;
if( bug_is_resolved( $t_issue_id ) ) {
$t_issues_resolved++;
}
$t_issues_counted[$t_issue_id] = true;
}
if( 0 === strcasecmp( $t_parent_version, $t_version ) ) {
$t_issue_ids[] = $t_issue_id;
$t_issue_parents[] = $t_issue_parent;
} else if( !in_array( $t_issue_id, $t_issue_ids ) ) {
$t_issue_ids[] = $t_issue_id;
$t_issue_parents[] = null;
}
$t_issue_handlers[] = $t_row['handler_id'];
}
user_cache_array_rows( array_unique( $t_issue_handlers ) );
$t_progress = $t_issues_planned > 0 ? ( (integer)( $t_issues_resolved * 100 / $t_issues_planned ) ) : 0;
if( $t_issues_planned > 0 ) {
$t_progress = (integer)( $t_issues_resolved * 100 / $t_issues_planned );
if( !$t_project_header_printed ) {
print_project_header_roadmap( $t_project_name );
$t_project_header_printed = true;
}
if( !$t_version_header_printed ) {
print_version_header( $t_version_row );
$t_version_header_printed = true;
}
if( !is_blank( $t_description ) ) {
echo string_display( '
' .$t_description . '
' );
}
# show progress bar
echo '';
echo ' ' . $t_progress . '%';
echo '
';
}
$t_issue_set_ids = array();
$t_issue_set_levels = array();
$k = 0;
$t_cycle = false;
$t_cycle_ids = array();
while( 0 < count( $t_issue_ids ) ) {
$t_issue_id = $t_issue_ids[$k];
$t_issue_parent = $t_issue_parents[$k];
if( in_array( $t_issue_id, $t_cycle_ids ) && in_array( $t_issue_parent, $t_cycle_ids ) ) {
$t_cycle = true;
} else {
$t_cycle = false;
$t_cycle_ids[] = $t_issue_id;
}
if( $t_cycle || !in_array( $t_issue_parent, $t_issue_ids ) ) {
$l = array_search( $t_issue_parent, $t_issue_set_ids );
if( $l !== false ) {
for( $m = $l+1; $m < count( $t_issue_set_ids ) && $t_issue_set_levels[$m] > $t_issue_set_levels[$l]; $m++ ) {
#do nothing
}
$t_issue_set_ids_end = array_splice( $t_issue_set_ids, $m );
$t_issue_set_levels_end = array_splice( $t_issue_set_levels, $m );
$t_issue_set_ids[] = $t_issue_id;
$t_issue_set_levels[] = $t_issue_set_levels[$l] + 1;
$t_issue_set_ids = array_merge( $t_issue_set_ids, $t_issue_set_ids_end );
$t_issue_set_levels = array_merge( $t_issue_set_levels, $t_issue_set_levels_end );
} else {
$t_issue_set_ids[] = $t_issue_id;
$t_issue_set_levels[] = 0;
}
array_splice( $t_issue_ids, $k, 1 );
array_splice( $t_issue_parents, $k, 1 );
$t_cycle_ids = array();
} else {
$k++;
}
if( count( $t_issue_ids ) <= $k ) {
$k = 0;
}
}
$t_count_ids = count( $t_issue_set_ids );
for( $j = 0; $j < $t_count_ids; $j++ ) {
$t_issue_set_id = $t_issue_set_ids[$j];
$t_issue_set_level = $t_issue_set_levels[$j];
helper_call_custom_function( 'roadmap_print_issue', array( $t_issue_set_id, $t_issue_set_level ) );
$t_issues_found = true;
}
if( $t_issues_planned > 0 ) {
echo '
';
echo sprintf( lang_get( 'resolved_progress' ), $t_issues_resolved, $t_issues_planned, $t_progress );
echo '
';
}
}
}
if( !$t_issues_found ) {
if( access_has_project_level( config_get( 'manage_project_threshold' ), $t_project_id_for_access_check ) ) {
$t_string = 'roadmap_empty_manager';
} else {
$t_string = 'roadmap_empty';
}
echo '' . lang_get( $t_string ) . '
';
}
html_page_bottom();