This repository has been archived on 2024-12-01. You can view files and clone it, but cannot push or open issues or pull requests.
redmine_rodax_crm/lib/redmine_contacts/patches/query_patch.rb
2012-01-03 16:18:32 +00:00

75 lines
2.2 KiB
Ruby

# This file is a part of redmine_tags
# redMine plugin, that adds tagging support.
#
# Copyright (c) 2010 Aleksey V Zapparov AKA ixti
#
# redmine_tags is free software: you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation, either version 3 of the License, or
# (at your option) any later version.
#
# redmine_tags is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with redmine_tags. If not, see <http://www.gnu.org/licenses/>.
require_dependency 'query'
module RedmineTags
module Patches
module QueryPatch
def self.included(base)
base.send(:include, InstanceMethods)
base.class_eval do
unloadable
alias_method :statement_original, :statement
alias_method :statement, :statement_extended
alias_method :available_filters_original, :available_filters
alias_method :available_filters, :available_filters_extended
base.add_available_column(QueryColumn.new(:tags))
end
end
module InstanceMethods
def statement_extended
filter = filters.delete 'tags'
clauses = statement_original
if filter
filters.merge!( 'tags' => filter )
values = values_for('tags').clone
compare = operator_for('tags').eql?('=') ? 'IN' : 'NOT IN'
ids_list = Issue.tagged_with(values).collect{ |issue| issue.id }.push(0).join(',')
clauses << " AND ( #{Issue.table_name}.id #{compare} (#{ids_list}) ) "
end
clauses
end
def available_filters_extended
unless @available_filters
available_filters_original.merge!({ 'tags' => {
:type => :list,
:order => 6,
:values => Issue.available_tags(:project => project).collect{ |t| [t.name, t.name] }
}})
end
@available_filters
end
end
end
end
end