module Wice
module Columns #:nodoc:
class ViewColumnString < ViewColumn #:nodoc:
# whether the filter contains a negation checkbox
attr_accessor :negation
# whether the filter contains a negation checkbox and autoreloading is necessary
attr_accessor :auto_reloading_input_with_negation_checkbox
def render_filter_internal(params) #:nodoc:
@contains_a_text_input = true
css_class = 'form-control input-sm ' + (auto_reload ? 'auto-reload' : '')
if negation
self.auto_reloading_input_with_negation_checkbox = true if auto_reload
@query, _, parameter_name, @dom_id = form_parameter_name_id_and_query(v: '')
@query2, _, parameter_name2, @dom_id2 = form_parameter_name_id_and_query(n: '')
'
' +
text_field_tag(parameter_name, params[:v], size: 8, id: @dom_id, class: css_class) +
if defined?(Wice::Defaults::NEGATION_CHECKBOX_LABEL) && !Wice::ConfigurationProvider.value_for(:NEGATION_CHECKBOX_LABEL).blank?
Wice::ConfigurationProvider.value_for(:NEGATION_CHECKBOX_LABEL)
else
''
end +
check_box_tag(parameter_name2, '1', (params[:n] == '1'),
id: @dom_id2,
title: NlMessage['negation_checkbox_title'],
class: "negation-checkbox #{css_class}") +
'
'
else
@query, _, parameter_name, @dom_id = form_parameter_name_id_and_query('')
text_field_tag(parameter_name, (params.blank? ? '' : params), size: 8, id: @dom_id, class: css_class)
end
end
def yield_declaration_of_column_filter #:nodoc:
if negation
{
templates: [@query, @query2],
ids: [@dom_id, @dom_id2]
}
else
{
templates: [@query],
ids: [@dom_id]
}
end
end
def has_auto_reloading_input? #:nodoc:
auto_reload
end
def auto_reloading_input_with_negation_checkbox? #:nodoc:
self.auto_reloading_input_with_negation_checkbox
end
end
class ConditionsGeneratorColumnString < ConditionsGeneratorColumn #:nodoc:
def generate_conditions(table_alias, opts) #:nodoc:
if opts.is_a? String
string_fragment = opts
negation = ''
elsif (opts.is_a? Hash) && opts.key?(:v)
string_fragment = opts[:v]
negation = opts[:n] == '1' ? 'NOT' : ''
else
Wice.log "invalid parameters for the grid string filter - must be a string: #{opts.inspect} or a Hash with keys :v and :n"
return false
end
if string_fragment.empty?
return false
end
string_matching_operator = ::Wice.get_string_matching_operators(@column_wrapper.model)
comparator = if string_matching_operator == 'CI_LIKE'
" #{negation} UPPER(#{@column_wrapper.alias_or_table_name(table_alias)}.#{@column_wrapper.name}) LIKE UPPER(?)"
else
" #{negation} #{@column_wrapper.alias_or_table_name(table_alias)}.#{@column_wrapper.name} #{string_matching_operator} ?"
end
[ comparator, '%' + string_fragment + '%' ]
end
end
end
end