Class: ForestLiana::OperatorDateIntervalParser
- Inherits:
-
Object
- Object
- ForestLiana::OperatorDateIntervalParser
- Defined in:
- app/services/forest_liana/operator_date_interval_parser.rb
Constant Summary collapse
- PERIODS =
{ :$yesterday => { duration: 1, period: 'day' }, :$previousWeek => { duration: 1, period: 'week' }, :$previousMonth => { duration: 1, period: 'month' }, :$previousQuarter => { duration: 3, period: 'month', period_of_time: 'quarter' }, :$previousYear => { duration: 1, period: 'year' }, :$weekToDate => { duration: 1, period: 'week', to_date: true }, :$monthToDate => { duration: 1, period: 'month', to_date: true }, :$quarterToDate => { duration: 3, period: 'month', period_of_time: 'quarter', to_date: true }, :$yearToDate => { duration: 1, period: 'year', to_date: true } }
- PERIODS_PAST =
'$past'
- PERIODS_FUTURE =
'$future'
- PERIODS_TODAY =
'$today'
- PERIODS_PREVIOUS_X_DAYS =
/^\$previous(\d+)Days$/
- PERIODS_X_DAYS_TO_DATE =
/^\$(\d+)DaysToDate$/
- PERIODS_X_HOURS_BEFORE =
/^\$(\d+)HoursBefore$/
- PERIODS_X_HOURS_AFTER =
/^\$(\d+)HoursAfter$/
Instance Method Summary collapse
- #get_interval_date_filter ⇒ Object
- #get_interval_date_filter_for_previous_interval ⇒ Object
- #has_previous_interval ⇒ Object
-
#initialize(value, timezone) ⇒ OperatorDateIntervalParser
constructor
A new instance of OperatorDateIntervalParser.
- #is_interval_date_value ⇒ Object
- #to_client_timezone(date) ⇒ Object
Constructor Details
#initialize(value, timezone) ⇒ OperatorDateIntervalParser
Returns a new instance of OperatorDateIntervalParser.
26 27 28 29 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 26 def initialize(value, timezone) @value = value @timezone_offset = Time.now.in_time_zone(timezone).utc_offset / 3600 end |
Instance Method Details
#get_interval_date_filter ⇒ Object
72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 72 def get_interval_date_filter return nil unless is_interval_date_value() return ">= '#{Time.now}'" if @value == PERIODS_FUTURE return "<= '#{Time.now}'" if @value == PERIODS_PAST if @value == PERIODS_TODAY return "BETWEEN '#{to_client_timezone(Time.now.beginning_of_day)}' " + "AND '#{to_client_timezone(Time.now.end_of_day)}'" end match = PERIODS_PREVIOUS_X_DAYS.match(@value) if match && match[1] return "BETWEEN '" + "#{to_client_timezone(Integer(match[1]).day.ago.beginning_of_day)}'" + " AND '#{to_client_timezone(1.day.ago.end_of_day)}'" end match = PERIODS_X_DAYS_TO_DATE.match(@value) if match && match[1] return "BETWEEN '" + "#{to_client_timezone((Integer(match[1]) - 1).day.ago.beginning_of_day)}'" + " AND '#{Time.now}'" end match = PERIODS_X_HOURS_BEFORE.match(@value) if match && match[1] return "< '#{to_client_timezone((Integer(match[1])).hour.ago)}'" end match = PERIODS_X_HOURS_AFTER.match(@value) if match && match[1] return "> '#{to_client_timezone((Integer(match[1])).hour.ago)}'" end duration = PERIODS[@value.to_sym][:duration] period = PERIODS[@value.to_sym][:period] period_of_time = PERIODS[@value.to_sym][:period_of_time] || PERIODS[@value.to_sym][:period] to_date = PERIODS[@value.to_sym][:to_date] if to_date from = to_client_timezone(Time.now.send("beginning_of_#{period_of_time}")) to = Time.now else from = to_client_timezone(duration.send(period).ago .send("beginning_of_#{period_of_time}")) to = to_client_timezone(1.send(period).ago .send("end_of_#{period_of_time}")) end "BETWEEN '#{from}' AND '#{to}'" end |
#get_interval_date_filter_for_previous_interval ⇒ Object
125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 125 def get_interval_date_filter_for_previous_interval return nil unless has_previous_interval() if @value == PERIODS_TODAY return "BETWEEN '#{to_client_timezone(1.day.ago.beginning_of_day)}' AND " + "'#{to_client_timezone(1.day.ago.end_of_day)}'" end match = PERIODS_PREVIOUS_X_DAYS.match(@value) if match && match[1] return "BETWEEN '" + "#{to_client_timezone((Integer(match[1]) * 2).day.ago.beginning_of_day)}'" + " AND '#{to_client_timezone((Integer(match[1]) + 1).day.ago.end_of_day)}'" end match = PERIODS_X_DAYS_TO_DATE.match(@value) if match && match[1] return "BETWEEN '" + "#{to_client_timezone(((Integer(match[1]) * 2) - 1).day.ago.beginning_of_day)}'" + " AND '#{to_client_timezone(Integer(match[1]).day.ago)}'" end duration = PERIODS[@value.to_sym][:duration] period = PERIODS[@value.to_sym][:period] period_of_time = PERIODS[@value.to_sym][:period_of_time] || PERIODS[@value.to_sym][:period] to_date = PERIODS[@value.to_sym][:to_date] if to_date from = to_client_timezone((duration).send(period).ago .send("beginning_of_#{period_of_time}")) to = to_client_timezone((duration).send(period).ago) else from = to_client_timezone((duration * 2).send(period).ago .send("beginning_of_#{period_of_time}")) to = to_client_timezone((1 + duration).send(period).ago .send("end_of_#{period_of_time}")) end "BETWEEN '#{from}' AND '#{to}'" end |
#has_previous_interval ⇒ Object
52 53 54 55 56 57 58 59 60 61 62 63 64 65 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 52 def has_previous_interval return false if @value.nil? return true if PERIODS[@value.to_sym] return true if PERIODS_TODAY == @value match = PERIODS_PREVIOUS_X_DAYS.match(@value) return true if match && match[1] match = PERIODS_X_DAYS_TO_DATE.match(@value) return true if match && match[1] false end |
#is_interval_date_value ⇒ Object
31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 31 def is_interval_date_value return false if @value.nil? return true if PERIODS[@value.to_sym] return true if [PERIODS_PAST, PERIODS_FUTURE, PERIODS_TODAY].include? @value match = PERIODS_PREVIOUS_X_DAYS.match(@value) return true if match && match[1] match = PERIODS_X_DAYS_TO_DATE.match(@value) return true if match && match[1] match = PERIODS_X_HOURS_BEFORE.match(@value) return true if match && match[1] match = PERIODS_X_HOURS_AFTER.match(@value) return true if match && match[1] false end |
#to_client_timezone(date) ⇒ Object
67 68 69 70 |
# File 'app/services/forest_liana/operator_date_interval_parser.rb', line 67 def to_client_timezone(date) # NOTICE: By default, Rails store the dates without timestamp in the database. date - @timezone_offset.hours end |