<?php
# Mantis - a php based bugtracking system
# Copyright (C) 2000 - 2002 Kenzaburo Ito - kenito@300baud.org
# Copyright (C) 2002 - 2007 Mantis Team - mantisbt-dev@lists.sourceforge.net
# Mantis is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 2 of the License, or
# (at your option) any later version.
#
# Mantis is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with Mantis. If not, see <http://www.gnu.org/licenses/>.
#------------------------------
# $Revision: 2643 $
# $Author: al $
# $Date: 2009-06-18 19:06:27 -0400 (Thu, 18 Jun 2009) $
#------------------------------
$t_core_dir = dirname( __FILE__ ).DIRECTORY_SEPARATOR;
require_once( $t_core_dir . 'current_user_api.php' );
require_once( $t_core_dir . 'user_api.php' );
require_once( $t_core_dir . 'bug_api.php' );
require_once( $t_core_dir . 'collapse_api.php' );
require_once( $t_core_dir . 'relationship_api.php' );
require_once( $t_core_dir . 'tag_api.php' );
###########################################################################
# Filter Property Names
###########################################################################
define( 'FILTER_PROPERTY_FREE_TEXT', 'search' );
define( 'FILTER_PROPERTY_CATEGORY', 'show_category' );
define( 'FILTER_PROPERTY_SEVERITY_ID', 'show_severity' );
define( 'FILTER_PROPERTY_STATUS_ID', 'show_status' );
define( 'FILTER_PROPERTY_PRIORITY_ID', 'show_priority' );
define( 'FILTER_PROPERTY_HIGHLIGHT_CHANGED', 'highlight_changed' );
define( 'FILTER_PROPERTY_REPORTER_ID', 'reporter_id' );
define( 'FILTER_PROPERTY_HANDLER_ID', 'handler_id' );
define( 'FILTER_PROPERTY_PROJECT_ID', 'project_id' );
define( 'FILTER_PROPERTY_RESOLUTION_ID', 'show_resolution' );
define( 'FILTER_PROPERTY_PRODUCT_BUILD', 'show_build' );
define( 'FILTER_PROPERTY_PRODUCT_VERSION', 'show_version' );
define( 'FILTER_PROPERTY_MONITOR_USER_ID', 'user_monitor' );
define( 'FILTER_PROPERTY_HIDE_STATUS_ID', 'hide_status' );
define( 'FILTER_PROPERTY_SORT_FIELD_NAME', 'sort' );
define( 'FILTER_PROPERTY_SORT_DIRECTION', 'dir' );
define( 'FILTER_PROPERTY_SHOW_STICKY_ISSUES', 'sticky_issues' );
define( 'FILTER_PROPERTY_VIEW_STATE_ID', 'view_state' );
define( 'FILTER_PROPERTY_FIXED_IN_VERSION', 'fixed_in_version' );
define( 'FILTER_PROPERTY_TARGET_VERSION', 'target_version' );
define( 'FILTER_PROPERTY_ISSUES_PER_PAGE', 'per_page' );
define( 'FILTER_PROPERTY_PROFILE', 'profile_id' );
define( 'FILTER_PROPERTY_PLATFORM', 'platform' );
define( 'FILTER_PROPERTY_OS', 'os' );
define( 'FILTER_PROPERTY_OS_BUILD', 'os_build' );
define( 'FILTER_PROPERTY_START_DAY', 'start_day' );
define( 'FILTER_PROPERTY_START_MONTH', 'start_month' );
define( 'FILTER_PROPERTY_START_YEAR', 'start_year' );
define( 'FILTER_PROPERTY_END_DAY', 'end_day' );
define( 'FILTER_PROPERTY_END_MONTH', 'end_month' );
define( 'FILTER_PROPERTY_END_YEAR', 'end_year' );
define( 'FILTER_PROPERTY_NOT_ASSIGNED', 'and_not_assigned' );
define( 'FILTER_PROPERTY_FILTER_BY_DATE', 'do_filter_by_date' );
define( 'FILTER_PROPERTY_RELATIONSHIP_TYPE', 'relationship_type' );
define( 'FILTER_PROPERTY_RELATIONSHIP_BUG', 'relationship_bug' );
define( 'FILTER_PROPERTY_TAG_STRING', 'tag_string' );
define( 'FILTER_PROPERTY_TAG_SELECT', 'tag_select' );
###########################################################################
# Filter Query Parameter Names
###########################################################################
define( 'FILTER_SEARCH_FREE_TEXT', 'search' );
define( 'FILTER_SEARCH_CATEGORY', 'category' );
define( 'FILTER_SEARCH_SEVERITY_ID', 'severity_id');
define( 'FILTER_SEARCH_STATUS_ID', 'status_id' );
define( 'FILTER_SEARCH_REPORTER_ID', 'reporter_id' );
define( 'FILTER_SEARCH_HANDLER_ID', 'handler_id' );
define( 'FILTER_SEARCH_PROJECT_ID', 'project_id' );
define( 'FILTER_SEARCH_RESOLUTION_ID', 'resolution_id' );
define( 'FILTER_SEARCH_FIXED_IN_VERSION', 'fixed_in_version' );
define( 'FILTER_SEARCH_TARGET_VERSION', 'target_version' );
define( 'FILTER_SEARCH_START_DAY', 'start_day' );
define( 'FILTER_SEARCH_START_MONTH', 'start_month' );
define( 'FILTER_SEARCH_START_YEAR', 'start_year' );
define( 'FILTER_SEARCH_END_DAY', 'end_day' );
define( 'FILTER_SEARCH_END_MONTH', 'end_month' );
define( 'FILTER_SEARCH_END_YEAR', 'end_year' );
define( 'FILTER_SEARCH_PRIORITY_ID', 'priority_id' );
define( 'FILTER_SEARCH_PROFILE', 'profile_id' );
define( 'FILTER_SEARCH_PLATFORM', 'platform' );
define( 'FILTER_SEARCH_OS', 'os' );
define( 'FILTER_SEARCH_OS_BUILD', 'os_build' );
define( 'FILTER_SEARCH_MONITOR_USER_ID', 'monitor_user_id' );
define( 'FILTER_SEARCH_PRODUCT_BUILD', 'product_build' );
define( 'FILTER_SEARCH_PRODUCT_VERSION', 'product_version' );
define( 'FILTER_SEARCH_VIEW_STATE_ID', 'view_state_id' );
define( 'FILTER_SEARCH_SHOW_STICKY_ISSUES', 'sticky_issues' );
define( 'FILTER_SEARCH_SORT_FIELD_NAME', 'sortby' );
define( 'FILTER_SEARCH_SORT_DIRECTION', 'dir' );
define( 'FILTER_SEARCH_ISSUES_PER_PAGE', 'per_page' );
define( 'FILTER_SEARCH_HIGHLIGHT_CHANGED', 'highlight_changed' );
define( 'FILTER_SEARCH_HIDE_STATUS_ID', 'hide_status_id' );
define( 'FILTER_SEARCH_NOT_ASSIGNED', 'not_assigned' );
define( 'FILTER_SEARCH_FILTER_BY_DATE', 'filter_by_date' );
define( 'FILTER_SEARCH_RELATIONSHIP_TYPE', 'relationship_type' );
define( 'FILTER_SEARCH_RELATIONSHIP_BUG', 'relationship_bug' );
define( 'FILTER_SEARCH_TAG_STRING', 'tag_string' );
define( 'FILTER_SEARCH_TAG_SELECT', 'tag_select' );
# Checks the supplied value to see if it is an ANY value.
# $p_field_value - The value to check.
# Returns true for "ANY" values and false for others. "ANY" means filter criteria not active.
function filter_str_field_is_any( $p_field_value ) {
if ( is_array( $p_field_value ) ) {
if ( count( $p_field_value ) == 0 ) {
return true;
}
foreach( $p_field_value as $t_value ) {
if ( ( META_FILTER_ANY == $t_value ) && ( is_numeric( $t_value ) ) ) {
return true;
}
}
} else {
if ( is_string( $p_field_value ) && is_blank( $p_field_value ) ) {
return true;
}
if ( is_bool( $p_field_value ) && !$p_field_value ) {
return true;
}
if ( ( META_FILTER_ANY == $p_field_value ) && ( is_numeric( $p_field_value ) ) ) {
return true;
}
}
return false;
}
# Encodes a field and it's value for the filter URL. This handles the URL encoding
# and arrays.
# $p_field_name - The field name.
# $p_field_value - The field value (can be an array)
function filter_encode_field_and_value( $p_field_name, $p_field_value ) {
$t_query_array = array();
if ( is_array( $p_field_value ) ) {
$t_count = count( $p_field_value );
if ( $t_count > 1 ) {
foreach ( $p_field_value as $t_value ) {
$t_query_array[] = urlencode( $p_field_name . '[]' ) . '=' . urlencode( $t_value );
}
} else if ( $t_count == 1 ) {
$t_query_array[] = urlencode( $p_field_name ) . '=' . urlencode( $p_field_value[0] );
}
} else {
$t_query_array[] = urlencode( $p_field_name ) . '=' . urlencode( $p_field_value );
}
return implode( $t_query_array, '&' );
}
# Get a permalink for the current active filter. The results of using these fields by other users
# can be inconsistent with the original results due to fields like "Myself", "Current Project",
# and due to access level.
# Returns the search.php?xxxx or an empty string if no criteria applied.
function filter_get_url( $p_custom_filter ) {
$t_query = array();
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_PROJECT_ID] ) ) {
$t_project_id = $p_custom_filter[FILTER_PROPERTY_PROJECT_ID];
if ( count( $t_project_id ) == 1 && $t_project_id[0] == META_FILTER_CURRENT ) {
$t_project_id = array( helper_get_current_project() );
}
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_PROJECT_ID, $t_project_id );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_FREE_TEXT] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_FREE_TEXT, $p_custom_filter[FILTER_PROPERTY_FREE_TEXT] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_CATEGORY] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_CATEGORY, $p_custom_filter[FILTER_PROPERTY_CATEGORY] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_REPORTER_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_REPORTER_ID, $p_custom_filter[FILTER_PROPERTY_REPORTER_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_STATUS_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_STATUS_ID, $p_custom_filter[FILTER_PROPERTY_STATUS_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_MONITOR_USER_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_MONITOR_USER_ID, $p_custom_filter[FILTER_PROPERTY_MONITOR_USER_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_HANDLER_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_HANDLER_ID, $p_custom_filter[FILTER_PROPERTY_HANDLER_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_SEVERITY_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_SEVERITY_ID, $p_custom_filter[FILTER_PROPERTY_SEVERITY_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_RESOLUTION_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_RESOLUTION_ID, $p_custom_filter[FILTER_PROPERTY_RESOLUTION_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_PRIORITY_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_PRIORITY_ID, $p_custom_filter[FILTER_PROPERTY_PRIORITY_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_VIEW_STATE_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_VIEW_STATE_ID, $p_custom_filter[FILTER_PROPERTY_VIEW_STATE_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_SHOW_STICKY_ISSUES] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_SHOW_STICKY_ISSUES, $p_custom_filter[FILTER_PROPERTY_SHOW_STICKY_ISSUES] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_PRODUCT_VERSION] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_PRODUCT_VERSION, $p_custom_filter[FILTER_PROPERTY_PRODUCT_VERSION] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_PRODUCT_BUILD] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_PRODUCT_BUILD, $p_custom_filter[FILTER_PROPERTY_PRODUCT_BUILD] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_FIXED_IN_VERSION] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_FIXED_IN_VERSION, $p_custom_filter[FILTER_PROPERTY_FIXED_IN_VERSION] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_TARGET_VERSION] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_TARGET_VERSION, $p_custom_filter[FILTER_PROPERTY_TARGET_VERSION] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_SORT_FIELD_NAME] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_SORT_FIELD_NAME, $p_custom_filter[FILTER_PROPERTY_SORT_FIELD_NAME] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_SORT_DIRECTION] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_SORT_DIRECTION, $p_custom_filter[FILTER_PROPERTY_SORT_DIRECTION] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_SEARCH_ISSUES_PER_PAGE] ) ) {
if ( $p_custom_filter[FILTER_SEARCH_ISSUES_PER_PAGE] != config_get( 'default_limit_view' ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_PROPERTY_ISSUES_PER_PAGE, $p_custom_filter[FILTER_SEARCH_ISSUES_PER_PAGE] );
}
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_HIGHLIGHT_CHANGED] ) ) {
if ( $p_custom_filter[FILTER_PROPERTY_HIGHLIGHT_CHANGED] != config_get( 'default_show_changed' ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_HIGHLIGHT_CHANGED, $p_custom_filter[FILTER_PROPERTY_HIGHLIGHT_CHANGED] );
}
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_HIDE_STATUS_ID] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_HIDE_STATUS_ID, $p_custom_filter[FILTER_PROPERTY_HIDE_STATUS_ID] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_NOT_ASSIGNED] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_NOT_ASSIGNED, $p_custom_filter[FILTER_PROPERTY_NOT_ASSIGNED] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_FILTER_BY_DATE] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_FILTER_BY_DATE, $p_custom_filter[FILTER_PROPERTY_FILTER_BY_DATE] );
# The start and end dates are only applicable if filter by date is set.
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_START_DAY] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_START_DAY, $p_custom_filter[FILTER_PROPERTY_START_DAY] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_END_DAY] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_END_DAY, $p_custom_filter[FILTER_PROPERTY_END_DAY] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_START_MONTH] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_START_MONTH, $p_custom_filter[FILTER_PROPERTY_START_MONTH] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_END_MONTH] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_END_MONTH, $p_custom_filter[FILTER_PROPERTY_END_MONTH] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_START_YEAR] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_START_YEAR, $p_custom_filter[FILTER_PROPERTY_START_YEAR] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_END_YEAR] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_END_YEAR, $p_custom_filter[FILTER_PROPERTY_END_YEAR] );
}
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_RELATIONSHIP_TYPE] ) ) {
if ( $p_custom_filter[FILTER_PROPERTY_RELATIONSHIP_TYPE] != -1 ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_RELATIONSHIP_TYPE, $p_custom_filter[FILTER_PROPERTY_RELATIONSHIP_TYPE] );
}
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_RELATIONSHIP_BUG] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_RELATIONSHIP_BUG, $p_custom_filter[FILTER_PROPERTY_RELATIONSHIP_BUG] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_PLATFORM] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_PLATFORM, $p_custom_filter[FILTER_PROPERTY_PLATFORM] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_OS] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_OS, $p_custom_filter[FILTER_PROPERTY_OS] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_OS_BUILD] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_OS_BUILD, $p_custom_filter[FILTER_PROPERTY_OS_BUILD] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_TAG_STRING] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_TAG_STRING, $p_custom_filter[FILTER_PROPERTY_TAG_STRING] );
}
if ( !filter_str_field_is_any( $p_custom_filter[FILTER_PROPERTY_TAG_SELECT] ) ) {
$t_query[] = filter_encode_field_and_value( FILTER_SEARCH_TAG_SELECT, $p_custom_filter[FILTER_PROPERTY_TAG_SELECT] );
}
if ( isset( $p_custom_filter['custom_fields'] ) ) {
foreach( $p_custom_filter['custom_fields'] as $t_custom_field_id => $t_custom_field_values ) {
if ( !filter_str_field_is_any( $t_custom_field_values ) ) {
$t_query[] = filter_encode_field_and_value( 'custom_field_' . $t_custom_field_id, $t_custom_field_values );
}
}
}
if ( count( $t_query ) > 0 ) {
$t_query_str = implode( $t_query, '&' );
$t_url = config_get( 'path' ) . 'search.php?' . $t_query_str;
} else {
$t_url = '';
}
return $t_url;
}
###########################################################################
# Filter API
###########################################################################
# Get the standard filter that is to be used when no filter was previously saved.
# When creating specific filters, this can be used as a basis for the filter, where
# specific entries can be overridden.
function filter_get_default() {
$t_hide_status_default = config_get( 'hide_status_default' );
$t_default_show_changed = config_get( 'default_show_changed' );
$t_filter = array(
'show_category' => Array ( '0' => META_FILTER_ANY ),
'show_severity' => Array ( '0' => META_FILTER_ANY ),
'show_status' => Array ( '0' => META_FILTER_ANY ),
'highlight_changed' => $t_default_show_changed,
'reporter_id' => Array ( '0' => META_FILTER_ANY ),
'handler_id' => Array ( '0' => META_FILTER_ANY ),
'project_id' => Array ( '0' => META_FILTER_CURRENT ),
'show_resolution' => Array ( '0' => META_FILTER_ANY ),
'show_build' => Array ( '0' => META_FILTER_ANY ),
'show_version' => Array ( '0' => META_FILTER_ANY ),
'hide_status' => Array ( '0' => $t_hide_status_default ),
'user_monitor' => Array ( '0' => META_FILTER_ANY ),
'sort' => 'last_updated',
'dir' => 'DESC'
);
return filter_ensure_valid_filter( $t_filter );
}
# @@@ Had to make all these parameters required because we can't use
# call-time pass by reference anymore. I really preferred not having
# to pass all the params in if you didn't want to, but I wanted to get
# rid of the errors for now. If we can think of a better way later
# (maybe return an object) that would be great.
#
# $p_page_numer
# - the page you want to see (set to the actual page on return)
# $p_per_page
# - the number of bugs to see per page (set to actual on return)
# -1 indicates you want to see all bugs
# null indicates you want to use the value specified in the filter
# $p_page_count
# - you don't need to give a value here, the number of pages will be
# stored here on return
# $p_bug_count
# - you don't need to give a value here, the number of bugs will be
# stored here on return
# $p_custom_filter
# - Filter to use.
# $p_project_id
# - project id to use in filtering.
# $p_user_id
# - user id to use as current user when filtering.
# $p_show_sticky
# - get sticky issues only.
function filter_get_bug_rows( &$p_page_number, &$p_per_page, &$p_page_count, &$p_bug_count, $p_custom_filter = null, $p_project_id = null, $p_user_id = null, $p_show_sticky = null ) {
log_event( LOG_FILTERING, 'FILTERING: START NEW FILTER QUERY' );
$t_bug_table = config_get( 'mantis_bug_table' );
$t_bug_text_table = config_get( 'mantis_bug_text_table' );
$t_bugnote_table = config_get( 'mantis_bugnote_table' );
$t_custom_field_string_table = config_get( 'mantis_custom_field_string_table' );
$t_bugnote_text_table = config_get( 'mantis_bugnote_text_table' );
$t_project_table = config_get( 'mantis_project_table' );
$t_bug_monitor_table = config_get( 'mantis_bug_monitor_table' );
$t_limit_reporters = config_get( 'limit_reporters' );
$t_bug_relationship_table = config_get( 'mantis_bug_relationship_table' );
$t_report_bug_threshold = config_get( 'report_bug_threshold' );
$t_current_user_id = auth_get_current_user_id();
if ( null === $p_user_id ) {
$t_user_id = $t_current_user_id;
} else {
$t_user_id = $p_user_id;
}
$c_user_id = db_prepare_int( $t_user_id );
if ( null === $p_project_id ) {
# @@@ If project_id is not specified, then use the project id(s) in the filter if set, otherwise, use current project.
$t_project_id = helper_get_current_project();
} else {
$t_project_id = $p_project_id;
}
if ( $p_custom_filter === null ) {
# Prefer current_user_get_bug_filter() over user_get_filter() when applicable since it supports
# cookies set by previous version of the code.
if ( $t_user_id == $t_current_user_id ) {
$t_filter = current_user_get_bug_filter();
} else {
$t_filter = user_get_bug_filter( $t_user_id, $t_project_id );
}
} else {
$t_filter = $p_custom_filter;
}
$t_filter = filter_ensure_valid_filter( $t_filter );
if ( false === $t_filter ) {
return false; # signify a need to create a cookie
#@@@ error instead?
}
$t_view_type = $t_filter['_view_type'];
$t_where_clauses = array( "$t_project_table.enabled = 1", "$t_project_table.id = $t_bug_table.project_id" );
$t_select_clauses = array( "$t_bug_table.*" );
$t_join_clauses = array();
$t_from_clauses = array();
// normalize the project filtering into an array $t_project_ids
if ( 'simple' == $t_view_type ) {
log_event( LOG_FILTERING, 'FILTERING: Simple Filter' );
$t_project_ids = array( $t_project_id );
$t_include_sub_projects = true;
} else {
log_event( LOG_FILTERING, 'FILTERING: Advanced Filter' );
if ( !is_array( $t_filter['project_id'] ) ) {
$t_project_ids = array( db_prepare_int( $t_filter['project_id'] ) );
} else {
$t_project_ids = array_map( 'db_prepare_int', $t_filter['project_id'] );
}
$t_include_sub_projects = ( ( count( $t_project_ids ) == 1 ) && ( $t_project_ids[0] == META_FILTER_CURRENT ) );
}
log_event( LOG_FILTERING, 'FILTERING: project_ids = ' . implode( ',', $t_project_ids ) );
log_event( LOG_FILTERING, 'FILTERING: include sub-projects = ' . ( $t_include_sub_projects ? '1' : '0' ) );
// if the array has ALL_PROJECTS, then reset the array to only contain ALL_PROJECTS.
// replace META_FILTER_CURRENT with the actualy current project id.
$t_all_projects_found = false;
$t_new_project_ids = array();
foreach ( $t_project_ids as $t_pid ) {
if ( $t_pid == META_FILTER_CURRENT ) {
$t_pid = $t_project_id;
}
if ( $t_pid == ALL_PROJECTS ) {
$t_all_projects_found = true;
log_event( LOG_FILTERING, 'FILTERING: all projects selected' );
break;
}
// filter out inaccessible projects.
if ( !access_has_project_level( VIEWER, $t_pid, $t_user_id ) ) {
continue;
}
$t_new_project_ids[] = $t_pid;
}
$t_projects_query_required = true;
if ( $t_all_projects_found ) {
if ( user_is_administrator( $t_user_id ) ) {
log_event( LOG_FILTERING, 'FILTERING: all projects + administrator, hence no project filter.' );
$t_projects_query_required = false;
} else {
$t_project_ids = user_get_accessible_projects( $t_user_id );
}
} else {
$t_project_ids = $t_new_project_ids;
}
if ( $t_projects_query_required ) {
// expand project ids to include sub-projects
if ( $t_include_sub_projects ) {
$t_top_project_ids = $t_project_ids;
foreach ( $t_top_project_ids as $t_pid ) {
log_event( LOG_FILTERING, 'FILTERING: Getting sub-projects for project id ' . $t_pid );
$t_project_ids = array_merge( $t_project_ids, user_get_all_accessible_subprojects( $t_user_id, $t_pid ) );
}
$t_project_ids = array_unique( $t_project_ids );
}
// if no projects are accessible, then return an empty array.
if ( count( $t_project_ids ) == 0 ) {
log_event( LOG_FILTERING, 'FILTERING: no accessible projects' );
return array();
}
log_event( LOG_FILTERING, 'FILTERING: project_ids after including sub-projects = ' . implode( ',', $t_project_ids ) );
// this array is to be populated with project ids for which we only want to show public issues. This is due to the limited
// access of the current user.
$t_public_only_project_ids = array();
// this array is populated with project ids that the current user has full access to.
$t_private_and_public_project_ids = array();
$t_access_required_to_view_private_bugs = config_get( 'private_bug_threshold' );
foreach ( $t_project_ids as $t_pid ) {
if ( access_has_project_level( $t_access_required_to_view_private_bugs, $t_pid, $t_user_id ) ) {
$t_private_and_public_project_ids[] = $t_pid;
} else {
$t_public_only_project_ids[] = $t_pid;
}
}
log_event( LOG_FILTERING, 'FILTERING: project_ids (with public/private access) = ' . implode( ',', $t_private_and_public_project_ids ) );
log_event( LOG_FILTERING, 'FILTERING: project_ids (with public access) = ' . implode( ',', $t_public_only_project_ids ) );
$t_count_private_and_public_project_ids = count( $t_private_and_public_project_ids );
if ( $t_count_private_and_public_project_ids == 1 ) {
$t_private_and_public_query = "( $t_bug_table.project_id = " . $t_private_and_public_project_ids[0] . " )";
} else if ( $t_count_private_and_public_project_ids > 1 ) {
$t_private_and_public_query = "( $t_bug_table.project_id in (". implode( ', ', $t_private_and_public_project_ids ) . ") )";
} else {
$t_private_and_public_query = null;
}
$t_count_public_only_project_ids = count( $t_public_only_project_ids );
$t_public_view_state_check = "( ( $t_bug_table.view_state = " . VS_PUBLIC . " ) OR ( $t_bug_table.reporter_id = $t_user_id ) )";
if ( $t_count_public_only_project_ids == 1 ) {
$t_public_only_query = "( ( $t_bug_table.project_id = " . $t_public_only_project_ids[0] . " ) AND $t_public_view_state_check )";
} else if ( $t_count_public_only_project_ids > 1 ) {
$t_public_only_query = "( ( $t_bug_table.project_id in (". implode( ', ', $t_public_only_project_ids ) . ") ) AND $t_public_view_state_check )";
} else {
$t_public_only_query = null;
}
// both queries can't be null, so we either have one of them or both.
if ( $t_private_and_public_query === null ) {
$t_project_query = $t_public_only_query;
} else if ( $t_public_only_query === null ) {
$t_project_query = $t_private_and_public_query;
} else {
$t_project_query = "( $t_public_only_query OR $t_private_and_public_query )";
}
log_event( LOG_FILTERING, 'FILTERING: project query = ' . $t_project_query );
array_push( $t_where_clauses, $t_project_query );
}
# view state
$t_view_state = db_prepare_int( $t_filter['view_state'] );
if ( ( $t_filter['view_state'] !== META_FILTER_ANY ) && ( !is_blank( $t_filter['view_state'] ) ) ) {
$t_view_state_query = "($t_bug_table.view_state='$t_view_state')";
log_event( LOG_FILTERING, 'FILTERING: view_state query = ' . $t_view_state_query );
array_push( $t_where_clauses, $t_view_state_query );
} else {
log_event( LOG_FILTERING, 'FILTERING: no view_state query' );
}
# reporter
$t_any_found = false;
foreach( $t_filter['reporter_id'] as $t_filter_member ) {
if ( ( META_FILTER_ANY === $t_filter_member ) || ( 0 === $t_filter_member ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['reporter_id'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['reporter_id'] as $t_filter_member ) {
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "0" );
} else {
$c_reporter_id = db_prepare_int( $t_filter_member );
if ( META_FILTER_MYSELF == $c_reporter_id ) {
array_push( $t_clauses, $c_user_id );
} else {
array_push( $t_clauses, $c_reporter_id );
}
}
}
if ( 1 < count( $t_clauses ) ) {
$t_reporter_query = "( $t_bug_table.reporter_id in (". implode( ', ', $t_clauses ) .") )";
} else {
$t_reporter_query = "( $t_bug_table.reporter_id=$t_clauses[0] )";
}
log_event( LOG_FILTERING, 'FILTERING: reporter query = ' . $t_reporter_query );
array_push( $t_where_clauses, $t_reporter_query );
} else {
log_event( LOG_FILTERING, 'FILTERING: no reporter query' );
}
# limit reporter
# @@@ thraxisp - access_has_project_level checks greater than or equal to,
# this assumed that there aren't any holes above REPORTER where the limit would apply
#
if ( ( ON === $t_limit_reporters ) && ( ! access_has_project_level( REPORTER + 1, $t_project_id, $t_user_id ) ) ) {
$c_reporter_id = $c_user_id;
array_push( $t_where_clauses, "($t_bug_table.reporter_id='$c_reporter_id')" );
}
# handler
$t_any_found = false;
foreach( $t_filter['handler_id'] as $t_filter_member ) {
if ( ( META_FILTER_ANY === $t_filter_member ) || ( 0 === $t_filter_member ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['handler_id'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['handler_id'] as $t_filter_member ) {
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, 0 );
} else {
$c_handler_id = db_prepare_int( $t_filter_member );
if ( META_FILTER_MYSELF == $c_handler_id ) {
array_push( $t_clauses, $c_user_id );
} else {
array_push( $t_clauses, $c_handler_id );
}
}
}
if ( 1 < count( $t_clauses ) ) {
$t_handler_query = "( $t_bug_table.handler_id in (". implode( ', ', $t_clauses ) .") )";
} else {
$t_handler_query = "( $t_bug_table.handler_id=$t_clauses[0] )";
}
log_event( LOG_FILTERING, 'FILTERING: handler query = ' . $t_handler_query );
array_push( $t_where_clauses, $t_handler_query );
} else {
log_event( LOG_FILTERING, 'FILTERING: no handler query' );
}
# category
if ( !_filter_is_any( $t_filter['show_category'] ) ) {
$t_clauses = array();
foreach( $t_filter['show_category'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "''" );
} else {
$c_show_category = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_show_category'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.category in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.category=$t_clauses[0] )" );
}
}
# severity
$t_any_found = false;
foreach( $t_filter['show_severity'] as $t_filter_member ) {
if ( ( META_FILTER_ANY == $t_filter_member ) || ( 0 === $t_filter_member ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['show_severity'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['show_severity'] as $t_filter_member ) {
$c_show_severity = db_prepare_int( $t_filter_member );
array_push( $t_clauses, $c_show_severity );
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.severity in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.severity=$t_clauses[0] )" );
}
}
# show / hide status
# take a list of all available statuses then remove the ones that we want hidden, then make sure
# the ones we want shown are still available
$t_status_arr = explode_enum_string( config_get( 'status_enum_string' ) );
$t_available_statuses = array();
$t_desired_statuses = array();
foreach( $t_status_arr as $t_this_status ) {
$t_this_status_arr = explode_enum_arr( $t_this_status );
$t_available_statuses[] = $t_this_status_arr[0];
}
if ( 'simple' == $t_filter['_view_type'] ) {
# simple filtering: if showing any, restrict by the hide status value, otherwise ignore the hide
$t_any_found = false;
$t_this_status = $t_filter['show_status'][0];
$t_this_hide_status = $t_filter['hide_status'][0];
if ( ( META_FILTER_ANY == $t_this_status ) || ( is_blank( $t_this_status ) ) || ( 0 === $t_this_status ) ) {
$t_any_found = true;
}
if ( $t_any_found ) {
foreach( $t_available_statuses as $t_this_available_status ) {
if ( $t_this_hide_status > $t_this_available_status ) {
$t_desired_statuses[] = $t_this_available_status;
}
}
} else {
$t_desired_statuses[] = $t_this_status;
}
} else {
# advanced filtering: ignore the hide
$t_any_found = false;
foreach( $t_filter['show_status'] as $t_this_status ) {
$t_desired_statuses[] = $t_this_status;
if ( ( META_FILTER_ANY == $t_this_status ) || ( is_blank( $t_this_status ) ) || ( 0 === $t_this_status ) ) {
$t_any_found = true;
}
}
if ( $t_any_found ) {
$t_desired_statuses = array();
}
}
if ( count( $t_desired_statuses ) > 0 ) {
$t_clauses = array();
foreach( $t_desired_statuses as $t_filter_member ) {
$c_show_status = db_prepare_int( $t_filter_member );
array_push( $t_clauses, $c_show_status );
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.status in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.status=$t_clauses[0] )" );
}
}
# resolution
$t_any_found = false;
foreach( $t_filter['show_resolution'] as $t_filter_member ) {
if ( META_FILTER_ANY == $t_filter_member ) {
$t_any_found = true;
}
}
if ( count( $t_filter['show_resolution'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['show_resolution'] as $t_filter_member ) {
$c_show_resolution = db_prepare_int( $t_filter_member );
array_push( $t_clauses, $c_show_resolution );
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.resolution in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.resolution=$t_clauses[0] )" );
}
}
# priority
$t_any_found = false;
foreach( $t_filter['show_priority'] as $t_filter_member ) {
if ( ( META_FILTER_ANY == $t_filter_member ) || ( 0 === $t_filter_member ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['show_priority'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['show_priority'] as $t_filter_member ) {
$c_show_priority = db_prepare_int( $t_filter_member );
array_push( $t_clauses, $c_show_priority );
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.priority in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.priority=$t_clauses[0] )" );
}
}
# product build
$t_any_found = false;
foreach( $t_filter['show_build'] as $t_filter_member ) {
if ( ( META_FILTER_ANY == $t_filter_member ) && ( is_numeric( $t_filter_member ) ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['show_build'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
foreach( $t_filter['show_build'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "''" );
} else {
$c_show_build = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_show_build'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.build in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.build=$t_clauses[0] )" );
}
}
# product version
if ( !_filter_is_any( $t_filter['show_version'] ) ) {
$t_clauses = array();
foreach( $t_filter['show_version'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "''" );
} else {
$c_show_version = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_show_version'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.version in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.version=$t_clauses[0] )" );
}
}
# profile
if ( !_filter_is_any( $t_filter['show_profile'] ) ) {
$t_clauses = array();
foreach( $t_filter['show_profile'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "0" );
} else {
$c_show_profile = db_prepare_int( $t_filter_member );
array_push( $t_clauses, "$c_show_profile" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.profile_id in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.profile_id=$t_clauses[0] )" );
}
}
# platform
if ( !_filter_is_any( $t_filter['platform'] ) ) {
$t_clauses = array();
foreach( $t_filter['platform'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, '' );
} else {
$c_platform = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_platform'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.platform in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.platform = $t_clauses[0] )" );
}
}
# os
if ( !_filter_is_any( $t_filter['os'] ) ) {
$t_clauses = array();
foreach( $t_filter['os'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, '' );
} else {
$c_os = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_os'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.os in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.os = $t_clauses[0] )" );
}
}
# os_build
if ( !_filter_is_any( $t_filter['os_build'] ) ) {
$t_clauses = array();
foreach( $t_filter['os_build'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, '' );
} else {
$c_os_build = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_os_build'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.os_build in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.os_build = $t_clauses[0] )" );
}
}
# date filter
if ( ( 'on' == $t_filter['do_filter_by_date'] ) &&
is_numeric( $t_filter['start_month'] ) &&
is_numeric( $t_filter['start_day'] ) &&
is_numeric( $t_filter['start_year'] ) &&
is_numeric( $t_filter['end_month'] ) &&
is_numeric( $t_filter['end_day'] ) &&
is_numeric( $t_filter['end_year'] )
) {
$t_start_string = db_prepare_string( $t_filter['start_year'] . "-". $t_filter['start_month'] . "-" . $t_filter['start_day'] ." 00:00:00" );
$t_end_string = db_prepare_string( $t_filter['end_year'] . "-". $t_filter['end_month'] . "-" . $t_filter['end_day'] ." 23:59:59" );
array_push( $t_where_clauses, "($t_bug_table.date_submitted BETWEEN '$t_start_string' AND '$t_end_string' )" );
}
# fixed in version
if ( !_filter_is_any( $t_filter['fixed_in_version'] ) ) {
$t_clauses = array();
foreach( $t_filter['fixed_in_version'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "''" );
} else {
$c_fixed_in_version = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_fixed_in_version'" );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.fixed_in_version in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.fixed_in_version=$t_clauses[0] )" );
}
}
# target version
if ( !_filter_is_any( $t_filter['target_version'] ) ) {
$t_clauses = array();
foreach( $t_filter['target_version'] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
array_push( $t_clauses, "''" );
} else {
$c_target_version = db_prepare_string( $t_filter_member );
array_push( $t_clauses, "'$c_target_version'" );
}
}
#echo var_dump( $t_clauses ); exit;
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_bug_table.target_version in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_bug_table.target_version=$t_clauses[0] )" );
}
}
# users monitoring a bug
$t_any_found = false;
foreach( $t_filter['user_monitor'] as $t_filter_member ) {
if ( ( META_FILTER_ANY == $t_filter_member ) || ( 0 === $t_filter_member ) ) {
$t_any_found = true;
}
}
if ( count( $t_filter['user_monitor'] ) == 0 ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_clauses = array();
$t_table_name = 'user_monitor';
array_push( $t_from_clauses, $t_bug_monitor_table );
array_push( $t_join_clauses, "LEFT JOIN $t_bug_monitor_table $t_table_name ON $t_table_name.bug_id = $t_bug_table.id" );
foreach( $t_filter['user_monitor'] as $t_filter_member ) {
$c_user_monitor = db_prepare_int( $t_filter_member );
if ( META_FILTER_MYSELF == $c_user_monitor ) {
array_push( $t_clauses, $c_user_id );
} else {
array_push( $t_clauses, $c_user_monitor );
}
}
if ( 1 < count( $t_clauses ) ) {
array_push( $t_where_clauses, "( $t_table_name.user_id in (". implode( ', ', $t_clauses ) .") )" );
} else {
array_push( $t_where_clauses, "( $t_table_name.user_id=$t_clauses[0] )" );
}
}
# bug relationship
$t_any_found = false;
$c_rel_type = $t_filter['relationship_type'];
$c_rel_bug = $t_filter['relationship_bug'];
if ( -1 == $c_rel_type || 0 == $c_rel_bug) {
$t_any_found = true;
}
if ( !$t_any_found ) {
# use the complementary type
$t_comp_type = relationship_get_complementary_type( $c_rel_type );
$t_clauses = array();
$t_table_name = 'relationship';
array_push( $t_from_clauses, $t_bug_relationship_table );
array_push( $t_join_clauses, "LEFT JOIN $t_bug_relationship_table $t_table_name ON $t_table_name.destination_bug_id = $t_bug_table.id" );
array_push( $t_join_clauses, "LEFT JOIN $t_bug_relationship_table ${t_table_name}2 ON ${t_table_name}2.source_bug_id = $t_bug_table.id" );
// get reverse relationships
array_push( $t_clauses, "($t_table_name.relationship_type='$t_comp_type' AND $t_table_name.source_bug_id='$c_rel_bug')" );
array_push( $t_clauses, "($t_table_name"."2.relationship_type='$c_rel_type' AND $t_table_name"."2.destination_bug_id='$c_rel_bug')" );
array_push( $t_where_clauses, '('. implode( ' OR ', $t_clauses ) .')' );
}
# tags
$c_tag_string = trim( $t_filter['tag_string'] );
if ( !is_blank( $c_tag_string ) ) {
$t_tags = tag_parse_filters( $c_tag_string );
if ( count( $t_tags ) ) {
$t_tags_all = array();
$t_tags_any = array();
$t_tags_none = array();
foreach( $t_tags as $t_tag_row ) {
switch ( $t_tag_row['filter'] ) {
case 1:
$t_tags_all[] = $t_tag_row;
break;
case 0:
$t_tags_any[] = $t_tag_row;
break;
case -1:
$t_tags_none[] = $t_tag_row;
break;
}
}
if ( 0 < $t_filter['tag_select'] && tag_exists( $t_filter['tag_select'] ) ) {
$t_tags_any[] = tag_get( $t_filter['tag_select'] );
}
$t_bug_tag_table = config_get( 'mantis_bug_tag_table' );
if ( count( $t_tags_all ) ) {
$t_clauses = array();
foreach ( $t_tags_all as $t_tag_row ) {
array_push( $t_clauses, "$t_bug_table.id IN ( SELECT bug_id FROM $t_bug_tag_table WHERE $t_bug_tag_table.tag_id = $t_tag_row[id] )" );
}
array_push( $t_where_clauses, '('. implode( ' AND ', $t_clauses ) .')' );
}
if ( count( $t_tags_any ) ) {
$t_clauses = array();
foreach ( $t_tags_any as $t_tag_row ) {
array_push( $t_clauses, "$t_bug_tag_table.tag_id = $t_tag_row[id]" );
}
array_push( $t_where_clauses, "$t_bug_table.id IN ( SELECT bug_id FROM $t_bug_tag_table WHERE ( ". implode( ' OR ', $t_clauses ) .') )' );
}
if ( count( $t_tags_none ) ) {
$t_clauses = array();
foreach ( $t_tags_none as $t_tag_row ) {
array_push( $t_clauses, "$t_bug_tag_table.tag_id = $t_tag_row[id]" );
}
array_push( $t_where_clauses, "$t_bug_table.id NOT IN ( SELECT bug_id FROM $t_bug_tag_table WHERE ( ". implode( ' OR ', $t_clauses ) .') )' );
}
}
}
# custom field filters
if( ON == config_get( 'filter_by_custom_fields' ) ) {
# custom field filtering
# @@@ At the moment this gets the linked fields relating to the current project
# It should get the ones relating to the project in the filter or all projects
# if multiple projects.
$t_custom_fields = custom_field_get_linked_ids( $t_project_id );
foreach( $t_custom_fields as $t_cfid ) {
$t_custom_where_clause = '';
# Ignore all custom filters that are not set, or that are set to '' or "any"
$t_any_found = false;
foreach( $t_filter['custom_fields'][$t_cfid] as $t_filter_member ) {
if ( ( META_FILTER_ANY == $t_filter_member ) && ( is_numeric( $t_filter_member ) ) ) {
$t_any_found = true;
}
}
if ( !isset( $t_filter['custom_fields'][$t_cfid] ) ) {
$t_any_found = true;
}
if ( !$t_any_found ) {
$t_def = custom_field_get_definition( $t_cfid );
$t_table_name = $t_custom_field_string_table . '_' . $t_cfid;
# We need to filter each joined table or the result query will explode in dimensions
# Each custom field will result in a exponential growth like Number_of_Issues^Number_of_Custom_Fields
# and only after this process ends (if it is able to) the result query will be filtered
# by the WHERE clause and by the DISTINCT clause
$t_cf_join_clause = "LEFT JOIN $t_custom_field_string_table $t_table_name ON $t_table_name.bug_id = $t_bug_table.id AND $t_table_name.field_id = $t_cfid ";
if ($t_def['type'] == CUSTOM_FIELD_TYPE_DATE) {
switch ($t_filter['custom_fields'][$t_cfid][0]) {
case CUSTOM_FIELD_DATE_ANY:
break ;
case CUSTOM_FIELD_DATE_NONE:
array_push( $t_join_clauses, $t_cf_join_clause );
$t_custom_where_clause = '(( ' . $t_table_name . '.bug_id is null) OR ( ' . $t_table_name . '.value = 0)' ;
break ;
case CUSTOM_FIELD_DATE_BEFORE:
array_push( $t_join_clauses, $t_cf_join_clause );
$t_custom_where_clause = '(( ' . $t_table_name . '.value != 0 AND (' . $t_table_name . '.value+0) < ' . ($t_filter['custom_fields'][$t_cfid][2]) . ')' ;
break ;
case CUSTOM_FIELD_DATE_AFTER:
array_push( $t_join_clauses, $t_cf_join_clause );
$t_custom_where_clause = '( (' . $t_table_name . '.value+0) > ' . ($t_filter['custom_fields'][$t_cfid][1]+1) ;
break ;
default:
array_push( $t_join_clauses, $t_cf_join_clause );
$t_custom_where_clause = '( (' . $t_table_name . '.value+0) BETWEEN ' . $t_filter['custom_fields'][$t_cfid][1] . ' AND ' . $t_filter['custom_fields'][$t_cfid][2];
break ;
}
} else {
array_push( $t_join_clauses, $t_cf_join_clause );
$t_filter_array = array();
foreach( $t_filter['custom_fields'][$t_cfid] as $t_filter_member ) {
$t_filter_member = stripslashes( $t_filter_member );
if ( META_FILTER_NONE == $t_filter_member ) {
# coerce filter value if selecting META_FILTER_NONE so it will match empty fields
$t_filter_member = '';
# but also add those _not_ present in the custom field string table
array_push( $t_filter_array , "$t_bug_table.id NOT IN (SELECT bug_id FROM $t_custom_field_string_table WHERE field_id=$t_cfid)" );
}
switch( $t_def['type'] ) {
case CUSTOM_FIELD_TYPE_MULTILIST:
case CUSTOM_FIELD_TYPE_CHECKBOX:
array_push( $t_filter_array , db_helper_like( "$t_table_name.value", '%|' . db_prepare_string( $t_filter_member ) . '|%' ) );
break;
default:
array_push( $t_filter_array, "$t_table_name.value = '" . db_prepare_string( $t_filter_member ) . "'" );
}
}
$t_custom_where_clause .= '(' . implode( ' OR ', $t_filter_array );
}
if ( !is_blank( $t_custom_where_clause ) ) {
array_push( $t_where_clauses, $t_custom_where_clause . ')' );
}
}
}
}
$t_textsearch_where_clause = '';
$t_textsearch_wherejoin_clause = '';
# Simple Text Search - Thanks to Alan Knowles
if ( !is_blank( $t_filter['search'] ) ) {
$c_search = db_prepare_string( $t_filter['search'] );
$c_search_int = db_prepare_int( $t_filter['search'] );
$t_textsearch_where_clause = '(' . db_helper_like( 'summary', "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.description", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.steps_to_reproduce", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.additional_information", "%$c_search%" ) .
" OR ( $t_bug_table.id = '$c_search_int' ) )";
$t_textsearch_wherejoin_clause = '(' . db_helper_like( 'summary', "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.description", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.steps_to_reproduce", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_text_table.additional_information", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bug_table.id", "%$c_search%" ) .
' OR ' . db_helper_like( "$t_bugnote_text_table.note", "%$c_search%" ) . ' )';
array_push( $t_where_clauses, "($t_bug_text_table.id = $t_bug_table.bug_text_id)" );
$t_from_clauses = array( $t_bug_text_table, $t_project_table, $t_bug_table );
} else {
$t_from_clauses = array( $t_project_table, $t_bug_table );
}
$t_select = implode( ', ', array_unique( $t_select_clauses ) );
$t_from = 'FROM ' . implode( ', ', array_unique( $t_from_clauses ) );
$t_join = implode( ' ', $t_join_clauses );
if ( count( $t_where_clauses ) > 0 ) {
$t_where = 'WHERE ' . implode( ' AND ', $t_where_clauses );
} else {
$t_where = '';
}
# Possibly do two passes. First time, grab the IDs of issues that match the filters. Second time, grab the IDs of issues that
# have bugnotes that match the text search if necessary.
$t_id_array = array();
for ( $i = 0; $i < 2; $i++ ) {
$t_id_where = $t_where;
$t_id_join = $t_join;
if ( $i == 0 ) {
if ( !is_blank( $t_id_where ) && !is_blank( $t_textsearch_where_clause ) ) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_where_clause;
}
} else if ( !is_blank( $t_textsearch_wherejoin_clause ) ) {
$t_id_where = $t_id_where . ' AND ' . $t_textsearch_wherejoin_clause;
$t_id_join = $t_id_join . " INNER JOIN $t_bugnote_table ON $t_bugnote_table.bug_id = $t_bug_table.id";
$t_id_join = $t_id_join . " INNER JOIN $t_bugnote_text_table ON $t_bugnote_text_table.id = $t_bugnote_table.bugnote_text_id";
}
$query = "SELECT DISTINCT $t_bug_table.id AS id
$t_from
$t_id_join
$t_id_where";
if ( ( $i == 0 ) || ( !is_blank( $t_textsearch_wherejoin_clause ) ) ) {
$result = db_query( $query );
$row_count = db_num_rows( $result );
for ( $j=0; $j < $row_count; $j++ ) {
$row = db_fetch_array( $result );
$t_id_array[] = db_prepare_int ( $row['id'] );
}
}
}
$t_id_array = array_unique( $t_id_array );
# Get the total number of bugs that meet the criteria.
$bug_count = count( $t_id_array );
$rows = array();
if ( $bug_count > 0 ) {
$t_where = "WHERE $t_bug_table.id in (" . implode( ", ", $t_id_array ) . ")";
} else {
return $rows;
}
$t_from = 'FROM ' . $t_bug_table;
# write the value back in case the caller wants to know
$p_bug_count = $bug_count;
if ( null === $p_per_page ) {
$p_per_page = (int)$t_filter['per_page'];
} else if ( -1 == $p_per_page ) {
$p_per_page = $bug_count;
}
# Guard against silly values of $f_per_page.
if ( 0 == $p_per_page ) {
$p_per_page = $bug_count; // 0 - means show all
}
$p_per_page = (int)abs( $p_per_page );
# Use $bug_count and $p_per_page to determine how many pages
# to split this list up into.
# For the sake of consistency have at least one page, even if it
# is empty.
$t_page_count = ceil($bug_count / $p_per_page);
if ( $t_page_count < 1 ) {
$t_page_count = 1;
}
# write the value back in case the caller wants to know
$p_page_count = $t_page_count;
# Make sure $p_page_number isn't past the last page.
if ( $p_page_number > $t_page_count ) {
$p_page_number = $t_page_count;
}
# Make sure $p_page_number isn't before the first page
if ( $p_page_number < 1 ) {
$p_page_number = 1;
}
# Now add the rest of the criteria i.e. sorting, limit.
# if sort is blank then default the sort and direction. This is to fix the
# symptoms of #3953. Note that even if the main problem is fixed, we may
# have to keep this code for a while to handle filters saved with this blank field.
if ( is_blank( $t_filter['sort'] ) ) {
$t_filter['sort'] = 'last_updated';
$t_filter['dir'] = 'DESC';
}
$t_order_array = array();
$t_sort_fields = split( ',', $t_filter['sort'] );
$t_dir_fields = split( ',', $t_filter['dir'] );
if ( ( 'on' == $t_filter['sticky_issues'] ) && ( NULL !== $p_show_sticky ) ) {
$t_order_array[] = "sticky DESC";
}
$t_join = '';
for ( $i=0; $i < count( $t_sort_fields ); $i++ ) {
$c_sort = db_prepare_string( $t_sort_fields[$i] );
if ( ! in_array( $t_sort_fields[$i], array_slice( $t_sort_fields, $i + 1) ) ) {
# if sorting by a custom field
if ( strpos( $c_sort, 'custom_' ) === 0 ) {
$t_custom_field = substr( $c_sort, strlen( 'custom_' ) );
$t_custom_field_id = custom_field_get_id_from_name( $t_custom_field );
$t_join .= " LEFT JOIN $t_custom_field_string_table ON ( ( $t_custom_field_string_table.bug_id = $t_bug_table.id ) AND ( $t_custom_field_string_table.field_id = $t_custom_field_id ) )";
$c_sort = "$t_custom_field_string_table.value";
$t_select_clauses[] = "$t_custom_field_string_table.value";
}
if ( 'DESC' == $t_dir_fields[$i] ) {
$c_dir = 'DESC';
} else {
$c_dir = 'ASC';
}
$t_order_array[] = "$c_sort $c_dir";
}
}
# add basic sorting if necessary
if ( ! in_array( 'last_updated', $t_sort_fields ) ) {
$t_order_array[] = 'last_updated DESC';
}
if ( ! in_array( 'date_submitted', $t_sort_fields ) ) {
$t_order_array[] = 'date_submitted DESC';
}
$t_order = " ORDER BY " . implode( ', ', $t_order_array );
$t_select = implode( ', ', array_unique( $t_select_clauses ) );
$query2 = "SELECT DISTINCT $t_select
$t_from
$t_join
$t_where
$t_order";
# Figure out the offset into the db query
#
# for example page number 1, per page 5:
# t_offset = 0
# for example page number 2, per page 5:
# t_offset = 5
$c_per_page = db_prepare_int( $p_per_page );
$c_page_number = db_prepare_int( $p_page_number );
$t_offset = ( ( $c_page_number - 1 ) * $c_per_page );
# perform query
$result2 = db_query( $query2, $c_per_page, $t_offset );
$row_count = db_num_rows( $result2 );
$t_id_array_lastmod = array();
for ( $i=0 ; $i < $row_count ; $i++ ) {
$row = db_fetch_array( $result2 );
$t_id_array_lastmod[] = db_prepare_int ( $row['id'] );
$row['date_submitted'] = db_unixtimestamp ( $row['date_submitted'] );
$row['last_updated'] = db_unixtimestamp ( $row['last_updated'] );
array_push( $rows, $row );
}
$t_id_array_lastmod = array_unique( $t_id_array_lastmod );
// paulr: it should be impossible for t_id_array_lastmod to be array():
// that would imply that $t_id_array is null which aborts this function early
//if ( count( $t_id_array_lastmod ) > 0 ) {
$t_where = "WHERE $t_bugnote_table.bug_id in (" . implode( ", ", $t_id_array_lastmod ) . ")";
$query3 = "SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM $t_bugnote_table $t_where GROUP BY bug_id";
# perform query
$result3 = db_query( $query3 );
$row_count = db_num_rows( $result3 );
for ( $i=0 ; $i < $row_count ; $i++ ) {
$row = db_fetch_array( $result3 );
$t_stats[ $row['bug_id'] ] = $row;
}
foreach($rows as $row) {
if( !isset( $t_stats[ $row['id'] ] ) ) {
bug_cache_database_result( $row, false );
} else {
bug_cache_database_result( $row, $t_stats[ $row['id'] ] );
}
}
return $rows;
}
# --------------------
# return true if the filter cookie exists and is of the correct version,
# false otherwise
function filter_is_cookie_valid() {
$t_view_all_cookie_id = gpc_get_cookie( config_get( 'view_all_cookie' ), '' );
$t_view_all_cookie = filter_db_get_filter( $t_view_all_cookie_id );
# check to see if the cookie does not exist
if ( is_blank( $t_view_all_cookie ) ) {
return false;
}
# check to see if new cookie is needed
$t_setting_arr = explode( '#', $t_view_all_cookie, 2 );
if ( ( $t_setting_arr[0] == 'v1' ) ||
( $t_setting_arr[0] == 'v2' ) ||
( $t_setting_arr[0] == 'v3' ) ||
( $t_setting_arr[0] == 'v4' ) ) {
return false;
}
# We shouldn't need to do this anymore, as filters from v5 onwards should cope with changing
# filter indices dynamically
$t_filter_cookie_arr = array();
if ( isset( $t_setting_arr[1] ) ) {
$t_filter_cookie_arr = unserialize( $t_setting_arr[1] );
} else {
return false;
}
if ( $t_filter_cookie_arr['_version'] != config_get( 'cookie_version' ) ) {
return false;
}
return true;
}
# --------------------
# return filter array if supplied serialized filter is valid, otherwise false.otherwise
function filter_deserialize( $p_serialized_filter ) {
if ( is_blank( $p_serialized_filter ) ) {
return false;
}
# check to see if new cookie is needed
$t_setting_arr = explode( '#', $p_serialized_filter, 2 );
if ( ( $t_setting_arr[0] == 'v1' ) ||
( $t_setting_arr[0] == 'v2' ) ||
( $t_setting_arr[0] == 'v3' ) ||
( $t_setting_arr[0] == 'v4' ) ) {
# these versions can't be salvaged, they are too old to update
return false;
}
# We shouldn't need to do this anymore, as filters from v5 onwards should cope with changing
# filter indices dynamically
$t_filter_array = array();
if ( isset( $t_setting_arr[1] ) ) {
$t_filter_array = unserialize( $t_setting_arr[1] );
} else {
return false;
}
if ( $t_filter_array['_version'] != config_get( 'cookie_version' ) ) {
# if the version is not new enough, update it using defaults
return filter_ensure_valid_filter( $t_filter_array );
}
return $t_filter_array;
}
# --------------------
# Mainly based on filter_draw_selection_area2() but adds the support for the collapsible
# filter display.
function filter_draw_selection_area( $p_page_number, $p_for_screen = true )
{
collapse_open( 'filter' );
filter_draw_selection_area2( $p_page_number, $p_for_screen, true );
collapse_closed( 'filter' );
filter_draw_selection_area2( $p_page_number, $p_for_screen, false );
collapse_end( 'filter' );
}
# --------------------
# Will print the filter selection area for both the bug list view screen, as well
# as the bug list print screen. This function was an attempt to make it easier to
# add new filters and rearrange them on screen for both pages.
function filter_draw_selection_area2( $p_page_number, $p_for_screen = true, $p_expanded = true )
{
$t_form_name_suffix = $p_expanded ? '_open' : '_closed';
$t_filter = current_user_get_bug_filter();
$t_filter = filter_ensure_valid_filter( $t_filter );
$t_project_id = helper_get_current_project();
$t_page_number = (int) $p_page_number;
$t_view_type = $t_filter['_view_type'];
$t_tdclass = 'small-caption';
$t_trclass = 'row-category2';
$t_action = 'view_all_set.php?f=3';
if ( $p_for_screen == false ) {
$t_tdclass = 'print';
$t_trclass = '';
$t_action = 'view_all_set.php';
}
?>
<br />
<form method="post" name="filters<?php echo $t_form_name_suffix ?>" id="filters_form<?php echo $t_form_name_suffix ?>" action="<?php PRINT $t_action; ?>">
<input type="hidden" name="type" value="1" />
<?php
if ( $p_for_screen == false ) {
PRINT '<input type="hidden" name="print" value="1" />';
PRINT '<input type="hidden" name="offset" value="0" />';
}
?>
<input type="hidden" name="page_number" value="<?php PRINT $t_page_number ?>" />
<input type="hidden" name="view_type" value="<?php PRINT $t_view_type ?>" />
<table class="width100" cellspacing="1">
<?php
$t_filter_cols = config_get( 'filter_custom_fields_per_row' );
if ( $p_expanded ) {
$t_custom_cols = $t_filter_cols;
$t_current_user_access_level = current_user_get_access_level();
$t_accessible_custom_fields_ids = array();
$t_accessible_custom_fields_names = array();
$t_accessible_custom_fields_values = array();
$t_num_custom_rows = 0;
$t_per_row = 0;
if ( ON == config_get( 'filter_by_custom_fields' ) ) {
$t_custom_fields = custom_field_get_linked_ids( $t_project_id );
foreach ( $t_custom_fields as $t_cfid ) {
$t_field_info = custom_field_cache_row( $t_cfid, true );
if ( $t_field_info['access_level_r'] <= $t_current_user_access_level ) {
$t_accessible_custom_fields_ids[] = $t_cfid;
$t_accessible_custom_fields_names[] = $t_field_info['name'];
$t_accessible_custom_fields_types[] = $t_field_info['type'];
$t_accessible_custom_fields_values[] = custom_field_distinct_values( $t_cfid );
}
}
if ( count( $t_accessible_custom_fields_ids ) > 0 ) {
$t_per_row = config_get( 'filter_custom_fields_per_row' );
$t_num_custom_rows = ceil( count( $t_accessible_custom_fields_ids ) / $t_per_row );
}
}
$t_filters_url = 'view_filters_page.php?for_screen=' . $p_for_screen;
if ( 'advanced' == $t_view_type ) {
$t_filters_url = $t_filters_url . '&view_type=advanced';
}
$t_filters_url = $t_filters_url . '&target_field=';
$t_show_version = ( ON == config_get( 'show_product_version' ) )
|| ( ( AUTO == config_get( 'show_product_version' ) )
&& ( count( version_get_all_rows_with_subs( $t_project_id ) ) > 0 ) );
# overload handler_id setting if user isn't supposed to see them (ref #6189)
if ( ! access_has_project_level( config_get( 'view_handler_threshold' ), $t_project_id ) ) {
$t_filter['handler_id'] = array( META_FILTER_ANY );
}
?>
<tr <?php PRINT "class=\"" . $t_trclass . "\""; ?>>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'reporter_id[]'; ?>" id="reporter_id_filter"><?php PRINT lang_get( 'reporter' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'user_monitor[]'; ?>" id="user_monitor_filter"><?php PRINT lang_get( 'monitored_by' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'handler_id[]'; ?>" id="handler_id_filter"><?php PRINT lang_get( 'assigned_to' ) ?>:</a>
</td>
<td colspan="2" class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_category[]'; ?>" id="show_category_filter"><?php PRINT lang_get( 'category' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_severity[]'; ?>" id="show_severity_filter"><?php PRINT lang_get( 'severity' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_resolution[]'; ?>" id="show_resolution_filter"><?php PRINT lang_get( 'resolution' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_profile[]'; ?>" id="show_profile_filter"><?php PRINT lang_get( 'profile' ) ?>:</a>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 8 ) . '"> </td>';
} ?>
</tr>
<tr class="row-1">
<td class="small-caption" valign="top" id="reporter_id_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['reporter_id'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['reporter_id'] as $t_current ) {
$t_this_name = '';
?>
<input type="hidden" name="reporter_id[]" value="<?php echo $t_current;?>" />
<?php
if ( ( $t_current === 0 ) || ( is_blank( $t_current ) ) || ( META_FILTER_ANY == $t_current ) ) {
$t_any_found = true;
} else if ( META_FILTER_MYSELF == $t_current ) {
if ( access_has_project_level( config_get( 'report_bug_threshold' ) ) ) {
$t_this_name = '[' . lang_get( 'myself' ) . ']';
} else {
$t_any_found = true;
}
} else if ( META_FILTER_NONE == $t_current ) {
$t_this_name = lang_get( 'none' );
} else {
$t_this_name = user_get_name( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_name;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="user_monitor_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['user_monitor'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['user_monitor'] as $t_current ) {
?>
<input type="hidden" name="user_monitor[]" value="<?php echo $t_current;?>" />
<?php
$t_this_name = '';
if ( ( $t_current === 0 ) || ( is_blank( $t_current ) ) || ( META_FILTER_ANY == $t_current ) ) {
$t_any_found = true;
} else if ( META_FILTER_MYSELF == $t_current ) {
if ( access_has_project_level( config_get( 'monitor_bug_threshold' ) ) ) {
$t_this_name = '[' . lang_get( 'myself' ) . ']';
} else {
$t_any_found = true;
}
} else {
$t_this_name = user_get_name( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_name;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="handler_id_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['handler_id'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['handler_id'] as $t_current ) {
?>
<input type="hidden" name="handler_id[]" value="<?php echo $t_current;?>" />
<?php
$t_this_name = '';
if ( META_FILTER_NONE == $t_current ) {
$t_this_name = lang_get( 'none' );
} else if ( ( $t_current === 0 ) || ( is_blank( $t_current ) ) || ( META_FILTER_ANY == $t_current ) ) {
$t_any_found = true;
} else if ( META_FILTER_MYSELF == $t_current ) {
if ( access_has_project_level( config_get( 'handle_bug_threshold' ) ) ) {
$t_this_name = '[' . lang_get( 'myself' ) . ']';
} else {
$t_any_found = true;
}
} else {
$t_this_name = user_get_name( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_name;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td colspan="2" class="small-caption" valign="top" id="show_category_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_category'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_category'] as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="show_category[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="show_severity_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_severity'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_severity'] as $t_current ) {
?>
<input type="hidden" name="show_severity[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current === META_FILTER_ANY ) || ( is_blank( $t_current ) ) || ( $t_current == 0 ) ) {
$t_any_found = true;
} else {
$t_this_string = get_enum_element( 'severity', $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="show_resolution_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_resolution'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_resolution'] as $t_current ) {
?>
<input type="hidden" name="show_resolution[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current === META_FILTER_ANY ) || ( is_blank( $t_current ) ) || ( $t_current === 0 ) ) {
$t_any_found = true;
} else {
$t_this_string = get_enum_element( 'resolution', $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="show_profile_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_profile'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_profile'] as $t_current ) {
?>
<input type="hidden" name="show_profile[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current === META_FILTER_ANY ) || ( is_blank( $t_current ) ) || ( $t_current === 0 ) ) {
$t_any_found = true;
} else {
$t_profile = profile_get_row_direct( $t_current );
$t_this_string = "${t_profile['platform']} ${t_profile['os']} ${t_profile['os_build']}";
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 8 ) . '"> </td>';
} ?>
</tr>
<tr <?php PRINT "class=\"" . $t_trclass . "\""; ?>>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_status[]'; ?>" id="show_status_filter"><?php PRINT lang_get( 'status' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<?php if ( 'simple' == $t_view_type ) { ?>
<a href="<?php PRINT $t_filters_url . 'hide_status[]'; ?>" id="hide_status_filter"><?php PRINT lang_get( 'hide_status' ) ?>:</a>
<?php } ?>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_build[]'; ?>" id="show_build_filter"><?php PRINT lang_get( 'product_build' ) ?>:</a>
</td>
<?php if ( $t_show_version ) { ?>
<td colspan="2" class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_version[]'; ?>" id="show_version_filter"><?php PRINT lang_get( 'product_version' ) ?>:</a>
</td>
<td colspan="1" class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'fixed_in_version[]'; ?>" id="show_fixed_in_version_filter"><?php PRINT lang_get( 'fixed_in_version' ) ?>:</a>
</td>
<?php } else { ?>
<td colspan="2" class="small-caption" valign="top">
</td>
<td colspan="1" class="small-caption" valign="top">
</td>
<?php } ?>
<td colspan="1" class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_priority[]'; ?>" id="show_priority_filter"><?php PRINT lang_get( 'priority' ) ?>:</a>
</td>
<td colspan="1" class="small-caption" valign="top">
<a href="<?php echo $t_filters_url . 'target_version[]'; ?>" id="show_target_version_filter"><?php echo lang_get( 'target_version' ) ?>:</a>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 7 ) . '"> </td>';
} ?>
</tr>
<tr class="row-1">
<td class="small-caption" valign="top" id="show_status_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_status'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_status'] as $t_current ) {
?>
<input type="hidden" name="show_status[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current === META_FILTER_ANY ) || ( is_blank( $t_current ) ) || ( $t_current === 0 ) ) {
$t_any_found = true;
} else {
$t_this_string = get_enum_element( 'status', $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td class="small-caption" valign="top" id="hide_status_filter_target">
<?php
if ( 'simple' == $t_view_type ) {
$t_output = '';
$t_none_found = false;
if ( count( $t_filter['hide_status'] ) == 0 ) {
PRINT lang_get( 'none' );
} else {
$t_first_flag = true;
foreach( $t_filter['hide_status'] as $t_current ) {
?>
<input type="hidden" name="hide_status[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current == META_FILTER_NONE ) || ( is_blank( $t_current ) ) || ( $t_current === 0 ) ) {
$t_none_found = true;
} else {
$t_this_string = get_enum_element( 'status', $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
$t_hide_status_post = '';
if ( count( $t_filter['hide_status'] ) == 1 ) {
$t_hide_status_post = ' (' . lang_get( 'and_above' ) . ')';
}
if ( true == $t_none_found ) {
PRINT lang_get( 'none' );
} else {
PRINT $t_output . $t_hide_status_post;
}
}
}
?>
</td>
<td class="small-caption" valign="top" id="show_build_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_build'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_build'] as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="show_build[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else if ( META_FILTER_NONE == $t_current ) {
$t_this_string = lang_get( 'none' );
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<?php if ( $t_show_version ) { ?>
<td colspan="2" class="small-caption" valign="top" id="show_version_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_version'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_version'] as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="show_version[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && (is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else if ( META_FILTER_NONE == $t_current ) {
$t_this_string = lang_get( 'none' );
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td colspan="1" class="small-caption" valign="top" id="show_fixed_in_version_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['fixed_in_version'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['fixed_in_version'] as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="fixed_in_version[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else if ( META_FILTER_NONE == $t_current ) {
$t_this_string = lang_get( 'none' );
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<?php } else { ?>
<td colspan="2" class="small-caption" valign="top">
</td>
<td colspan="1" class="small-caption" valign="top">
</td>
<?php } ?>
<td colspan="1" class="small-caption" valign="top" id="show_priority_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['show_priority'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['show_priority'] as $t_current ) {
?>
<input type="hidden" name="show_priority[]" value="<?php echo $t_current;?>" />
<?php
$t_this_string = '';
if ( ( $t_current === META_FILTER_ANY ) || ( is_blank( $t_current ) ) || ( $t_current === 0 ) ) {
$t_any_found = true;
} else {
$t_this_string = get_enum_element( 'priority', $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<td colspan="1" class="small-caption" valign="top" id="show_target_version_filter_target">
<?php
$t_output = '';
$t_any_found = false;
if ( count( $t_filter['target_version'] ) == 0 ) {
PRINT lang_get( 'any' );
} else {
$t_first_flag = true;
foreach( $t_filter['target_version'] as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="target_version[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else if ( META_FILTER_NONE == $t_current ) {
$t_this_string = lang_get( 'none' );
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
}
if ( true == $t_any_found ) {
PRINT lang_get( 'any' );
} else {
PRINT $t_output;
}
}
?>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 7 ) . '"> </td>';
} ?>
</tr>
<tr <?php PRINT "class=\"" . $t_trclass . "\""; ?>>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'per_page'; ?>" id="per_page_filter"><?php PRINT lang_get( 'show' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'view_state'; ?>" id="view_state_filter"><?php PRINT lang_get( 'view_status' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'sticky_issues'; ?>" id="sticky_issues_filter"><?php PRINT lang_get( 'sticky' ) ?>:</a>
</td>
<td class="small-caption" valign="top" colspan="2">
<a href="<?php PRINT $t_filters_url . 'highlight_changed'; ?>" id="highlight_changed_filter"><?php PRINT lang_get( 'changed' ) ?>:</a>
</td>
<td class="small-caption" valign="top" >
<a href="<?php PRINT $t_filters_url . 'do_filter_by_date'; ?>" id="do_filter_by_date_filter"><?php PRINT lang_get( 'use_date_filters' ) ?>:</a>
</td>
<td class="small-caption" valign="top" colspan="2">
<a href="<?php PRINT $t_filters_url . 'relationship_type'; ?>" id="relationship_type_filter"><?php PRINT lang_get( 'bug_relationships' ) ?>:</a>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 8 ) . '"> </td>';
} ?>
</tr>
<tr class="row-1">
<td class="small-caption" valign="top" id="per_page_filter_target">
<?php echo ( $t_filter['per_page'] == 0 ) ? lang_get( 'all' ) : $t_filter['per_page']; ?>
<input type="hidden" name="per_page" value="<?php echo $t_filter['per_page'];?>" />
</td>
<td class="small-caption" valign="top" id="view_state_filter_target">
<?php
if ( VS_PUBLIC === $t_filter['view_state'] ) {
PRINT lang_get( 'public' );
} else if ( VS_PRIVATE === $t_filter['view_state'] ) {
PRINT lang_get( 'private' );
} else {
PRINT lang_get( 'any' );
$t_filter['view_state'] = META_FILTER_ANY;
}
?>
<input type="hidden" name="view_state" value="<?php echo $t_filter['view_state'];?>" />
</td>
<td class="small-caption" valign="top" id="sticky_issues_filter_target">
<?php
$t_sticky_filter_state = gpc_string_to_bool( $t_filter['sticky_issues'] ) ;
PRINT ( $t_sticky_filter_state ? lang_get( 'yes' ) : lang_get( 'no' ) );
?>
<input type="hidden" name="sticky_issues" value="<?php echo $t_sticky_filter_state ? 'on' : 'off';?>" />
</td>
<td class="small-caption" valign="top" colspan="2" id="highlight_changed_filter_target">
<?php PRINT $t_filter['highlight_changed']; ?>
<input type="hidden" name="highlight_changed" value="<?php echo $t_filter['highlight_changed'];?>" />
</td>
<td class="small-caption" valign="top" id="do_filter_by_date_filter_target">
<?php
if ( ( ON == config_get( 'dhtml_filters' ) ) && ( ON == config_get( 'use_javascript' ) ) ){
?>
<script type="text/javascript" language="JavaScript">
<!--
function SwitchDateFields() {
// All fields need to be enabled to go back to the script
document.filters_open.start_month.disabled = ! document.filters_open.do_filter_by_date.checked;
document.filters_open.start_day.disabled = ! document.filters_open.do_filter_by_date.checked;
document.filters_open.start_year.disabled = ! document.filters_open.do_filter_by_date.checked;
document.filters_open.end_month.disabled = ! document.filters_open.do_filter_by_date.checked;
document.filters_open.end_day.disabled = ! document.filters_open.do_filter_by_date.checked;
document.filters_open.end_year.disabled = ! document.filters_open.do_filter_by_date.checked;
return true;
}
// -->
</script>
<?php
} # end if dhtml_filters
if ( 'on' == $t_filter['do_filter_by_date'] ) {
?>
<input type="hidden" name="do_filter_by_date" value="<?php echo $t_filter['do_filter_by_date'];?>" />
<input type="hidden" name="start_month" value="<?php echo $t_filter['start_month'];?>" />
<input type="hidden" name="start_day" value="<?php echo $t_filter['start_day'];?>" />
<input type="hidden" name="start_year" value="<?php echo $t_filter['start_year'];?>" />
<input type="hidden" name="end_month" value="<?php echo $t_filter['end_month'];?>" />
<input type="hidden" name="end_day" value="<?php echo $t_filter['end_day'];?>" />
<input type="hidden" name="end_year" value="<?php echo $t_filter['end_year'];?>" />
<?php
$t_chars = preg_split( '//', config_get( 'short_date_format' ), -1, PREG_SPLIT_NO_EMPTY );
$t_time = mktime( 0, 0, 0, $t_filter['start_month'], $t_filter['start_day'], $t_filter['start_year'] );
foreach( $t_chars as $t_char ) {
if ( strcasecmp( $t_char, "M" ) == 0 ) {
PRINT ' ';
PRINT date( 'F', $t_time );
}
if ( strcasecmp( $t_char, "D" ) == 0 ) {
PRINT ' ';
PRINT date( 'd', $t_time );
}
if ( strcasecmp( $t_char, "Y" ) == 0 ) {
PRINT ' ';
PRINT date( 'Y', $t_time );
}
}
PRINT ' - ';
$t_time = mktime( 0, 0, 0, $t_filter['end_month'], $t_filter['end_day'], $t_filter['end_year'] );
foreach( $t_chars as $t_char ) {
if ( strcasecmp( $t_char, "M" ) == 0 ) {
PRINT ' ';
PRINT date( 'F', $t_time );
}
if ( strcasecmp( $t_char, "D" ) == 0 ) {
PRINT ' ';
PRINT date( 'd', $t_time );
}
if ( strcasecmp( $t_char, "Y" ) == 0 ) {
PRINT ' ';
PRINT date( 'Y', $t_time );
}
}
} else {
PRINT lang_get( 'no' );
}
?>
</td>
<td class="small-caption" valign="top" colspan="2" id="relationship_type_filter_target">
<input type="hidden" name="relationship_type" value="<?php echo $t_filter['relationship_type'];?>" />
<input type="hidden" name="relationship_bug" value="<?php echo $t_filter['relationship_bug'];?>" />
<?php
$c_rel_type = $t_filter['relationship_type'];
$c_rel_bug = $t_filter['relationship_bug'];
if ( -1 == $c_rel_type || 0 == $c_rel_bug ) {
PRINT lang_get( 'any' );
} else {
PRINT relationship_get_description_for_history ($c_rel_type) . ' ' . $c_rel_bug;
}
?>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 8 ) . '"> </td>';
} ?>
</tr>
<tr <?php PRINT "class=\"" . $t_trclass . "\""; ?>>
<td class="small-caption" valign="top">
<a href="<?php echo $t_filters_url . 'platform'; ?>" id="platform_filter"><?php echo lang_get( 'platform' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'os'; ?>" id="os_filter"><?php echo lang_get( 'os' ) ?>:</a>
</td>
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'os_build'; ?>" id="os_build_filter"><?php echo lang_get( 'os_version' ) ?>:</a>
</td>
<td class="small-caption" valign="top" colspan="5">
<a href="<?php PRINT $t_filters_url . 'tag_string'; ?>" id="tag_string_filter"><?php echo lang_get( 'tags' ) ?>:</a>
</td>
<?php if ( $t_filter_cols > 8 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 8 ) . '"> </td>';
} ?>
</tr>
<tr class="row-1">
<td class="small-caption" valign="top" id="platform_filter_target">
<?php
print_multivalue_field( FILTER_PROPERTY_PLATFORM, $t_filter[FILTER_PROPERTY_PLATFORM] );
?>
</td>
<td class="small-caption" valign="top" id="os_filter_target">
<?php
print_multivalue_field( FILTER_PROPERTY_OS, $t_filter[FILTER_PROPERTY_OS] );
?>
</td>
<td class="small-caption" valign="top" id="os_build_filter_target">
<?php
print_multivalue_field( FILTER_PROPERTY_OS_BUILD, $t_filter[FILTER_PROPERTY_OS_BUILD] );
?>
</td>
<td class="small-caption" valign="top" id="tag_string_filter_target" colspan="5">
<?php
$t_tag_string = $t_filter['tag_string'];
if ( $t_filter['tag_select'] != 0 ) {
$t_tag_string .= ( is_blank( $t_tag_string ) ? '' : config_get( 'tag_separator' ) );
$t_tag_string .= tag_get_field( $t_filter['tag_select'], 'name' );
}
PRINT $t_tag_string
?>
<input type="hidden" name="tag_string" value="<?php echo $t_tag_string ?>"/>
</td>
</tr>
<?php
if ( ON == config_get( 'filter_by_custom_fields' ) ) {
# -- Custom Field Searching --
if ( count( $t_accessible_custom_fields_ids ) > 0 ) {
$t_per_row = config_get( 'filter_custom_fields_per_row' );
$t_num_fields = count( $t_accessible_custom_fields_ids ) ;
$t_row_idx = 0;
$t_col_idx = 0;
$t_fields = "";
$t_values = "";
for ( $i = 0; $i < $t_num_fields; $i++ ) {
if ( $t_col_idx == 0 ) {
$t_fields = '<tr class="' . $t_trclass . '">';
$t_values = '<tr class="row-1">';
}
if ( isset( $t_accessible_custom_fields_names[ $i ] ) ) {
$t_fields .= '<td class="small-caption" valign="top"> ';
$t_fields .= '<a href="' . $t_filters_url . 'custom_field_' . $t_accessible_custom_fields_ids[$i] . '[]" id="custom_field_'. $t_accessible_custom_fields_ids[$i] .'_filter">';
$t_fields .= string_display( lang_get_defaulted( $t_accessible_custom_fields_names[$i] ) );
$t_fields .= '</a> </td> ';
}
$t_output = '';
$t_any_found = false;
$t_values .= '<td class="small-caption" valign="top" id="custom_field_' . $t_accessible_custom_fields_ids[$i] . '_filter_target"> ' ;
if ( !isset( $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]] ) ) {
$t_values .= lang_get( 'any' );
} else {
if ( $t_accessible_custom_fields_types[$i] == CUSTOM_FIELD_TYPE_DATE ) {
# @@@ moved embedded javascript here from print_filter_custom_field_date
# it appears not to load properly on Firefox and other browsers if loaded through the httpxmlreq
$t_field_id = $t_accessible_custom_fields_ids[$i];
$t_js_toggle_func = "toggle_custom_date_field_" . $t_field_id . "_controls" ;
if ( ( ON == config_get( 'dhtml_filters' ) ) && ( ON == config_get( 'use_javascript' ) ) ) {
?>
<script type="text/javascript" language="JavaScript">
<!--
function <?php echo $t_js_toggle_func . "_start" ; ?>(disable) {
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_start_year.disabled = disable ;
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_start_month.disabled = disable ;
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_start_day.disabled = disable ;
} ;
function <?php echo $t_js_toggle_func . "_end" ; ?>(disable) {
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_end_year.disabled = disable ;
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_end_month.disabled = disable ;
document.filters_open.custom_field_<?php echo $t_field_id ; ?>_end_day.disabled = disable ;
} ;
function <?php echo $t_js_toggle_func ; ?>() {
switch (document.filters_open.custom_field_<?php echo $t_field_id ; ?>_control.selectedIndex) {
case <?php echo CUSTOM_FIELD_DATE_ANY ; ?>:
case <?php echo CUSTOM_FIELD_DATE_NONE ; ?>:
<?php echo $t_js_toggle_func . "_start" ; ?>(true) ;
<?php echo $t_js_toggle_func . "_end" ; ?>(true) ;
break ;
case <?php echo CUSTOM_FIELD_DATE_BETWEEN ; ?>:
<?php echo $t_js_toggle_func . "_start" ; ?>(false) ;
<?php echo $t_js_toggle_func . "_end" ; ?>(false) ;
break ;
default:
<?php echo $t_js_toggle_func . "_start" ; ?>(false) ;
<?php echo $t_js_toggle_func . "_end" ; ?>(true) ;
break ;
}
}
// -->
</script>
<?php
} # end if dhtml_filters
$t_short_date_format = config_get( 'short_date_format' );
if ( !isset( $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][1] ) ) {
$t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][1] = 0;
}
$t_start = date( $t_short_date_format, $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][1] );
if ( !isset( $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][2] ) ) {
$t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][2] = 0;
}
$t_end = date( $t_short_date_format, $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][2] );
switch ($t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]][0]) {
case CUSTOM_FIELD_DATE_ANY:
$t_values .= lang_get( 'any' ) ;
break;
case CUSTOM_FIELD_DATE_NONE:
$t_values .= lang_get( 'none' ) ;
break;
case CUSTOM_FIELD_DATE_BETWEEN:
$t_values .= lang_get( 'between' ) . '<br />';
$t_values .= $t_start . '<br />' . $t_end;
break;
case CUSTOM_FIELD_DATE_ONORBEFORE:
$t_values .= lang_get( 'on_or_before' ) . '<br />';
$t_values .= $t_end;
break;
case CUSTOM_FIELD_DATE_BEFORE:
$t_values .= lang_get( 'before' ) . '<br />';
$t_values .= $t_end;
break;
case CUSTOM_FIELD_DATE_ON:
$t_values .= lang_get( 'on' ) . '<br />';
$t_values .= $t_start;
break;
case CUSTOM_FIELD_DATE_AFTER:
$t_values .= lang_get( 'after' ) . '<br />';
$t_values .= $t_start;
break ;
case CUSTOM_FIELD_DATE_ONORAFTER:
$t_values .= lang_get( 'on_or_after' ) . '<br />';
$t_values .= $t_start;
break ;
}
} else {
$t_first_flag = true;
foreach( $t_filter['custom_fields'][$t_accessible_custom_fields_ids[$i]] as $t_current ) {
$t_current = stripslashes( $t_current );
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else if ( ( META_FILTER_NONE == $t_current ) && ( is_numeric( $t_current ) ) ) {
$t_this_string = lang_get( 'none' );
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_string;
$t_values .= '<input type="hidden" name="custom_field_'.$t_accessible_custom_fields_ids[$i].'[]" value="'.string_display( $t_current ).'" />';
}
}
if ( true == $t_any_found ) {
$t_values .= lang_get( 'any' );
} else {
$t_values .= $t_output;
}
}
$t_values .= ' </td>';
$t_col_idx++;
if ( $t_col_idx == $t_per_row ) {
if ( $t_filter_cols > $t_per_row ) {
$t_fields .= '<td colspan="' . ($t_filter_cols - $t_per_row ) . '"> </td> ';
$t_values .= '<td colspan="' . ($t_filter_cols - $t_per_row) . '"> </td> ';
}
$t_fields .= '</tr>' . "\n";
$t_values .= '</tr>' . "\n";
echo $t_fields;
echo $t_values;
$t_col_idx = 0;
$t_row_idx++;
}
}
if ( $t_col_idx > 0 ) {
if ( $t_col_idx < $t_per_row ) {
$t_fields .= '<td colspan="' . ($t_per_row - $t_col_idx) . '"> </td> ';
$t_values .= '<td colspan="' . ($t_per_row - $t_col_idx) . '"> </td> ';
}
if ( $t_filter_cols > $t_per_row ) {
$t_fields .= '<td colspan="' . ($t_filter_cols - $t_per_row ) . '"> </td> ';
$t_values .= '<td colspan="' . ($t_filter_cols - $t_per_row) . '"> </td> ';
}
$t_fields .= '</tr>' . "\n";
$t_values .= '</tr>' . "\n";
echo $t_fields;
echo $t_values;
}
}
}
?>
<tr class="row-1">
<td class="small-caption" valign="top">
<a href="<?php PRINT $t_filters_url . 'show_sort'; ?>" id="show_sort_filter"><?php PRINT lang_get( 'sort' ) ?>:</a>
</td>
<td class="small-caption" valign="top" colspan="2" id="show_sort_filter_target">
<?php
$t_sort_fields = split( ',', $t_filter['sort'] );
$t_dir_fields = split( ',', $t_filter['dir'] );
for ( $i=0; $i<2; $i++ ) {
if ( isset( $t_sort_fields[$i] ) ) {
if ( 0 < $i ) {
echo ", ";
}
$t_sort = $t_sort_fields[$i];
if ( strpos( $t_sort, 'custom_' ) === 0 ) {
$t_field_name = string_display( lang_get_defaulted( substr( $t_sort, strlen( 'custom_' ) ) ) );
} else {
$t_field_name = string_get_field_name( $t_sort );
}
echo $t_field_name . " " . lang_get( 'bugnote_order_' . strtolower( $t_dir_fields[$i] ) );
echo "<input type=\"hidden\" name=\"sort_$i\" value=\"$t_sort_fields[$i]\" />";
echo "<input type=\"hidden\" name=\"dir_$i\" value=\"$t_dir_fields[$i]\" />";
}
}
?>
</td>
<?php
if ( 'advanced' == $t_view_type ) {
?>
<td class="small-caption" valign="top" colspan="2">
<a href="<?php PRINT $t_filters_url . 'project_id'; ?>" id="project_id_filter"><?php PRINT lang_get( 'email_project' ) ?>:</a>
</td>
<td class="small-caption" valign="top" id="project_id_filter_target">
<?php
$t_output = '';
if ( !is_array( $t_filter['project_id'] ) ) {
$t_filter['project_id'] = Array( $t_filter['project_id'] );
}
if ( count( $t_filter['project_id'] ) == 0 ) {
PRINT lang_get( 'current' );
} else {
$t_first_flag = true;
foreach( $t_filter['project_id'] as $t_current ) {
?>
<input type="hidden" name="project_id[]" value="<?php echo $t_current;?>" />
<?php
$t_this_name = '';
if ( META_FILTER_CURRENT == $t_current ) {
$t_this_name = lang_get( 'current' );
} else {
$t_this_name = project_get_name( $t_current );
}
if ( $t_first_flag != true ) {
$t_output = $t_output . '<br />';
} else {
$t_first_flag = false;
}
$t_output = $t_output . $t_this_name;
}
PRINT $t_output;
}
?>
</td>
<?php
if ( $t_filter_cols > 6 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 5 ) . '"> </td>';
}
} else {
if ( $t_filter_cols > 3 ) {
echo '<td class="small-caption" valign="top" colspan="' . ( $t_filter_cols - 2 ) . '"> </td>';
}
}
?>
</tr>
<?php
} // expanded
?>
<tr>
<td colspan="2">
<?php
collapse_icon( 'filter' );
echo lang_get( 'search' );
?>:
<input type="text" size="16" name="search" value="<?php PRINT string_html_specialchars( $t_filter['search'] ); ?>" />
<input type="submit" name="filter" class="button-small" value="<?php PRINT lang_get( 'filter_button' ) ?>" />
</td>
</form>
<td class="center" colspan="<?php echo ( $t_filter_cols - 6 ) ?>"> <!-- use this label for padding -->
<?php
if ( ON == config_get( 'dhtml_filters' ) ) {
$f_switch_view_link = 'view_all_set.php?type=6&view_type=';
} else {
$f_switch_view_link = 'view_filters_page.php?view_type=';
}
if ( ( SIMPLE_ONLY != config_get( 'view_filters' ) ) && ( ADVANCED_ONLY != config_get( 'view_filters' ) ) ) {
if ( 'advanced' == $t_view_type ) {
print_bracket_link( $f_switch_view_link . 'simple', lang_get( 'simple_filters' ) );
} else {
print_bracket_link( $f_switch_view_link . 'advanced', lang_get( 'advanced_filters' ) );
}
print_bracket_link(
'permalink_page.php?url=' . urlencode( filter_get_url( $t_filter ) ),
lang_get( 'create_filter_link' ),
/* new window = */ true );
}
?>
</td>
<td class="right" colspan="4">
<?php
$t_stored_queries_arr = array();
$t_stored_queries_arr = filter_db_get_available_queries();
if ( count( $t_stored_queries_arr ) > 0 ) {
?>
<form method="get" name="list_queries<?php echo $t_form_name_suffix; ?>" action="view_all_set.php">
<input type="hidden" name="type" value="3" />
<?php
if ( ON == config_get( 'use_javascript' ) ) {
echo "<select name=\"source_query_id\" onchange=\"document.forms.list_queries$t_form_name_suffix.submit();\">";
} else {
PRINT '<select name="source_query_id">';
}
?>
<option value="-1"><?php PRINT '[' . lang_get( 'reset_query' ) . ']' ?></option>
<option value="-1"></option>
<?php
foreach( $t_stored_queries_arr as $t_query_id => $t_query_name ) {
PRINT '<option value="' . $t_query_id . '">' . $t_query_name . '</option>';
}
?>
</select>
<input type="submit" name="switch_to_query_button" class="button-small" value="<?php PRINT lang_get( 'use_query' ) ?>" />
</form>
<form method="post" name="open_queries" action="query_view_page.php">
<input type="submit" name="switch_to_query_button" class="button-small" value="<?php PRINT lang_get( 'open_queries' ) ?>" />
</form>
<?php
} else {
?>
<form method="get" name="reset_query" action="view_all_set.php">
<input type="hidden" name="type" value="3" />
<input type="hidden" name="source_query_id" value="-1" />
<input type="submit" name="reset_query_button" class="button-small" value="<?php PRINT lang_get( 'reset_query' ) ?>" />
</form>
<?php
}
if ( access_has_project_level( config_get( 'stored_query_create_threshold' ) ) ) {
?>
<form method="post" name="save_query" action="query_store_page.php">
<input type="submit" name="save_query_button" class="button-small" value="<?php PRINT lang_get( 'save_query' ) ?>" />
</form>
<?php
} else {
?>
<?php
}
?>
</td>
</tr>
</table>
<?php
}
# Add a filter to the database for the current user
function filter_db_set_for_current_user( $p_project_id, $p_is_public,
$p_name, $p_filter_string ) {
$t_user_id = auth_get_current_user_id();
$c_project_id = db_prepare_int( $p_project_id );
$c_is_public = db_prepare_bool( $p_is_public, false );
$c_name = db_prepare_string( $p_name );
$c_filter_string = db_prepare_string( $p_filter_string );
$t_filters_table = config_get( 'mantis_filters_table' );
# check that the user can save non current filters (if required)
if ( ( ALL_PROJECTS <= $c_project_id ) && ( !is_blank( $p_name ) ) &&
( !access_has_project_level( config_get( 'stored_query_create_threshold' ) ) ) ) {
return -1;
}
# ensure that we're not making this filter public if we're not allowed
if ( !access_has_project_level( config_get( 'stored_query_create_shared_threshold' ) ) ) {
$c_is_public = db_prepare_bool( false );
}
# Do I need to update or insert this value?
$query = "SELECT id FROM $t_filters_table
WHERE user_id='$t_user_id'
AND project_id='$c_project_id'
AND name='$c_name'";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
$row = db_fetch_array( $result );
$query = "UPDATE $t_filters_table
SET is_public='$c_is_public',
filter_string='$c_filter_string'
WHERE id='" . $row['id'] . "'";
db_query( $query );
return $row['id'];
} else {
$query = "INSERT INTO $t_filters_table
( user_id, project_id, is_public, name, filter_string )
VALUES
( '$t_user_id', '$c_project_id', '$c_is_public', '$c_name', '$c_filter_string' )";
db_query( $query );
# Recall the query, we want the filter ID
$query = "SELECT id
FROM $t_filters_table
WHERE user_id='$t_user_id'
AND project_id='$c_project_id'
AND name='$c_name'";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
$row = db_fetch_array( $result );
return $row['id'];
}
return -1;
}
}
# We cache filter requests to reduce the number of SQL queries
$g_cache_filter_db_filters = array();
# This function will return the filter string that is
# tied to the unique id parameter. If the user doesn't
# have permission to see this filter, the function will
# return null
function filter_db_get_filter( $p_filter_id, $p_user_id = null ) {
global $g_cache_filter_db_filters;
$t_filters_table = config_get( 'mantis_filters_table' );
$c_filter_id = db_prepare_int( $p_filter_id );
if ( isset( $g_cache_filter_db_filters[$p_filter_id] ) ) {
return $g_cache_filter_db_filters[$p_filter_id];
}
if ( null === $p_user_id ) {
$t_user_id = auth_get_current_user_id();
} else {
$t_user_id = $p_user_id;
}
$query = "SELECT *
FROM $t_filters_table
WHERE id='$c_filter_id'";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
$row = db_fetch_array( $result );
if ( $row['user_id'] != $t_user_id ) {
if ( $row['is_public'] != true ) {
return null;
}
}
# check that the user has access to non current filters
if ( ( ALL_PROJECTS <= $row['project_id'] ) && ( !is_blank( $row['name'] ) ) && ( !access_has_project_level( config_get( 'stored_query_use_threshold', $row['project_id'], $t_user_id ) ) ) ) {
return null;
}
$g_cache_filter_db_filters[$p_filter_id] = $row['filter_string'];
return $row['filter_string'];
}
return null;
}
function filter_db_get_project_current( $p_project_id, $p_user_id = null ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$c_project_id = db_prepare_int( $p_project_id );
$c_project_id = $c_project_id * -1;
if ( null === $p_user_id ) {
$c_user_id = auth_get_current_user_id();
} else {
$c_user_id = db_prepare_int( $p_user_id );
}
# we store current filters for each project with a special project index
$query = "SELECT *
FROM $t_filters_table
WHERE user_id='$c_user_id'
AND project_id='$c_project_id'
AND name=''";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
$row = db_fetch_array( $result );
return $row['id'];
}
return null;
}
function filter_db_get_name( $p_filter_id ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$c_filter_id = db_prepare_int( $p_filter_id );
$query = "SELECT *
FROM $t_filters_table
WHERE id='$c_filter_id'";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
$row = db_fetch_array( $result );
if ( $row['user_id'] != auth_get_current_user_id() ) {
if ( $row['is_public'] != true ) {
return null;
}
}
return $row['name'];
}
return null;
}
# Will return true if the user can delete this query
function filter_db_can_delete_filter( $p_filter_id ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$c_filter_id = db_prepare_int( $p_filter_id );
$t_user_id = auth_get_current_user_id();
# Administrators can delete any filter
if ( access_has_global_level( ADMINISTRATOR ) ) {
return true;
}
$query = "SELECT id
FROM $t_filters_table
WHERE id='$c_filter_id'
AND user_id='$t_user_id'
AND project_id!='-1'";
$result = db_query( $query );
if ( db_num_rows( $result ) > 0 ) {
return true;
}
return false;
}
function filter_db_delete_filter( $p_filter_id ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$c_filter_id = db_prepare_int( $p_filter_id );
$t_user_id = auth_get_current_user_id();
if ( !filter_db_can_delete_filter( $c_filter_id ) ) {
return false;
}
$query = "DELETE FROM $t_filters_table
WHERE id='$c_filter_id'";
$result = db_query( $query );
if ( db_affected_rows( $result ) > 0 ) {
return true;
}
return false;
}
function filter_db_delete_current_filters( ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$t_all_id = ALL_PROJECTS;
$query = "DELETE FROM $t_filters_table
WHERE project_id<='$t_all_id'
AND name=''";
$result = db_query( $query );
}
function filter_db_get_available_queries( $p_project_id = null, $p_user_id = null ) {
$t_filters_table = config_get( 'mantis_filters_table' );
$t_overall_query_arr = array();
if ( null === $p_project_id ) {
$t_project_id = helper_get_current_project();
} else {
$t_project_id = db_prepare_int( $p_project_id );
}
if ( null === $p_user_id ) {
$t_user_id = auth_get_current_user_id();
} else {
$t_user_id = db_prepare_int( $p_user_id );
}
# If the user doesn't have access rights to stored queries, just return
if ( !access_has_project_level( config_get( 'stored_query_use_threshold' ) ) ) {
return $t_overall_query_arr;
}
# Get the list of available queries. By sorting such that public queries are
# first, we can override any query that has the same name as a private query
# with that private one
$query = "SELECT * FROM $t_filters_table
WHERE (project_id='$t_project_id'
OR project_id='0')
AND name!=''
ORDER BY is_public DESC, name ASC";
$result = db_query( $query );
$query_count = db_num_rows( $result );
for ( $i = 0; $i < $query_count; $i++ ) {
$row = db_fetch_array( $result );
if ( ( $row['user_id'] == $t_user_id ) || db_prepare_bool( $row['is_public'] ) ) {
$t_overall_query_arr[$row['id']] = $row['name'];
}
}
$t_overall_query_arr = array_unique( $t_overall_query_arr );
asort( $t_overall_query_arr );
return $t_overall_query_arr;
}
# Make sure that our filters are entirely correct and complete (it is possible that they are not).
# We need to do this to cover cases where we don't have complete control over the filters given.
function filter_ensure_valid_filter( $p_filter_arr ) {
# extend current filter to add information passed via POST
if ( !isset( $p_filter_arr['_version'] ) ) {
$p_filter_arr['_version'] = config_get( 'cookie_version' );
}
$t_cookie_vers = (int) substr( $p_filter_arr['_version'], 1 );
if ( substr( config_get( 'cookie_version' ), 1 ) > $t_cookie_vers ) { # if the version is old, update it
$p_filter_arr['_version'] = config_get( 'cookie_version' );
}
if ( !isset( $p_filter_arr['_view_type'] ) ) {
$p_filter_arr['_view_type'] = gpc_get_string( 'view_type', 'simple' );
}
if ( !isset( $p_filter_arr['per_page'] ) ) {
$p_filter_arr['per_page'] = gpc_get_int( 'per_page', config_get( 'default_limit_view' ) );
}
if ( !isset( $p_filter_arr['highlight_changed'] ) ) {
$p_filter_arr['highlight_changed'] = config_get( 'default_show_changed' );
}
if ( !isset( $p_filter_arr['sticky_issues'] ) ) {
$p_filter_arr['sticky_issues'] = config_get( 'show_sticky_issues' );
}
if ( !isset( $p_filter_arr['sort'] ) ) {
$p_filter_arr['sort'] = "last_updated";
}
if ( !isset( $p_filter_arr['dir'] ) ) {
$p_filter_arr['dir'] = "DESC";
}
if ( !isset( $p_filter_arr['platform'] ) ) {
$p_filter_arr['platform'] = array( 0 => META_FILTER_ANY );
}
if ( !isset( $p_filter_arr['os'] ) ) {
$p_filter_arr['os'] = array( 0 => META_FILTER_ANY );
}
if ( !isset( $p_filter_arr['os_build'] ) ) {
$p_filter_arr['os_build'] = array( 0 => META_FILTER_ANY );
}
if ( !isset( $p_filter_arr['project_id'] ) ) {
$p_filter_arr['project_id'] = array( 0 => META_FILTER_CURRENT );
}
if ( !isset( $p_filter_arr['start_month'] ) ) {
$p_filter_arr['start_month'] = gpc_get_string( 'start_month', date( 'm' ) );
}
if ( !isset( $p_filter_arr['start_day'] ) ) {
$p_filter_arr['start_day'] = gpc_get_string( 'start_day', 1 );
}
if ( !isset( $p_filter_arr['start_year'] ) ) {
$p_filter_arr['start_year'] = gpc_get_string( 'start_year', date( 'Y' ) );
}
if ( !isset( $p_filter_arr['end_month'] ) ) {
$p_filter_arr['end_month'] = gpc_get_string( 'end_month', date( 'm' ) );
}
if ( !isset( $p_filter_arr['end_day'] ) ) {
$p_filter_arr['end_day'] = gpc_get_string( 'end_day', date( 'd' ) );
}
if ( !isset( $p_filter_arr['end_year'] ) ) {
$p_filter_arr['end_year'] = gpc_get_string( 'end_year', date( 'Y' ) );
}
if ( !isset( $p_filter_arr['search'] ) ) {
$p_filter_arr['search'] = '';
}
if ( !isset( $p_filter_arr['and_not_assigned'] ) ) {
$p_filter_arr['and_not_assigned'] = gpc_get_bool( 'and_not_assigned', false );
}
if ( !isset( $p_filter_arr['do_filter_by_date'] ) ) {
$p_filter_arr['do_filter_by_date'] = gpc_get_bool( 'do_filter_by_date', false );
}
if ( !isset( $p_filter_arr['view_state'] ) ) {
$p_filter_arr['view_state'] = gpc_get( 'view_state', '' );
} else if ( ( $p_filter_arr['view_state'] == 'any' ) || ( $p_filter_arr['view_state'] == 0 ) ) {
$p_filter_arr['view_state'] = META_FILTER_ANY;
}
if ( !isset( $p_filter_arr['relationship_type'] ) ) {
$p_filter_arr['relationship_type'] = gpc_get_int( 'relationship_type', -1 );
}
if ( !isset( $p_filter_arr['relationship_bug'] ) ) {
$p_filter_arr['relationship_bug'] = gpc_get_int( 'relationship_bug', 0 );
}
if ( !isset( $p_filter_arr['target_version'] ) ) {
$p_filter_arr['target_version'] = META_FILTER_ANY;
}
if ( !isset( $p_filter_arr['tag_string'] ) ) {
$p_filter_arr['tag_string'] = gpc_get_string( 'tag_string', '' );
}
if ( !isset( $p_filter_arr['tag_select'] ) ) {
$p_filter_arr['tag_select'] = gpc_get_string( 'tag_select', '' );
}
$t_custom_fields = custom_field_get_ids(); # @@@ (thraxisp) This should really be the linked ids, but we don't know the project
$f_custom_fields_data = array();
if ( is_array( $t_custom_fields ) && ( sizeof( $t_custom_fields ) > 0 ) ) {
foreach( $t_custom_fields as $t_cfid ) {
if ( is_array( gpc_get( 'custom_field_' . $t_cfid, null ) ) ) {
$f_custom_fields_data[$t_cfid] = gpc_get_string_array( 'custom_field_' . $t_cfid, META_FILTER_ANY );
} else {
$f_custom_fields_data[$t_cfid] = gpc_get_string( 'custom_field_' . $t_cfid, META_FILTER_ANY );
$f_custom_fields_data[$t_cfid] = array( $f_custom_fields_data[$t_cfid] );
}
}
}
#validate sorting
$t_fields = helper_get_columns_to_view();
$t_n_fields = count( $t_fields );
for ( $i=0; $i < $t_n_fields; $i++ ) {
if ( isset( $t_fields[$i] ) && in_array( $t_fields[$i], array( 'selection', 'edit', 'bugnotes_count', 'attachment' ) ) ) {
unset( $t_fields[$i] );
}
}
$t_sort_fields = split( ',', $p_filter_arr['sort'] );
$t_dir_fields = split( ',', $p_filter_arr['dir'] );
for ( $i=0; $i<2; $i++ ) {
if ( isset( $t_sort_fields[$i] ) ) {
$t_drop = false;
$t_sort = $t_sort_fields[$i];
if ( strpos( $t_sort, 'custom_' ) === 0 ) {
if ( false === custom_field_get_id_from_name( substr( $t_sort, strlen( 'custom_' ) ) ) ) {
$t_drop = true;
}
} else {
if ( ! in_array( $t_sort, $t_fields ) ) {
$t_drop = true;
}
}
if ( ! in_array( $t_dir_fields[$i], array( "ASC", "DESC" ) ) ) {
$t_drop = true;
}
if ( $t_drop ) {
unset( $t_sort_fields[$i] );
unset( $t_dir_fields[$i] );
}
}
}
if ( count( $t_sort_fields ) > 0 ) {
$p_filter_arr['sort'] = implode( ',', $t_sort_fields );
$p_filter_arr['dir'] = implode( ',', $t_dir_fields );
} else {
$p_filter_arr['sort'] = "last_updated";
$p_filter_arr['dir'] = "DESC";
}
# validate or filter junk from other fields
$t_multi_select_list = array( 'show_category' => 'string',
'show_severity' => 'int',
'show_status' => 'int',
'reporter_id' => 'int',
'handler_id' => 'int',
'show_resolution' => 'int',
'show_priority' => 'int',
'show_build' => 'string',
'show_version' => 'string',
'hide_status' => 'int',
'fixed_in_version' => 'string',
'target_version' => 'string',
'user_monitor' => 'int',
'show_profile' => 'int'
);
foreach( $t_multi_select_list as $t_multi_field_name => $t_multi_field_type ) {
if ( !isset( $p_filter_arr[$t_multi_field_name] ) ) {
if ( 'hide_status' == $t_multi_field_name ) {
$p_filter_arr[$t_multi_field_name] = array( config_get( 'hide_status_default' ) );
} else if ( 'custom_fields' == $t_multi_field_name ) {
$p_filter_arr[$t_multi_field_name] = array( $f_custom_fields_data );
} else {
$p_filter_arr[$t_multi_field_name] = array( META_FILTER_ANY );
}
} else {
if ( !is_array( $p_filter_arr[$t_multi_field_name] ) ) {
$p_filter_arr[$t_multi_field_name] = array( $p_filter_arr[$t_multi_field_name] );
}
$t_checked_array = array();
foreach ( $p_filter_arr[$t_multi_field_name] as $t_filter_value ) {
$t_filter_value = stripslashes( $t_filter_value );
if ( ( $t_filter_value === 'any' ) || ( $t_filter_value === '[any]' ) ) {
$t_filter_value = META_FILTER_ANY;
}
if ( ( $t_filter_value === 'none' ) || ( $t_filter_value === '[none]' ) ) {
$t_filter_value = META_FILTER_NONE;
}
if ( 'string' == $t_multi_field_type ) {
$t_checked_array[] = db_prepare_string( $t_filter_value );
} else if ( 'int' == $t_multi_field_type ) {
$t_checked_array[] = db_prepare_int( $t_filter_value );
} else if ( 'array' == $t_multi_field_type ) {
$t_checked_array[] = $t_filter_value;
}
}
$p_filter_arr[$t_multi_field_name] = $t_checked_array;
}
}
if ( is_array( $t_custom_fields ) && ( sizeof( $t_custom_fields ) > 0 ) ) {
foreach( $t_custom_fields as $t_cfid ) {
if ( !isset( $p_filter_arr['custom_fields'][$t_cfid] ) ) {
$p_filter_arr['custom_fields'][$t_cfid] = array( META_FILTER_ANY );
} else {
if ( !is_array( $p_filter_arr['custom_fields'][$t_cfid] ) ) {
$p_filter_arr['custom_fields'][$t_cfid] = array( $p_filter_arr['custom_fields'][$t_cfid] );
}
$t_checked_array = array();
foreach ( $p_filter_arr['custom_fields'][$t_cfid] as $t_filter_value ) {
$t_filter_value = stripslashes( $t_filter_value );
if ( ( $t_filter_value === 'any' ) || ( $t_filter_value === '[any]' ) ) {
$t_filter_value = META_FILTER_ANY;
}
$t_checked_array[] = db_prepare_string( $t_filter_value );
}
$p_filter_arr['custom_fields'][$t_cfid] = $t_checked_array;
}
}
}
# all of our filter values are now guaranteed to be there, and correct.
return $p_filter_arr;
}
/**
* The following functions each print out an individual filter field.
* They are derived from view_filters_page.php
*
* The functions follow a strict naming convention:
*
* print_filter_[filter_name]
*
* Where [filter_name] is the same as the "name" of the form element for
* that filter. This naming convention is depended upon by the controller
* at the end of the script.
*/
/**
* I expect that this code could be made simpler by refactoring into a
* class so as to avoid all those calls to global(which are pretty ugly)
*
* These functions could also be shared by view_filters_page.php
*
*/
function print_filter_reporter_id(){
global $t_select_modifier, $t_filter;
?>
<select <?php PRINT $t_select_modifier;?> name="reporter_id[]">
<?php
# if current user is a reporter, and limited reports set to ON, only display that name
# @@@ thraxisp - access_has_project_level checks greater than or equal to,
# this assumed that there aren't any holes above REPORTER where the limit would apply
#
if ( ( ON === config_get( 'limit_reporters' ) ) && ( ! access_has_project_level( REPORTER + 1 ) ) ) {
$t_id = auth_get_current_user_id();
$t_username = user_get_field( $t_id, 'username' );
$t_realname = user_get_field( $t_id, 'realname' );
$t_display_name = string_attribute( $t_username );
if ( ( isset( $t_realname ) ) && ( $t_realname > "" ) && ( ON == config_get( 'show_realname' ) ) ){
$t_display_name = string_attribute( $t_realname );
}
PRINT '<option value="' . $t_id . '" selected="selected">' . $t_display_name . '</option>';
} else {
?>
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['reporter_id'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php
if ( access_has_project_level( config_get( 'report_bug_threshold' ) ) ) {
PRINT '<option value="' . META_FILTER_MYSELF . '" ';
check_selected( $t_filter['reporter_id'], META_FILTER_MYSELF );
PRINT '>[' . lang_get( 'myself' ) . ']</option>';
}
?>
<?php print_reporter_option_list( $t_filter['reporter_id'] ) ?>
<?php } ?>
</select>
<?php
}
function print_filter_user_monitor(){
global $t_select_modifier, $t_filter;
?>
<!-- Monitored by -->
<select <?php PRINT $t_select_modifier;?> name="user_monitor[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['user_monitor'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php
if ( access_has_project_level( config_get( 'monitor_bug_threshold' ) ) ) {
PRINT '<option value="' . META_FILTER_MYSELF . '" ';
check_selected( $t_filter['user_monitor'], META_FILTER_MYSELF );
PRINT '>[' . lang_get( 'myself' ) . ']</option>';
}
$t_threshold = config_get( 'show_monitor_list_threshold' );
$t_has_project_level = access_has_project_level( $t_threshold );
if ( $t_has_project_level ) {
print_reporter_option_list( $t_filter['user_monitor'] );
}
?>
</select>
<?php
}
function print_filter_handler_id(){
global $t_select_modifier, $t_filter, $f_view_type;
?>
<!-- Handler -->
<select <?php PRINT $t_select_modifier;?> name="handler_id[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['handler_id'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php if ( access_has_project_level( config_get( 'view_handler_threshold' ) ) ) { ?>
<option value="<?php echo META_FILTER_NONE ?>" <?php check_selected( $t_filter['handler_id'], META_FILTER_NONE ); ?>>[<?php echo lang_get( 'none' ) ?>]</option>
<?php
if ( access_has_project_level( config_get( 'handle_bug_threshold' ) ) ) {
PRINT '<option value="' . META_FILTER_MYSELF . '" ';
check_selected( $t_filter['handler_id'], META_FILTER_MYSELF );
PRINT '>[' . lang_get( 'myself' ) . ']</option>';
}
?>
<?php print_assign_to_option_list( $t_filter['handler_id'] ) ?>
<?php } ?>
</select>
<?php
}
function print_filter_show_category(){
global $t_select_modifier, $t_filter;
?>
<!-- Category -->
<select <?php PRINT $t_select_modifier;?> name="show_category[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_category'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php # This shows orphaned categories as well as selectable categories ?>
<?php print_category_complete_option_list( $t_filter['show_category'] ) ?>
</select>
<?php
}
function print_filter_platform() {
global $t_select_modifier, $t_filter;
?>
<!-- Platform -->
<select <?php echo $t_select_modifier;?> name="platform[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['platform'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php
log_event( LOG_FILTERING, 'Platform = ' . var_export( $t_filter['platform'], true ) );
print_platform_option_list( $t_filter['platform'] );
?>
</select>
<?php
}
function print_filter_os() {
global $t_select_modifier, $t_filter;
?>
<!-- OS -->
<select <?php echo $t_select_modifier;?> name="os[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['os'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_os_option_list( $t_filter['os'] ) ?>
</select>
<?php
}
function print_filter_os_build() {
global $t_select_modifier, $t_filter;
?>
<!-- OS Build -->
<select <?php echo $t_select_modifier;?> name="os_build[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['os_build'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_os_build_option_list( $t_filter['os_build'] ) ?>
</select>
<?php
}
function print_filter_show_severity(){
global $t_select_modifier, $t_filter;
?><!-- Severity -->
<select <?php PRINT $t_select_modifier;?> name="show_severity[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_severity'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_enum_string_option_list( 'severity', $t_filter['show_severity'] ) ?>
</select>
<?php
}
function print_filter_show_resolution(){
global $t_select_modifier, $t_filter;
?><!-- Resolution -->
<select <?php PRINT $t_select_modifier;?> name="show_resolution[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_resolution'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_enum_string_option_list( 'resolution', $t_filter['show_resolution'] ) ?>
</select>
<?php
}
function print_filter_show_status(){
global $t_select_modifier, $t_filter;
?> <!-- Status -->
<select <?php PRINT $t_select_modifier;?> name="show_status[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_status'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_enum_string_option_list( 'status', $t_filter['show_status'] ) ?>
</select>
<?php
}
function print_filter_hide_status(){
global $t_select_modifier, $t_filter;
?><!-- Hide Status -->
<select <?php PRINT $t_select_modifier;?> name="hide_status[]">
<option value="<?php echo META_FILTER_NONE ?>">[<?php echo lang_get( 'none' ) ?>]</option>
<?php print_enum_string_option_list( 'status', $t_filter['hide_status'] ) ?>
</select>
<?php
}
function print_filter_show_build(){
global $t_select_modifier, $t_filter;
?><!-- Build -->
<select <?php PRINT $t_select_modifier;?> name="show_build[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_build'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<option value="<?php echo META_FILTER_NONE ?>" <?php check_selected( $t_filter['show_build'], META_FILTER_NONE ); ?>>[<?php echo lang_get( 'none' ) ?>]</option>
<?php print_build_option_list( $t_filter['show_build'] ) ?>
</select>
<?php
}
function print_filter_show_version(){
global $t_select_modifier, $t_filter;
?><!-- Version -->
<select <?php PRINT $t_select_modifier;?> name="show_version[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_version'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<option value="<?php echo META_FILTER_NONE ?>" <?php check_selected( $t_filter['show_version'], META_FILTER_NONE ); ?>>[<?php echo lang_get( 'none' ) ?>]</option>
<?php print_version_option_list( $t_filter['show_version'], null, VERSION_RELEASED, false, true ) ?>
</select>
<?php
}
function print_filter_show_fixed_in_version(){
global $t_select_modifier, $t_filter;
?><!-- Fixed in Version -->
<select <?php PRINT $t_select_modifier;?> name="fixed_in_version[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['fixed_in_version'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<option value="<?php echo META_FILTER_NONE ?>" <?php check_selected( $t_filter['fixed_in_version'], META_FILTER_NONE ); ?>>[<?php echo lang_get( 'none' ) ?>]</option>
<?php print_version_option_list( $t_filter['fixed_in_version'], null, VERSION_ALL, false, true ) ?>
</select>
<?php
}
function print_filter_show_target_version(){
global $t_select_modifier, $t_filter;
?><!-- Fixed in Version -->
<select <?php PRINT $t_select_modifier;?> name="target_version[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['target_version'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<option value="<?php echo META_FILTER_NONE ?>" <?php check_selected( $t_filter['target_version'], META_FILTER_NONE ); ?>>[<?php echo lang_get( 'none' ) ?>]</option>
<?php print_version_option_list( $t_filter['target_version'], null, VERSION_ALL, false, true ) ?>
</select>
<?php
}
function print_filter_show_priority(){
global $t_select_modifier, $t_filter;
?><!-- Priority -->
<select <?php PRINT $t_select_modifier;?> name="show_priority[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_priority'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_enum_string_option_list( 'priority', $t_filter['show_priority'] ) ?>
</select>
<?php
}
function print_filter_show_profile() {
global $t_select_modifier, $t_filter;
?><!-- Profile -->
<select <?php PRINT $t_select_modifier;?> name="show_profile[]">
<option value="<?php echo META_FILTER_ANY ?>" <?php check_selected( $t_filter['show_profile'], META_FILTER_ANY ); ?>>[<?php echo lang_get( 'any' ) ?>]</option>
<?php print_profile_option_list_for_project( helper_get_current_project(), $t_filter['show_profile'] ); ?>
</select>
<?php
}
function print_filter_per_page(){
global $t_filter;
?><!-- Number of bugs per page -->
<input type="text" name="per_page" size="3" maxlength="7" value="<?php echo $t_filter['per_page'] ?>" />
<?php
}
function print_filter_view_state(){
global $t_select_modifier, $t_filter;
?><!-- View Status -->
<select name="view_state">
<?php
PRINT '<option value="' . META_FILTER_ANY . '" ';
check_selected( $t_filter['view_state'], META_FILTER_ANY );
PRINT '>[' . lang_get( 'any' ) . ']</option>';
PRINT '<option value="' . VS_PUBLIC . '" ';
check_selected( $t_filter['view_state'], VS_PUBLIC );
PRINT '>' . lang_get( 'public' ) . '</option>';
PRINT '<option value="' . VS_PRIVATE . '" ';
check_selected( $t_filter['view_state'], VS_PRIVATE );
PRINT '>' . lang_get( 'private' ) . '</option>';
?>
</select>
<?php
}
function print_filter_sticky_issues(){
global $t_filter;
?><!-- Show or hide sticky bugs -->
<input type="checkbox" name="sticky_issues" <?php check_checked( gpc_string_to_bool( $t_filter['sticky_issues'] ), 'on' ); ?> />
<?php
}
function print_filter_highlight_changed(){
global $t_filter;
?><!-- Highlight changed bugs -->
<input type="text" name="highlight_changed" size="3" maxlength="7" value="<?php echo $t_filter['highlight_changed'] ?>" />
<?php
}
function print_filter_do_filter_by_date( $p_hide_checkbox=false ){
global $t_filter;
?>
<table cellspacing="0" cellpadding="0">
<?php if ( ! $p_hide_checkbox ) {
?>
<tr><td colspan="2">
<label title="<?php echo lang_get( 'use_date_filters' ); ?>">
<input type="checkbox" name="do_filter_by_date" <?php
check_checked( $t_filter['do_filter_by_date'], 'on' );
if ( ON == config_get( 'use_javascript' ) ) {
print "onclick=\"SwitchDateFields();\""; } ?> />
<?php echo lang_get( 'use_date_filters' ) ?>
<?php echo '</label>'; ?>
</td></tr>
<?php }
$t_menu_disabled = ( 'on' == $t_filter['do_filter_by_date'] ) ? '' : ' disabled ';
?>
<!-- Start date -->
<tr>
<td>
<?php echo lang_get( 'start_date' ) ?>:
</td>
<td nowrap="nowrap">
<?php
$t_chars = preg_split( '//', config_get( 'short_date_format' ), -1, PREG_SPLIT_NO_EMPTY );
foreach( $t_chars as $t_char ) {
if ( strcasecmp( $t_char, "M" ) == 0 ) {
print "<select name=\"start_month\" $t_menu_disabled>";
print_month_option_list( $t_filter['start_month'] );
print "</select>\n";
}
if ( strcasecmp( $t_char, "D" ) == 0 ) {
print "<select name=\"start_day\" $t_menu_disabled>";
print_day_option_list( $t_filter['start_day'] );
print "</select>\n";
}
if ( strcasecmp( $t_char, "Y" ) == 0 ) {
print "<select name=\"start_year\" $t_menu_disabled>";
print_year_option_list( $t_filter['start_year'] );
print "</select>\n";
}
}
?>
</td>
</tr>
<!-- End date -->
<tr>
<td>
<?php echo lang_get( 'end_date' ) ?>:
</td>
<td>
<?php
$t_chars = preg_split( '//', config_get( 'short_date_format' ), -1, PREG_SPLIT_NO_EMPTY );
foreach( $t_chars as $t_char ) {
if ( strcasecmp( $t_char, "M" ) == 0 ) {
print "<select name=\"end_month\" $t_menu_disabled>";
print_month_option_list( $t_filter['end_month'] );
print "</select>\n";
}
if ( strcasecmp( $t_char, "D" ) == 0 ) {
print "<select name=\"end_day\" $t_menu_disabled>";
print_day_option_list( $t_filter['end_day'] );
print "</select>\n";
}
if ( strcasecmp( $t_char, "Y" ) == 0 ) {
print "<select name=\"end_year\" $t_menu_disabled>";
print_year_option_list( $t_filter['end_year'] );
print "</select>\n";
}
}
?>
</td>
</tr>
</table>
<?php
}
function print_filter_relationship_type(){
global $t_filter;
$c_reltype_value = $t_filter['relationship_type'];
if (!$c_reltype_value) {
$c_reltype_value = -1;
}
relationship_list_box ($c_reltype_value, "relationship_type", true); ?>
<input type="text" name="relationship_bug" size="5" maxlength="10" value="<?php echo $t_filter['relationship_bug']?>" />
<?php
}
function print_filter_tag_string() {
global $t_filter;
$t_tag_string = $t_filter['tag_string'];
if ( $t_filter['tag_select'] != 0 ) {
$t_tag_string .= ( is_blank( $t_tag_string ) ? '' : config_get( 'tag_separator' ) );
$t_tag_string .= tag_get_field( $t_filter['tag_select'], 'name' );
}
?>
<input type="hidden" id="tag_separator" value="<?php echo config_get( 'tag_separator' ) ?>" />
<input type="text" name="tag_string" id="tag_string" size="40" value="<?php echo $t_tag_string ?>" />
<select <?php echo helper_get_tab_index() ?> name="tag_select" id="tag_select">
<?php print_tag_option_list(); ?>
</select>
<?php
}
function print_filter_custom_field($p_field_id){
global $t_filter, $t_accessible_custom_fields_names, $t_accessible_custom_fields_types, $t_accessible_custom_fields_values, $t_accessible_custom_fields_ids, $t_select_modifier;
$j = array_search($p_field_id, $t_accessible_custom_fields_ids);
if($j === null || $j === false){
# Note: Prior to PHP 4.2.0, array_search() returns NULL on failure instead of FALSE.
?>
<span style="color:red;weight:bold;">
unknown custom filter (custom <?php $p_field_id; ?>)
</span>
<?php
} elseif ( isset( $t_accessible_custom_fields_names[$j] ) ) {
if ($t_accessible_custom_fields_types[$j] == CUSTOM_FIELD_TYPE_DATE) {
print_filter_custom_field_date($j, $p_field_id) ;
} else {
echo '<select ' . $t_select_modifier . ' name="custom_field_' . $p_field_id .'[]">';
echo '<option value="' . META_FILTER_ANY . '" ';
check_selected( $t_filter['custom_fields'][ $p_field_id ], META_FILTER_ANY );
echo '>[' . lang_get( 'any' ) .']</option>';
# don't show META_FILTER_NONE for enumerated types as it's not possible for them to be blank
if ( ! in_array( $t_accessible_custom_fields_types[$j], array( CUSTOM_FIELD_TYPE_ENUM, CUSTOM_FIELD_TYPE_LIST, CUSTOM_FIELD_TYPE_MULTILIST ) ) ) {
echo '<option value="' . META_FILTER_NONE . '" ';
check_selected( $t_filter['custom_fields'][ $p_field_id ], META_FILTER_NONE );
echo '>[' . lang_get( 'none' ) .']</option>';
}
foreach( $t_accessible_custom_fields_values[$j] as $t_item ) {
if ( ( strtolower( $t_item ) !== META_FILTER_ANY ) && ( strtolower( $t_item ) !== META_FILTER_NONE ) ) {
echo '<option value="' . string_html_entities( $t_item ) . '" ';
if ( isset( $t_filter['custom_fields'][ $p_field_id ] ) ) {
check_selected( $t_filter['custom_fields'][ $p_field_id ], $t_item );
}
echo '>' . string_shorten( $t_item ) . '</option>' . "\n";
}
}
echo '</select>';
}
}
}
function print_filter_show_sort() {
global $t_filter;
# get all of the displayed fields for sort, then drop ones that
# are not appropriate and translate the rest
$t_fields = helper_get_columns_to_view();
$t_n_fields = count( $t_fields );
$t_shown_fields[""] = "";
for ( $i=0; $i < $t_n_fields; $i++ ) {
if ( !in_array( $t_fields[$i], array( 'selection', 'edit', 'bugnotes_count', 'attachment' ) ) ) {
if ( strpos( $t_fields[$i], 'custom_' ) === 0 ) {
$t_field_name = string_display( lang_get_defaulted( substr( $t_fields[$i], strlen( 'custom_' ) ) ) );
} else {
$t_field_name = string_get_field_name( $t_fields[$i] );
}
$t_shown_fields[$t_fields[$i]] = $t_field_name;
}
}
$t_shown_dirs[""] = "";
$t_shown_dirs["ASC"] = lang_get( 'bugnote_order_asc' );
$t_shown_dirs["DESC"] = lang_get( 'bugnote_order_desc' );
# get default values from filter structure
$t_sort_fields = split( ',', $t_filter['sort'] );
$t_dir_fields = split( ',', $t_filter['dir'] );
if ( !isset( $t_sort_fields[1] ) ) {
$t_sort_fields[1] = '';
$t_dir_fields[1] = '';
}
# if there are fields to display, show the dropdowns
if ( count( $t_fields ) > 0 ) {
# display a primary and secondary sort fields
echo '<select name="sort_0">';
foreach ( $t_shown_fields as $key => $val ) {
echo "<option value=\"$key\"";
check_selected( $key, $t_sort_fields[0] );
echo ">$val</option>";
}
echo '</select>';
echo '<select name="dir_0">';
foreach ( $t_shown_dirs as $key => $val ) {
echo "<option value=\"$key\"";
check_selected( $key, $t_dir_fields[0] );
echo ">$val</option>";
}
echo '</select>';
echo ', ';
# for secondary sort
echo '<select name="sort_1">';
foreach ( $t_shown_fields as $key => $val ) {
echo "<option value=\"$key\"";
check_selected( $key, $t_sort_fields[1] );
echo ">$val</option>";
}
echo '</select>';
echo '<select name="dir_1">';
foreach ($t_shown_dirs as $key => $val ) {
echo "<option value=\"$key\"";
check_selected( $key, $t_dir_fields[1] );
echo ">$val</option>";
}
echo '</select>';
} else {
echo lang_get_defaulted( 'last_updated' ) . lang_get( 'bugnote_order_desc' );
echo "<input type=\"hidden\" name=\"sort_1\" value=\"last_updated\" />";
echo "<input type=\"hidden\" name=\"dir_1\" value=\"DESC\" />";
}
}
function print_filter_custom_field_date($p_field_num, $p_field_id) {
global $t_filter, $t_accessible_custom_fields_names, $t_accessible_custom_fields_types, $t_accessible_custom_fields_values, $t_accessible_custom_fields_ids, $t_select_modifier;
$t_js_toggle_func = "toggle_custom_date_field_" . $p_field_id . "_controls" ;
# Resort the values so there ordered numerically, they are sorted as strings otherwise which
# may be wrong for dates before early 2001.
if (is_array($t_accessible_custom_fields_values[$p_field_num]))
{
array_multisort($t_accessible_custom_fields_values[$p_field_num], SORT_NUMERIC, SORT_ASC);
}
if (isset($t_accessible_custom_fields_values[$p_field_num][0])) {
$t_sel_start_year = date( 'Y', $t_accessible_custom_fields_values[$p_field_num][0]) ;
}
$t_count = count($t_accessible_custom_fields_values[$p_field_num]) ;
if (isset($t_accessible_custom_fields_values[$p_field_num][$t_count-1])) {
$t_sel_end_year = date( 'Y', $t_accessible_custom_fields_values[$p_field_num][$t_count-1]) ;
}
$t_start = date( 'U' ); # Default to today in filters..
$t_end = $t_start;
if ( isset( $t_filter['custom_fields'][$p_field_id][1] ) ) {
$t_start_time = $t_filter['custom_fields'][$p_field_id][1];
} else {
$t_start_time = 0;
}
if ( isset( $t_filter['custom_fields'][$p_field_id][2] ) ) {
$t_end_time = $t_filter['custom_fields'][$p_field_id][2];
} else {
$t_end_time = 0;
}
$t_start_disable = true;
$t_end_disable = true;
// if $t_filter['custom_fields'][$p_field_id][0] is not set (ie no filter), we will drop through the
// following switch and use the default values above, so no need to check if stuff is set or not.
switch ($t_filter['custom_fields'][$p_field_id][0]) {
case CUSTOM_FIELD_DATE_ANY:
case CUSTOM_FIELD_DATE_NONE:
break;
case CUSTOM_FIELD_DATE_BETWEEN:
$t_start_disable = false;
$t_end_disable = false;
$t_start = $t_start_time;
$t_end = $t_end_time;
break;
case CUSTOM_FIELD_DATE_ONORBEFORE:
$t_start_disable = false;
$t_start = $t_end_time;
break;
case CUSTOM_FIELD_DATE_BEFORE:
$t_start_disable = false;
$t_start = $t_end_time;
break;
case CUSTOM_FIELD_DATE_ON:
$t_start_disable = false;
$t_start = $t_start_time;
break;
case CUSTOM_FIELD_DATE_AFTER:
$t_start_disable = false;
$t_start = $t_start_time;
break;
case CUSTOM_FIELD_DATE_ONORAFTER:
$t_start_disable = false;
$t_start = $t_start_time;
break;
}
echo "\n<table cellspacing=\"0\" cellpadding=\"0\"><tr><td>\n" ;
echo "<select size=\"1\" name=\"custom_field_" . $p_field_id . "_control\" OnChange=\"" . $t_js_toggle_func . "();\">\n";
echo '<option value="' . CUSTOM_FIELD_DATE_ANY . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_ANY );
echo '>' . lang_get( 'any' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_NONE . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_NONE );
echo '>' . lang_get( 'none' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_BETWEEN . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_BETWEEN );
echo '>' . lang_get( 'between' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_ONORBEFORE . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_ONORBEFORE );
echo '>' . lang_get( 'on_or_before' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_BEFORE . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_BEFORE );
echo '>' . lang_get( 'before' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_ON . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_ON );
echo '>' . lang_get( 'on' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_AFTER . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_AFTER );
echo '>' . lang_get( 'after' ) . '</option>' . "\n";
echo '<option value="' . CUSTOM_FIELD_DATE_ONORAFTER . '"';
check_selected( $t_filter['custom_fields'][$p_field_id][0], CUSTOM_FIELD_DATE_ONORAFTER );
echo '>' . lang_get( 'on_or_after' ) . '</option>' . "\n";
echo '</select>' . "\n";
echo "</td></tr>\n<tr><td>";
print_date_selection_set("custom_field_" . $p_field_id . "_start" , config_get( 'short_date_format'), $t_start, $t_start_disable, false, $t_sel_start_year, $t_sel_end_year);
print "</td></tr>\n<tr><td>";
print_date_selection_set("custom_field_" . $p_field_id . "_end" , config_get( 'short_date_format'), $t_end, $t_end_disable, false, $t_sel_start_year, $t_sel_end_year);
print "</td></tr>\n</table>";
}
function print_filter_project_id(){
global $t_select_modifier, $t_filter, $f_view_type;
?>
<!-- Project -->
<select <?php PRINT $t_select_modifier;?> name="project_id[]">
<option value="<?php echo META_FILTER_CURRENT ?>" <?php check_selected( $t_filter['project_id'], META_FILTER_CURRENT ); ?>>[<?php echo lang_get( 'current' ) ?>]</option>
<?php print_project_option_list( $t_filter['project_id'] ) ?>
</select>
<?php
}
# Prints a multi-value filter field. For example, platform, etc.
# $p_field_name - The name of the field, e.g. "platform"
# $p_field_value - an array of values.
function print_multivalue_field( $p_field_name, $p_field_value ) {
$t_output = '';
$t_any_found = false;
if ( count( $p_field_value ) == 0 ) {
echo lang_get( 'any' );
} else {
$t_first_flag = true;
$t_field_value = is_array( $p_field_value ) ? $p_field_value : array( $p_field_value );
foreach( $t_field_value as $t_current ) {
$t_current = stripslashes( $t_current );
?>
<input type="hidden" name="<?php echo $p_field_name ?>[]" value="<?php echo string_display( $t_current );?>" />
<?php
$t_this_string = '';
if ( ( ( $t_current == META_FILTER_ANY ) && ( is_numeric( $t_current ) ) )
|| ( is_blank( $t_current ) ) ) {
$t_any_found = true;
} else {
$t_this_string = string_display( $t_current );
}
if ( $t_first_flag != true ) {
$t_output .= '<br />';
} else {
$t_first_flag = false;
}
$t_output .= $t_this_string;
}
if ( true == $t_any_found ) {
echo lang_get( 'any' );
} else {
echo $t_output;
}
}
}
#===================================
# Caching
#===================================
#########################################
# SECURITY NOTE: cache globals are initialized here to prevent them
# being spoofed if register_globals is turned on
$g_cache_filter = array();
# --------------------
# Cache a filter row if necessary and return the cached copy
# If the second parameter is true (default), trigger an error
# if the filter can't be found. If the second parameter is
# false, return false if the filter can't be found.
function filter_cache_row( $p_filter_id, $p_trigger_errors=true) {
global $g_cache_filter;
$c_filter_id = db_prepare_int( $p_filter_id );
$t_filters_table = config_get( 'mantis_filters_table' );
if ( isset ( $g_cache_filter[$c_filter_id] ) ) {
return $g_cache_filter[$c_filter_id];
}
$query = "SELECT *
FROM $t_filters_table
WHERE id='$c_filter_id'";
$result = db_query( $query );
if ( 0 == db_num_rows( $result ) ) {
if ( $p_trigger_errors ) {
error_parameters( $p_filter_id );
trigger_error( ERROR_FILTER_NOT_FOUND, ERROR );
} else {
return false;
}
}
$row = db_fetch_array( $result );
$g_cache_filter[$c_filter_id] = $row;
return $row;
}
# --------------------
# Clear the filter cache (or just the given id if specified)
function filter_clear_cache( $p_filter_id = null ) {
global $g_cache_filter;
if ( null === $p_filter_id ) {
$g_cache_filter = array();
} else {
$c_filter_id = db_prepare_int( $p_filter_id );
unset( $g_cache_filter[$c_filter_id] );
}
return true;
}
# --------------------
# return a filter row
function filter_get_row( $p_filter_id ) {
return filter_cache_row( $p_filter_id );
}
# --------------------
function filter_get_field( $p_filter_id, $p_field_name ) {
$row = filter_get_row( $p_filter_id );
if ( isset( $row[$p_field_name] ) ) {
return $row[$p_field_name];
} else {
error_parameters( $p_field_name );
trigger_error( ERROR_DB_FIELD_NOT_FOUND, WARNING );
return '';
}
}
# --------------------
# Checks if a filter value is "any". Supports both single value as well as multiple value
# fields (array).
# $p_filter_value - The value which can be a simple value or an array.
function _filter_is_any( $p_filter_value ) {
if ( ( META_FILTER_ANY == $p_filter_value ) && is_numeric( $p_filter_value ) ) {
return true;
}
if ( count( $p_filter_value ) == 0 ) {
return true;
}
foreach( $p_filter_value as $t_value ) {
if ( ( META_FILTER_ANY == $t_value ) && ( is_numeric( $t_value ) ) ) {
return true;
}
}
return false;
}
?>