PHP bug_cache_array_rows函数代码示例

/**
 * Get an array of the last visited bug ids.  We intentionally don't check
 * if the ids still exists to avoid performance degradation.
 *
 * @param user_id	The user id to get the last visited issues for,
 * 				or null for current logged in user.
 * @return An array of issue ids or an empty array if none found.
 * @access public
 */
function last_visited_get_array($p_user_id = null)
{
    $t_value = token_get_value(TOKEN_LAST_VISITED, $p_user_id);
    if (is_null($t_value)) {
        return array();
    }
    # we don't slice the array here to optimise for performance.  If the user reduces the number of recently
    # visited to track, then he/she will get the extra entries until visiting an issue.
    $t_ids = explode(',', $t_value);
    bug_cache_array_rows($t_ids);
    return $t_ids;
}

/**
 * Get list of affected issues between a given time period
 * @param integer $p_start_time Timestamp representing start time of the period.
 * @param integer $p_end_time   Timestamp representing end time of the period.
 * @return array
 */
function timeline_get_affected_issues($p_start_time, $p_end_time)
{
    $t_query = 'SELECT DISTINCT(bug_id) from {bug_history} WHERE date_modified >= ' . db_param() . ' AND date_modified < ' . db_param();
    $t_result = db_query($t_query, array($p_start_time, $p_end_time));
    $t_current_project = helper_get_current_project();
    $t_all_issue_ids = array();
    while (($t_row = db_fetch_array($t_result)) !== false) {
        $t_all_issue_ids[] = $t_row['bug_id'];
    }
    bug_cache_array_rows($t_all_issue_ids);
    $t_issue_ids = array();
    foreach ($t_all_issue_ids as $t_issue_id) {
        if ($t_current_project != ALL_PROJECTS && $t_current_project != bug_get_field($t_issue_id, 'project_id')) {
            continue;
        }
        if (!access_has_bug_level(config_get('view_bug_threshold'), $t_issue_id)) {
            continue;
        }
        $t_issue_ids[] = $t_issue_id;
    }
    return $t_issue_ids;
}

/**
 * get all relationships with the given bug as destination
 * @param integer $p_dest_bug_id Destination bug identifier.
 * @return array Array of BugRelationshipData objects
 */
function relationship_get_all_dest($p_dest_bug_id)
{
    $t_query = 'SELECT {bug_relationship}.id, {bug_relationship}.relationship_type,
				{bug_relationship}.source_bug_id, {bug_relationship}.destination_bug_id,
				{bug}.project_id
				FROM {bug_relationship}
				INNER JOIN {bug} ON {bug_relationship}.source_bug_id = {bug}.id
				WHERE destination_bug_id=' . db_param() . '
				ORDER BY relationship_type, {bug_relationship}.id';
    $t_result = db_query($t_query, array((int) $p_dest_bug_id));
    $t_dest_project_id = bug_get_field($p_dest_bug_id, 'project_id');
    $t_bug_relationship_data = array();
    $t_bug_array = array();
    $i = 0;
    while ($t_row = db_fetch_array($t_result)) {
        $t_bug_relationship_data[$i] = new BugRelationshipData();
        $t_bug_relationship_data[$i]->id = $t_row['id'];
        $t_bug_relationship_data[$i]->src_bug_id = $t_row['source_bug_id'];
        $t_bug_relationship_data[$i]->src_project_id = $t_row['project_id'];
        $t_bug_relationship_data[$i]->dest_bug_id = $t_row['destination_bug_id'];
        $t_bug_relationship_data[$i]->dest_project_id = $t_dest_project_id;
        $t_bug_relationship_data[$i]->type = $t_row['relationship_type'];
        $t_bug_array[] = $t_row['source_bug_id'];
        $i++;
    }
    if (!empty($t_bug_array)) {
        bug_cache_array_rows($t_bug_array);
    }
    return $t_bug_relationship_data;
}

/**
 * Given a set of changeset objects, parse the bug links
 * and save the changes.
 * @param array Changeset objects
 * @param object Repository object
 */
function Source_Process_Changesets($p_changesets, $p_repo = null)
{
    global $g_cache_current_user_id;
    if (!is_array($p_changesets)) {
        return;
    }
    if (is_null($p_repo)) {
        $t_repos = SourceRepo::load_by_changesets($p_changesets);
    } else {
        $t_repos = array($p_repo->id => $p_repo);
    }
    $t_resolved_threshold = config_get('bug_resolved_status_threshold');
    $t_fixed_threshold = config_get('bug_resolution_fixed_threshold');
    $t_notfixed_threshold = config_get('bug_resolution_not_fixed_threshold');
    # Link author and committer name/email to user accounts
    foreach ($p_changesets as $t_key => $t_changeset) {
        $p_changesets[$t_key] = Source_Parse_Users($t_changeset);
    }
    # Parse normal bug links
    foreach ($p_changesets as $t_changeset) {
        $t_changeset->bugs = Source_Parse_Buglinks($t_changeset->message);
    }
    # Parse fixed bug links
    $t_fixed_bugs = array();
    # Find and associate resolve links with the changeset
    foreach ($p_changesets as $t_changeset) {
        $t_bugs = Source_Parse_Bugfixes($t_changeset->message);
        foreach ($t_bugs as $t_bug_id) {
            $t_fixed_bugs[$t_bug_id] = $t_changeset;
        }
        # Add the link to the normal set of buglinks
        $t_changeset->bugs = array_unique(array_merge($t_changeset->bugs, $t_bugs));
    }
    # Save changeset data before processing their consequences
    foreach ($p_changesets as $t_changeset) {
        $t_changeset->repo = $p_repo;
        $t_changeset->save();
    }
    # Precache information for resolved bugs
    bug_cache_array_rows(array_keys($t_fixed_bugs));
    $t_current_user_id = $g_cache_current_user_id;
    $t_enable_resolving = config_get('plugin_Source_enable_resolving');
    $t_enable_message = config_get('plugin_Source_enable_message');
    $t_enable_mapping = config_get('plugin_Source_enable_mapping');
    $t_bugfix_status = config_get('plugin_Source_bugfix_status');
    $t_bugfix_status_pvm = config_get('plugin_Source_bugfix_status_pvm');
    $t_resolution = config_get('plugin_Source_bugfix_resolution');
    $t_handler = config_get('plugin_Source_bugfix_handler');
    $t_message_template = str_replace(array('$1', '$2', '$3', '$4', '$5', '$6'), array('%1$s', '%2$s', '%3$s', '%4$s', '%5$s', '%6$s'), config_get('plugin_Source_bugfix_message'));
    $t_mappings = array();
    # Start fixing and/or resolving issues
    foreach ($t_fixed_bugs as $t_bug_id => $t_changeset) {
        # make sure the bug exists before processing
        if (!bug_exists($t_bug_id)) {
            continue;
        }
        # fake the history entries as the committer/author user ID
        $t_user_id = null;
        if ($t_changeset->committer_id > 0) {
            $t_user_id = $t_changeset->committer_id;
        } else {
            if ($t_changeset->user_id > 0) {
                $t_user_id = $t_changeset->user_id;
            }
        }
        if (!is_null($t_user_id)) {
            $g_cache_current_user_id = $t_user_id;
        } else {
            if (!is_null($t_current_user_id)) {
                $g_cache_current_user_id = $t_current_user_id;
            } else {
                $g_cache_current_user_id = 0;
            }
        }
        # generate the branch mappings
        $t_version = '';
        $t_pvm_version_id = 0;
        if ($t_enable_mapping) {
            $t_repo_id = $t_changeset->repo_id;
            if (!isset($t_mappings[$t_repo_id])) {
                $t_mappings[$t_repo_id] = SourceMapping::load_by_repo($t_repo_id);
            }
            if (isset($t_mappings[$t_repo_id][$t_changeset->branch])) {
                $t_mapping = $t_mappings[$t_repo_id][$t_changeset->branch];
                if (Source_PVM()) {
                    $t_pvm_version_id = $t_mapping->apply_pvm($t_bug_id);
                } else {
                    $t_version = $t_mapping->apply($t_bug_id);
                }
            }
        }
        # generate a note message
        if ($t_enable_message) {
            $t_message = sprintf($t_message_template, $t_changeset->branch, $t_changeset->revision, $t_changeset->timestamp, $t_changeset->message, $t_repos[$t_changeset->repo_id]->name, $t_changeset->id);
//.........这里部分代码省略.........

/**
 * Print list of open bugs with the highest activity score the score is calculated assigning
 * one "point" for each history event associated with the bug
 * @return void
 */
function summary_print_by_activity()
{
    $t_project_id = helper_get_current_project();
    $t_resolved = config_get('bug_resolved_status_threshold');
    $t_specific_where = helper_project_specific_where($t_project_id);
    if (' 1<>1' == $t_specific_where) {
        return;
    }
    $t_query = 'SELECT COUNT(h.id) as count, b.id, b.summary, b.view_state
				FROM {bug} b, {bug_history} h
				WHERE h.bug_id = b.id
				AND b.status < ' . db_param() . '
				AND ' . $t_specific_where . '
				GROUP BY h.bug_id, b.id, b.summary, b.last_updated, b.view_state
				ORDER BY count DESC, b.last_updated DESC';
    $t_result = db_query($t_query, array($t_resolved));
    $t_count = 0;
    $t_private_bug_threshold = config_get('private_bug_threshold');
    $t_summarydata = array();
    $t_summarybugs = array();
    while ($t_row = db_fetch_array($t_result)) {
        # Skip private bugs unless user has proper permissions
        if (VS_PRIVATE == $t_row['view_state'] && false == access_has_bug_level($t_private_bug_threshold, $t_row['id'])) {
            continue;
        }
        if ($t_count++ == 10) {
            break;
        }
        $t_summarydata[] = array('id' => $t_row['id'], 'summary' => $t_row['summary'], 'count' => $t_row['count']);
        $t_summarybugs[] = $t_row['id'];
    }
    bug_cache_array_rows($t_summarybugs);
    foreach ($t_summarydata as $t_row) {
        $t_bugid = string_get_bug_view_link($t_row['id']);
        $t_summary = string_display_line($t_row['summary']);
        $t_notescount = $t_row['count'];
        echo '<tr>' . "\n";
        echo '<td class="small">' . $t_bugid . ' - ' . $t_summary . '</td><td class="right">' . $t_notescount . '</td>' . "\n";
        echo '</tr>' . "\n";
    }
}

function summary_print_by_activity()
{
    $t_mantis_bug_table = db_get_table('mantis_bug_table');
    $t_mantis_history_table = db_get_table('mantis_bug_history_table');
    $t_project_id = helper_get_current_project();
    $t_user_id = auth_get_current_user_id();
    $t_resolved = config_get('bug_resolved_status_threshold');
    $specific_where = helper_project_specific_where($t_project_id);
    if (' 1<>1' == $specific_where) {
        return;
    }
    $query = "SELECT COUNT(h.id) as count, b.id, b.summary, b.view_state\n\t\t\t\tFROM {$t_mantis_bug_table} AS b, {$t_mantis_history_table} AS h\n\t\t\t\tWHERE h.bug_id = b.id\n\t\t\t\tAND b.status < " . db_param() . "\n\t\t\t\tAND {$specific_where}\n\t\t\t\tGROUP BY h.bug_id, b.id, b.summary, b.last_updated, b.view_state\n\t\t\t\tORDER BY count DESC, b.last_updated DESC";
    $result = db_query_bound($query, array($t_resolved));
    $t_count = 0;
    $t_private_bug_threshold = config_get('private_bug_threshold');
    $t_summarydata = array();
    $t_summarybugs = array();
    while ($row = db_fetch_array($result)) {
        // Skip private bugs unless user has proper permissions
        if (VS_PRIVATE == $row['view_state'] && false == access_has_bug_level($t_private_bug_threshold, $row['id'])) {
            continue;
        }
        if ($t_count++ == 10) {
            break;
        }
        $t_summarydata[] = array('id' => $row['id'], 'summary' => $row['summary'], 'count' => $row['count']);
        $t_summarybugs[] = $row['id'];
    }
    bug_cache_array_rows($t_summarybugs);
    foreach ($t_summarydata as $row) {
        $t_bugid = string_get_bug_view_link($row['id']);
        $t_summary = string_display_line($row['summary']);
        $t_notescount = $row['count'];
        print "<tr " . helper_alternate_class() . ">\n";
        print "<td class=\"small\">{$t_bugid} - {$t_summary}</td><td class=\"right\">{$t_notescount}</td>\n";
        print "</tr>\n";
    }
}

/**
 * get all relationships with the given bug as destination
 * @param int $p_dest_bug_id Destination Bug id
 * @return array Array of BugRelationshipData objects
 */
function relationship_get_all_dest($p_dest_bug_id)
{
    $c_dest_bug_id = db_prepare_int($p_dest_bug_id);
    $t_mantis_bug_relationship_table = db_get_table('bug_relationship');
    $t_mantis_bug_table = db_get_table('bug');
    $query = "SELECT {$t_mantis_bug_relationship_table}.id, {$t_mantis_bug_relationship_table}.relationship_type,\n\t\t\t\t{$t_mantis_bug_relationship_table}.source_bug_id, {$t_mantis_bug_relationship_table}.destination_bug_id,\n\t\t\t\t{$t_mantis_bug_table}.project_id\n\t\t\t\tFROM {$t_mantis_bug_relationship_table}\n\t\t\t\tINNER JOIN {$t_mantis_bug_table} ON {$t_mantis_bug_relationship_table}.source_bug_id = {$t_mantis_bug_table}.id\n\t\t\t\tWHERE destination_bug_id=" . db_param() . "\n\t\t\t\tORDER BY relationship_type, {$t_mantis_bug_relationship_table}.id";
    $result = db_query_bound($query, array($c_dest_bug_id));
    $t_dest_project_id = bug_get_field($p_dest_bug_id, 'project_id');
    $t_bug_relationship_data = array();
    $t_relationship_count = db_num_rows($result);
    $t_bug_array = array();
    for ($i = 0; $i < $t_relationship_count; $i++) {
        $row = db_fetch_array($result);
        $t_bug_relationship_data[$i] = new BugRelationshipData();
        $t_bug_relationship_data[$i]->id = $row['id'];
        $t_bug_relationship_data[$i]->src_bug_id = $row['source_bug_id'];
        $t_bug_relationship_data[$i]->src_project_id = $row['project_id'];
        $t_bug_relationship_data[$i]->dest_bug_id = $row['destination_bug_id'];
        $t_bug_relationship_data[$i]->dest_project_id = $t_dest_project_id;
        $t_bug_relationship_data[$i]->type = $row['relationship_type'];
        $t_bug_array[] = $row['source_bug_id'];
    }
    unset($t_bug_relationship_data[$t_relationship_count]);
    if (!empty($t_bug_array)) {
        bug_cache_array_rows($t_bug_array);
    }
    return $t_bug_relationship_data;
}

require_api('print_api.php');
require_api('string_api.php');
require_api('utility_api.php');
require_api('version_api.php');
auth_ensure_user_authenticated();
$f_action = gpc_get_string('action', '');
$f_bug_arr = gpc_get_int_array('bug_arr', array());
# redirects to all_bug_page if nothing is selected
if (is_blank($f_action) || 0 == count($f_bug_arr)) {
    print_header_redirect('view_all_bug_page.php');
}
# run through the issues to see if they are all from one project
$t_project_id = ALL_PROJECTS;
$t_multiple_projects = false;
$t_projects = array();
bug_cache_array_rows($f_bug_arr);
foreach ($f_bug_arr as $t_bug_id) {
    $t_bug = bug_get($t_bug_id);
    if ($t_project_id != $t_bug->project_id) {
        if ($t_project_id != ALL_PROJECTS && !$t_multiple_projects) {
            $t_multiple_projects = true;
        } else {
            $t_project_id = $t_bug->project_id;
            $t_projects[$t_project_id] = $t_project_id;
        }
    }
}
if ($t_multiple_projects) {
    $t_project_id = ALL_PROJECTS;
    $t_projects[ALL_PROJECTS] = ALL_PROJECTS;
}

<?php

# Copyright (c) 2012 John Reese
# Licensed under the MIT license
access_ensure_global_level(plugin_config_get('view_threshold'));
$t_can_update = access_has_project_level(plugin_config_get('update_threshold'));
require_once config_get('plugin_path') . 'Source/Source.ViewAPI.php';
$f_changeset_id = gpc_get_int('id');
$f_offset = gpc_get_int('offset', 0);
$t_changeset = SourceChangeset::load($f_changeset_id);
$t_changeset->load_files();
$t_changeset->load_bugs();
bug_cache_array_rows($t_changeset->bugs);
$t_bug_rows = array();
foreach ($t_changeset->bugs as $t_bug_id) {
    $t_bug_row = bug_cache_row($t_bug_id, false);
    if (false === $t_bug_row) {
        continue;
    }
    $t_bug_rows[$t_bug_id] = $t_bug_row;
}
$t_affected_rowspan = count($t_bug_rows) + ($t_can_update ? 1 : 0);
$t_repos = SourceRepo::load_by_changesets($t_changeset);
if (count($t_repos) < 1) {
    trigger_error(ERROR_GENERIC, ERROR);
}
$t_repo = array_shift($t_repos);
$t_repo->load_branches();
if ($t_changeset->parent) {
    $t_changeset_parent = SourceChangeset::load_by_revision($t_repo, $t_changeset->parent);
} else {

}
if ($category_name)
{
	$query .= " AND category_id IN (" . join(", ", $category_ids) . ")";
}

$query .= " ORDER BY status ASC, priority DESC, id DESC";
$result = db_query_bound($query, $params);

$bug_ids = array();
while ($row = db_fetch_array($result))
{
	$bug_ids[] = $row["id"];
}

bug_cache_array_rows($bug_ids);
$bugs = array();
$status = array();
$columns = plugin_config_get("board_columns");
$sevcolors = plugin_config_get("board_severity_colors");
$rescolors = plugin_config_get("board_resolution_colors");
$sprint_length = plugin_config_get("sprint_length");

$use_source = plugin_is_loaded("Source");
$resolved_count = 0;

foreach ($bug_ids as $bug_id)
{
	$bug = bug_get($bug_id);
	$bugs[$bug->status][] = $bug;