PHP databaseapi::get_issues_by_user_project_version_status示例

示例#1

文件： UserProject.php 项目： Cre-ator/Whiteboard.UserProjectView-Plugin

/**
 * remark about issues, where last update is older than configured threshold
 *
 * @param $data_row
 * @param $print
 * @param $group_index
 */
function remark_old_issues($data_row, $print, $group_index)
{
    $user_id = $data_row['user_id'];
    $assigned_project_id = $data_row['assigned_project_id'];
    $target_version_id = $data_row['target_version_id'];
    $target_version = '';
    if (strlen($target_version_id) > 0) {
        $target_version = version_get_field($target_version_id, 'version');
    }
    for ($stat_index = 1; $stat_index <= userprojectapi::get_stat_count(); $stat_index++) {
        $stat_issue_age_threshold = plugin_config_get('IAGThreshold' . $stat_index);
        if ($assigned_project_id == null) {
            continue;
        }
        $stat_ignore_status = plugin_config_get('CStatIgn' . $stat_index);
        $stat_status_id = plugin_config_get('CStatSelect' . $stat_index);
        $databaseapi = new databaseapi();
        $stat_issue_ids = $databaseapi->get_issues_by_user_project_version_status($user_id, $assigned_project_id, $target_version, $stat_status_id, $stat_ignore_status, $group_index);
        if (!empty($stat_issue_ids)) {
            $stat_time_difference = userprojectapi::calculate_time_difference($stat_issue_ids)[0];
            $stat_oldest_issue_id = userprojectapi::calculate_time_difference($stat_issue_ids)[1];
            if ($stat_time_difference > $stat_issue_age_threshold && !$print) {
                if ($stat_ignore_status == OFF || $group_index == 3) {
                    $stat_enum = MantisEnum::getAssocArrayIndexedByValues(lang_get('status_enum_string'));
                    $filter_string = '<a href="search.php?project_id=' . $assigned_project_id . '&amp;search=' . $stat_oldest_issue_id . '&amp;status_id=' . $stat_status_id;
                    if ($group_index != 3) {
                        $filter_string .= '&amp;handler_id=' . userprojectapi::get_link_user_id($user_id);
                    }
                    $filter_string .= '&amp;sticky_issues=on' . '&amp;target_version=' . $target_version . '&amp;sortby=last_updated' . '&amp;dir=DESC' . '&amp;hide_status_id=-2' . '&amp;match_type=0">';
                    echo $filter_string;
                    echo '"' . $stat_enum[$stat_status_id] . '"' . ' ' . plugin_lang_get('remark_since') . ' ' . $stat_time_difference . ' ' . plugin_lang_get('remark_day');
                    echo '<br/>' . PHP_EOL;
                    echo '</a>';
                }
            }
        }
    }
}