Sha256: 8d33786dabbfe474532579d046e3d91930efebf6bbcadbc015061688531c14a8
Contents?: true
Size: 1.98 KB
Versions: 12
Compression:
Stored size: 1.98 KB
Contents
module ActiveRecordExtras
module Relation
extend ActiveSupport::Concern
module ClassMethods
def update_or_create(attributes = {})
assign_or_new(attributes).save
end
def update_or_create!(attributes = {})
assign_or_new(attributes).save!
end
def assign_or_new(attributes)
obj = first || new
obj.assign_attributes(attributes)
obj
end
end
end
end
ActiveRecord::Associations::CollectionProxy.class_eval do
# order a collection by custom fields
# Arguments:
# key: (String) Custom field key
# order: (String) order direction (ASC | DESC)
# sample: CamaleonCms::Site.first.posts.sort_by_field("untitled-field-attributes", "desc")
def sort_by_field(key, order = 'ASC')
cfr_table = CamaleonCms::CustomFieldsRelationship.table_name
joins("LEFT OUTER JOIN #{cfr_table} ON #{cfr_table}.objectid = #{build.class.table_name}.id").where(
"#{cfr_table}.custom_field_slug = ? and #{cfr_table}.object_class = ?", key, build.class.name.parseCamaClass
).reorder("#{cfr_table}.value #{order}")
end
# Filter by custom field values
# Arguments:
# key: (String) Custom field key
# sample: my_posts_that_include_my_field = CamaleonCms::Site.first.posts.filter_by_field("untitled-field-attributes")
# this will return all posts of the first site that include custom field "untitled-field-attributes"
# additionally, you can add extra filter:
# my_posts_that_include_my_field
# .where("#{CamaleonCms::CustomFieldsRelationship.table_name}.value=?", "my_value_for_field")
def filter_by_field(key, args = {})
cfr_table = CamaleonCms::CustomFieldsRelationship.table_name
res = joins("LEFT OUTER JOIN #{cfr_table} ON #{cfr_table}.objectid = #{build.class.table_name}.id").where(
"#{cfr_table}.custom_field_slug = ? and #{cfr_table}.object_class = ?", key, build.class.name.parseCamaClass
)
res = res.where("#{cfr_table}.value = ?", args[:value]) if args[:value]
res
end
end
Version data entries
12 entries across 12 versions & 1 rubygems