Class: Axlsx::Filters::DateGroupItem

Inherits:
Object
  • Object
show all
Includes:
OptionsParser, SerializedAttributes
Defined in:
lib/axlsx/workbook/worksheet/auto_filter/filters.rb

Overview

This collection is used to express a group of dates or times which are used in an AutoFilter criteria. Values are always written in the calendar type of the first date encountered in the filter range, so that all subsequent dates, even when formatted or represented by other calendar types, can be correctly compared for the purposes of filtering.

Constant Summary collapse

DATE_TIME_GROUPING =

Allowed date time groupings

%w(year month day hour minute second)

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from SerializedAttributes

#declared_attributes, included, #serialized_attributes, #serialized_element_attributes, #serialized_tag

Methods included from OptionsParser

#parse_options

Constructor Details

#initialize(options = {}) ⇒ DateGroupItem

Creates a new DateGroupItem instanciating the object filter should apply for grouping

Parameters:

  • options (Hash) (defaults to: {}) —

    A hash of options to use when

  • [String] (Hash) —

    a customizable set of options

  • [Integer|String] (Hash) —

    a customizable set of options

  • [Integer] (Hash) —

    a customizable set of options

Raises:

  • (ArgumentError) 


146
147
148
149
150
151
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 146

def initialize(options = {})
  raise ArgumentError, "You must specify a year for date time grouping" unless options[:year]
  raise ArgumentError, "You must specify a date_time_grouping when creating a DateGroupItem for auto filter" unless options[:date_time_grouping]

  parse_options options
end

Instance Attribute Details

#date_time_grouping ⇒ String

Grouping level This must be one of year, month, day, hour, minute or second.

Returns:

  • (String) 


161
162
163
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 161

def date_time_grouping
  @date_time_grouping
end

#day ⇒ Integer

Day (1-31)

Returns:

  • (Integer) 


173
174
175
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 173

def day
  @day
end

#hour ⇒ Integer

Hour (0..23)

Returns:

  • (Integer) 


177
178
179
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 177

def hour
  @hour
end

#minute ⇒ Integer

Minute (0..59(

Returns:

  • (Integer) 


181
182
183
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 181

def minute
  @minute
end

#month ⇒ Integer

Month (1..12)

Returns:

  • (Integer) 


169
170
171
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 169

def month
  @month
end

#second ⇒ Integer

Second (0..59)

Returns:

  • (Integer) 


185
186
187
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 185

def second
  @second
end

#year ⇒ Integer|String

Year (4 digits)

Returns:

  • (Integer|String) 


165
166
167
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 165

def year
  @year
end

Instance Method Details

#to_xml_string(str = '') ⇒ Object

Serialize the object to xml

Parameters:

  • str (String) (defaults to: '') —

    The string object this serialization will be concatenated to.



238
239
240
 
# File 'lib/axlsx/workbook/worksheet/auto_filter/filters.rb', line 238

def to_xml_string(str = '')
  serialized_tag('dateGroupItem', str)
end