Class: ArBigTable

Inherits:
ApplicationRecord
  • Object
show all
Defined in:
app/models/ar_big_table.rb

Overview

Schema information

Table name: ar_big_table : Big Table

id Integer id created_at Time created_at updated_at Time updated_at key String Key (ident) used to retrieve key/values description String description site_id Integer Data will be used only for defined site. If empty, then it is default for all sites in database. active Boolean This key is active created_by Integer created_by updated_by Integer updated_by ar_big_table_values Embedded: ArBigTableValue Values defined by this key

Big table is meant to be a common space for defining default choices for select fields on forms. Documents are organized as key-value pair with the difference that values for the key can be defined for each site and can also be localized.

Usage (as used in forms):

In the example administrator may help user by providing values that can be used on ArAd document position field by defining them in ads-position key of big table. Example is from ar_ads.yml form.

10:
 name: position
 type: text_with_select
 eval: ar_big_table 'ads-positions'
 size: 20

Class Method Summary collapse

Class Method Details

.choices_for(key, site = nil, locale = nil) ⇒ Object

Will return possible choices for specified key prepared for usage in select input field.



67
68
69
70
71
72
73
74
75
76
77
78
79
80
 
# File 'app/models/ar_big_table.rb', line 67

def self.choices_for(key, site = nil, locale = nil)
  result = []
  data = find_by(key: key, site_id: site)
  data ||= find_by(key: key, site_id: nil) if site
  if data
    data.ar_big_table_values.order(description: 'asc').each do |one_value|
      next unless one_value.active

      description = one_value.get_localized_description(locale)
      result << [description, one_value.value]
    end
  end
  result.empty? ? [nil] : result
end