66
67
68
69
70
71
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
124
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
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
|
# File 'lib/localizable_db/localizable.rb', line 66
def localize(*localizable_attributes)
localizable_attributes.flatten!
singularized_model_name = self.name.downcase.singularize.dasherize
class_eval %Q{
default_scope { localize_eager_load }
default_scope { with_languages_eager_load }
attr_accessor :languages, :_locale, :destroying_languages
after_save :save_languages
before_destroy do
if self.class.table_name != self.class.localized_table_name
self.destroying_languages = true
self.class.table_name = self.class.localized_table_name
self.class.where(localizable_object_id: self.id).destroy_all
self.class.table_name = self.class.name.pluralize.dasherize
end
ensure
self.class.table_name = self.class.name.pluralize.dasherize.downcase if self.destroying_languages
self.destroying_languages = false if self.destroying_languages
end
def set_languages(languages = {})
self.languages = languages
end
private
def self.localized_table_name
"#{singularized_model_name}_languages".freeze
end
def self.localized_attributes
#{localizable_attributes}.map{|a| a.to_s}.freeze
end
def self.get_locale
I18n.locale
end
}
class << self
def localized(language = nil)
if defined? LocalizableDb::Localizable and
(self.get_locale != I18n.default_locale or
(language and language != I18n.default_locale))
language = self.get_locale unless language
raise "The locale :#{language} is not defined in the initialization file, please check config/initializers/localizable_db.rb to add it." if !LocalizableDb::Languages::SUPPORTED.include? language
attrs_to_select = ""
self.attribute_names.each do |attribute|
attrs_to_select += "#{self.table_name}.#{attribute}"
attrs_to_select += ", " if attribute != self.attribute_names.last
end
self.localized_attributes.each do |a|
attrs_to_select += ", " if a == self.localized_attributes.first
attrs_to_select += "#{self.localized_table_name}.#{a} as #{a}"
attrs_to_select += ", " if a != self.localized_attributes.last
end
aux_select_values = joins("
JOIN #{self.localized_table_name}
ON locale = '#{language.to_s}'
AND #{self.table_name}.id = #{self.localized_table_name}.localizable_object_id
").select_values.map{|select_value| select_value.to_s }.join(' ')
localized_chain = (aux_select_values.scan(/#{self.localized_table_name}/).any? ? true : false)
result = joins("
JOIN #{self.localized_table_name}
ON locale = '#{language.to_s}'
AND #{self.table_name}.id = #{self.localized_table_name}.localizable_object_id
").select(attrs_to_select) if !localized_chain
result = unscope(:joins, :select).joins("
JOIN #{self.localized_table_name}
ON locale = '#{language.to_s}'
AND #{self.table_name}.id = #{self.localized_table_name}.localizable_object_id
").select(attrs_to_select) if localized_chain
if block_given?
ActiveRecord::Base._localized_eager_load = true
result = yield(result).reload
ActiveRecord::Base._localized_eager_load = false
end
result
else
return where(id: nil).unscope(where: :id)
end
ensure
ActiveRecord::Base._localized_eager_load = false
end
def with_languages(*with_languages)
with_languages.flatten!
with_languages = with_languages - [LocalizableDb::Languages::DEFAULT] if with_languages.any?
with_languages = (LocalizableDb::Languages::SUPPORTED - [LocalizableDb::Languages::DEFAULT]) if with_languages.empty?
attrs_to_select = "#{self.table_name}.*, "
tables_to_select = "#{self.table_name}, "
conditions_to_select = ""
with_languages.each do |language|
self.localized_attributes.each do |localized_attribute|
attrs_to_select += "#{language.to_s}_#{self.localized_table_name}.#{localized_attribute} as #{language.to_s}_#{localized_attribute}"
conditions_to_select += "#{language.to_s}_#{self.localized_table_name}.locale = '#{language.to_s}' AND "
conditions_to_select += "#{language.to_s}_#{self.localized_table_name}.localizable_object_id = #{self.table_name}.id "
attrs_to_select += ", " if localized_attribute != self.localized_attributes.last
conditions_to_select += "AND " if language != with_languages.last or localized_attribute != self.localized_attributes.last
end
tables_to_select += "#{self.localized_table_name} as #{language.to_s}_#{self.localized_table_name}"
attrs_to_select += ", " if language != with_languages.last
tables_to_select += ", " if language != with_languages.last
end
result = unscope(:joins).unscope(:select)
.select(attrs_to_select)
.from(tables_to_select)
.where(conditions_to_select)
if block_given?
ActiveRecord::Base._with_languages_eager_load = true
result = yield(result).reload
ActiveRecord::Base._with_languages_eager_load = false
end
result
ensure
ActiveRecord::Base._with_languages_eager_load = false
end
alias_method :l, :localized
alias_method :localized, :l
alias_method :wl, :with_languages
alias_method :with_languages, :wl
def localize_eager_load(language = nil)
if ActiveRecord::Base._localized_eager_load
l(language)
else
ActiveRecord::Relation.new(self, self.table_name,self.predicate_builder)
end
end
def with_languages_eager_load(with_languages = [])
if ActiveRecord::Base._with_languages_eager_load
wl(with_languages)
else
ActiveRecord::Relation.new(self, self.table_name,self.predicate_builder)
end
end
end
end
|