View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0006661 | mantisbt | filters | public | 2006-02-02 15:43 | 2009-01-15 11:26 |
Reporter | carlokok | Assigned To | daryn | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Fixed in Version | 1.2.0a3 | ||||
Summary | 0006661: Sorting on two custom fields results in SQL errors | ||||
Description | steps: | ||||
Additional Information | APPLICATION ERROR 0000401 Database query failed. Error received from database was #1066: Not ORDER BY sticky DESC, mantis_custom_field_string_table.value DESC, Please use the "Back" button in your web browser to return to the | ||||
Tags | No tags attached. | ||||
Attached Files | filter_api.php.patch (2,238 bytes)
Index: filter_api.php =================================================================== RCS file: /cvsroot/mantisbt/mantisbt/core/filter_api.php,v retrieving revision 1.152 diff -u -r1.152 filter_api.php --- filter_api.php 18 Apr 2007 06:35:01 -0000 1.152 +++ filter_api.php 26 Apr 2007 07:57:12 -0000 @@ -1049,11 +1049,11 @@ 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) . ')' ; + $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] . ')' ; + $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 { @@ -1234,9 +1234,12 @@ 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"; + $t_table_name = $t_custom_field_string_table . '_' . $t_custom_field_id; + $t_join .= " 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_custom_field_id ) )"; + $c_sort = "$t_table_name.value"; + $t_select_clauses[] = "$t_table_name.value"; + + echo($t_table_name); } if ( 'DESC' == $t_dir_fields[$i] ) { filter_api.php (151,635 bytes)
<?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 # This program is distributed under the terms and conditions of the GPL # See the README and LICENSE files for details # -------------------------------------------------------- # $Id: filter_api.php,v 1.153 2007/04/25 06:15:12 vboctor Exp $ # -------------------------------------------------------- $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' ); ########################################################################### # 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' ); ########################################################################### # 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' ); # 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_query[] = filter_encode_field_and_value( FILTER_SEARCH_PROJECT_ID, $p_custom_filter[FILTER_PROPERTY_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] ); } # @@@ Add support for Custom Fields 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 $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 ) { $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 $c_rel_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" ); // get reverse relationships if ( $c_rel_type == 1 ) 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" ); array_push( $t_clauses, "($t_table_name.relationship_type='$c_rel_type' AND $t_table_name.source_bug_id='$c_rel_bug')" ); // get reverse relationships if ( $c_rel_type == 1 ) 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 ) .')' ); } # custom field filters if( ON == config_get( 'filter_by_custom_fields' ) ) { # custom field filtering $t_custom_fields = custom_field_get_linked_ids( $t_project_id ); foreach( $t_custom_fields as $t_cfid ) { $t_first_time = true; $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 ); 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 $t_filter_member = ''; } if( $t_first_time ) { $t_first_time = false; $t_custom_where_clause = '('; } else { $t_custom_where_clause .= ' OR '; } switch( $t_def['type'] ) { case CUSTOM_FIELD_TYPE_MULTILIST: case CUSTOM_FIELD_TYPE_CHECKBOX: $t_custom_where_clause .= db_helper_like( "$t_table_name.value", '%|' . db_prepare_string( $t_filter_member ) . '|%' ); break; default: $t_custom_where_clause .= "$t_table_name.value = '" . db_prepare_string( $t_filter_member ) . "'"; } } } 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; ?>"> <table class="width100" cellspacing="1"> <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 ?>" /> <?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""> </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" colspan="5"> </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( sprintf( config_get( 'create_short_url' ), 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; } $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>'; } ?> <?php 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"> <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' ) ?> </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_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; } ?> | ||||
I could reproduce the issue. This patch should sove it. I will add a modified version of the filer_api when I'm back in office on wednesday. Regards, |
|
Hello Ellerbrok, Is this still an issue in the latest mantis 1.2.0 SVN code ? Paul |
|
This was still broken in trunk. Fixed in http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=5500. |
|
MantisBT: master c6bc0074 2008-08-06 00:34 Details Diff |
Fix for custom field sorting errors Bug 0006661 git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@5500 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9 |
Affected Issues 0006661 |
|
mod - core/filter_api.php | Diff File |