Class: Mensa::Filter

Inherits:
Object
  • Object
show all
Includes:
ConfigReaders
Defined in:
app/tables/mensa/filter.rb

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(column:, config:, table:) ⇒ Filter

Returns a new instance of Filter.



35
36
37
38
39
 
# File 'app/tables/mensa/filter.rb', line 35

def initialize(column:, config:, table:)
  @column = column
  @config = self.class.definition.merge(config || {})
  @table = table
end

Instance Attribute Details

#column ⇒ Object (readonly)

Returns the value of attribute column.



9
10
11
 
# File 'app/tables/mensa/filter.rb', line 9

def column
  @column
end

#table ⇒ Object (readonly)

Returns the value of attribute table.



9
10
11
 
# File 'app/tables/mensa/filter.rb', line 9

def table
  @table
end

Class Method Details

.OPERATORS ⇒ Object 



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
# File 'app/tables/mensa/filter.rb', line 18

def OPERATORS
  [
    [:is, I18n.t("mensa.operators.is"), true],
    [:isnt, I18n.t("mensa.operators.isnt"), true],
    [:matches, I18n.t("mensa.operators.matches"), true],
    [:does_not_match, I18n.t("mensa.operators.does_not_match"), true],
    [:gt, I18n.t("mensa.operators.gt"), true],
    [:gteq, I18n.t("mensa.operators.gteq"), true],
    [:lt, I18n.t("mensa.operators.lt"), true],
    [:lteq, I18n.t("mensa.operators.lteq"), true],
    [:is_current, I18n.t("mensa.operators.is_current"), false],
    [:is_empty, I18n.t("mensa.operators.is_empty"), false],
    [:isnt_empty, I18n.t("mensa.operators.isnt_empty"), false]
  ].freeze
end

Instance Method Details

#as ⇒ Object

This defines how the filter should be displayed in the value popover :select => as a select input :checkbox => as a checkbox input :string => as a text input



59
60
61
 
# File 'app/tables/mensa/filter.rb', line 59

def as
  config[:as]
end

#collection ⇒ Object 



45
46
47
48
49
50
51
52
53
 
# File 'app/tables/mensa/filter.rb', line 45

def collection
  return unless config&.key?(:collection)

  if config[:collection].is_a? Proc
    table.original_view_context.instance_exec(&config[:collection])
  else
    config[:collection]
  end
end

#filter_scope(record_scope) ⇒ Object 



79
80
81
82
83
84
85
86
87
 
# File 'app/tables/mensa/filter.rb', line 79

def filter_scope(record_scope)
  if scope
    record_scope.instance_exec(normalize(value), &scope)
  else
    query, hash = query_and_hash_for_operator
    record_scope = (column.filter.having? ? record_scope.having(query, hash) : record_scope.where(query, hash)) if query.present?
    record_scope
  end
end

#formatted_value ⇒ Object 



69
70
71
72
73
74
75
76
77
 
# File 'app/tables/mensa/filter.rb', line 69

def formatted_value
  options = collection_options

  if value.is_a?(Array)
    value.map { |entry| label_for_value(entry, options) }.join(", ")
  else
    label_for_value(value, options)
  end
end

#input_type ⇒ Object 



147
148
149
150
151
152
153
154
155
156
157
158
 
# File 'app/tables/mensa/filter.rb', line 147

def input_type
  case column.type
  when :integer
    "number"
  when :date
    "date"
  when :datetime
    "datetime-local"
  else
    "text"
  end
end

#multiple? ⇒ Boolean

Returns:

  • (Boolean) 


41
42
43
 
# File 'app/tables/mensa/filter.rb', line 41

def multiple?
  !!multiple
end

#operator_label ⇒ Object 



139
140
141
 
# File 'app/tables/mensa/filter.rb', line 139

def operator_label
  Mensa::Filter.OPERATORS.find { |op| op[0] == operator }[1]
end

#operator_with_value? ⇒ Boolean

Returns:

  • (Boolean) 


143
144
145
 
# File 'app/tables/mensa/filter.rb', line 143

def operator_with_value?
  Mensa::Filter.OPERATORS.find { |op| op[0] == operator }[2]
end

#operators ⇒ Object 



89
90
91
92
93
94
95
96
97
98
99
100
101
 
# File 'app/tables/mensa/filter.rb', line 89

def operators
  operators = Mensa::Filter.OPERATORS.dup
  if config[:operators].present?
    operators = operators.select { |op| config[:operators].include?(op[0]) }
  else
    operators.delete_if { |op| op[0] == :is_current } unless Current.method_defined?(column.name, false)
    operators.delete_if { |op| [:matches, :does_not_match].include?(op[0]) } if collection.present?
    operators.delete_if { |op| [:matches, :does_not_match].include?(op[0]) } if column.type == :integer || column.type == :date || column.type == :datetime
    operators.delete_if { |op| [:is, :isnt].include?(op[0]) } if column.type == :date || column.type == :datetime
    operators.delete_if { |op| [:gt, :lt, :gteq, :lteq].include?(op[0]) } if column.type == :string || column.type.blank?
  end
  operators
end

#query_and_hash_for_operator ⇒ Object

Used in the where clause



104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
 
# File 'app/tables/mensa/filter.rb', line 104

def query_and_hash_for_operator
  hash = {column: column.attribute_for_condition, value: normalize(value)}

  query = case operator
  when :is_empty
    (column.type == :string) ? ":column IS NULL OR :column = ''" : ":column IS NULL"
  when :isnt_empty
    (column.type == :string) ? ":column IS NOT NULL AND :column != ''" : ":column IS NOT NULL"
  when :is_current
    ":column = :value"
  when :matches
    ":column LIKE :value"
  when :does_not_match
    ":column NOT LIKE :value"
  when :is
    hash[:value] = value if hash[:value].is_a?(Array)
    ":column = :value"
  when :isnt
    hash[:value] = value if hash[:value].is_a?(Array)
    ":column != :value"
  when :gt
    ":column > :value"
  when :lt
    ":column < :value"
  when :gteq
    ":column >= :value"
  when :lteq
    ":column <= :value"
  else
    # Ignore unknown operators
    nil
  end
  [query, hash]
end

#to_s ⇒ Object 



63
64
65
66
67
 
# File 'app/tables/mensa/filter.rb', line 63

def to_s
  parts = [column.human_name, operator_label]
  parts << formatted_value if formatted_value.present? && operator_with_value?
  parts.join(" ")
end