gistfile1.txt

def filter_by_auths(joins)
  return unless filtered_by_int?(:auths_in_curr_month_from) || filtered_by_int?(:auths_in_curr_month_to) ||
    filtered_by_int?(:auths_in_prev_month_from) || filtered_by_int?(:auths_in_prev_month_to)

  auth_join_conditions = {
    :auths_in_curr_month_from => " AND #{COS}.visits_in_current_month >= %{val}",
    :auths_in_curr_month_to => " AND #{COS}.visits_in_current_month <= %{val}",
    :auths_in_prev_month_from => " AND #{COS}.visits_in_prev_month >= %{val}",
    :auths_in_prev_month_to => " AND #{COS}.visits_in_prev_month <= %{val}"
  }.map! do |filter, condition|
    condition % {val: get_int_filter(filter)} if filtered_by_int?(filter)
  end.compact!

  joins << "JOIN #{COS} ON company_online_stats.company_id = companies.id " + auth_join_conditions.join(' ')
end