From af2c6fd85e13139be3e3b2329a51c3a35acb3c40 Mon Sep 17 00:00:00 2001 From: erdgeist Date: Wed, 5 Aug 2026 23:56:56 +0200 Subject: Search assets and events, and order events by when they happen --- app/models/asset.rb | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'app/models/asset.rb') diff --git a/app/models/asset.rb b/app/models/asset.rb index b256b929..4d43b18f 100644 --- a/app/models/asset.rb +++ b/app/models/asset.rb @@ -82,4 +82,18 @@ class Asset < ApplicationRecord destroy! end end + + def self.editor_search(term) + words = term.to_s.split(/\s+/).reject(&:blank?) + return none if words.empty? + + words.inject(all) do |scope, word| + like = "%#{sanitize_sql_like(word)}%" + scope.where( + "assets.name ILIKE :t OR assets.creator ILIKE :t OR " \ + "assets.upload_file_name ILIKE :t OR assets.source_url ILIKE :t OR " \ + "assets.upload_content_type ILIKE :t", :t => like + ) + end + end end -- cgit v1.3