Untitled diff
作成日 差分は期限切れになりません
5 削除
| 行 | |
|---|---|
| 合計 | |
| 削除 | |
| 文字 | |
| 合計 | |
| 削除 | |
12 追加
| 行 | |
|---|---|
| 合計 | |
| 追加 | |
| 文字 | |
| 合計 | |
| 追加 | |
def new_search_condition(column, value)
def new_search_condition(column, value)
model, column = column.split('.')
model, column, attribute = column.split('.')
model = model.constantize
model = model.constantize
casted_column = ::Arel::Nodes::NamedFunction.new('CAST', [model.arel_table[column.to_sym].as(typecast)])
if model.columns_hash[column].sql_type == 'json'
casted_column.matches("%#{sanitize_sql_like(value)}%")
Arel.sql("JSON_EXTRACT(#{column}, '$.#{attribute}')")
end
else
::Arel::Nodes::NamedFunction.new(
'CAST', [model.arel_table[column.to_sym].as(typecast)]
)
end.matches("%#{value}%")
end