ca56de3648
This changes the minimum supported version of PostgreSQL to 9.3.
144 lines
3.8 KiB
Ruby
144 lines
3.8 KiB
Ruby
# Copyright (C) 2012-2021 Zammad Foundation, http://zammad-foundation.org/
|
|
|
|
class SearchController < ApplicationController
|
|
prepend_before_action :authentication_check
|
|
|
|
# GET|POST /api/v1/search
|
|
# GET|POST /api/v1/search/:objects
|
|
|
|
def search_generic
|
|
# get params
|
|
query = params[:query]
|
|
if query.respond_to?(:permit!)
|
|
query = query.permit!.to_h
|
|
end
|
|
limit = params[:limit] || 10
|
|
|
|
# convert objects string into array of class names
|
|
# e.g. user-ticket-another_object = %w( User Ticket AnotherObject )
|
|
objects = if params[:objects]
|
|
params[:objects].split('-').map(&:camelize)
|
|
else
|
|
Setting.get('models_searchable')
|
|
end
|
|
|
|
# get priorities of result
|
|
objects_in_order = []
|
|
objects_in_order_hash = {}
|
|
objects.each do |object|
|
|
local_class = object.constantize
|
|
preferences = local_class.search_preferences(current_user)
|
|
next if !preferences
|
|
|
|
objects_in_order_hash[preferences[:prio]] = local_class
|
|
end
|
|
objects_in_order_hash.keys.sort.reverse_each do |prio|
|
|
objects_in_order.push objects_in_order_hash[prio]
|
|
end
|
|
|
|
generic_search_params = {
|
|
query: query,
|
|
limit: limit,
|
|
current_user: current_user,
|
|
}
|
|
|
|
# try search index backend
|
|
assets = {}
|
|
result = []
|
|
if SearchIndexBackend.enabled?
|
|
|
|
# get direct search index based objects
|
|
objects_with_direct_search_index = []
|
|
objects_without_direct_search_index = []
|
|
objects.each do |object|
|
|
preferences = object.constantize.search_preferences(current_user)
|
|
next if !preferences
|
|
|
|
if preferences[:direct_search_index]
|
|
objects_with_direct_search_index.push object
|
|
else
|
|
objects_without_direct_search_index.push object
|
|
end
|
|
end
|
|
|
|
# do only one query to index search backend
|
|
if objects_with_direct_search_index.present?
|
|
items = SearchIndexBackend.search(query, objects_with_direct_search_index, limit: limit)
|
|
items.each do |item|
|
|
local_class = item[:type].constantize
|
|
record = local_class.lookup(id: item[:id])
|
|
next if !record
|
|
|
|
assets = record.assets(assets)
|
|
item[:type] = local_class.to_app_model.to_s
|
|
result.push item
|
|
end
|
|
end
|
|
|
|
# e. g. do ticket query by Ticket class to handle ticket permissions
|
|
objects_without_direct_search_index.each do |object|
|
|
object_result = search_generic_backend(object.constantize, assets, generic_search_params)
|
|
if object_result.present?
|
|
result.concat(object_result)
|
|
end
|
|
end
|
|
|
|
# sort order by object priority
|
|
result_in_order = []
|
|
objects_in_order.each do |object|
|
|
result.each do |item|
|
|
next if item[:type] != object.to_app_model.to_s
|
|
|
|
item[:id] = item[:id].to_i
|
|
result_in_order.push item
|
|
end
|
|
end
|
|
result = result_in_order
|
|
|
|
else
|
|
|
|
# do query
|
|
objects_in_order.each do |object|
|
|
object_result = search_generic_backend(object, assets, generic_search_params)
|
|
if object_result.present?
|
|
result.concat(object_result)
|
|
end
|
|
end
|
|
end
|
|
|
|
render json: {
|
|
assets: assets,
|
|
result: result,
|
|
}
|
|
end
|
|
|
|
private
|
|
|
|
=begin
|
|
|
|
search generic backend
|
|
|
|
SearchController#search_generic_backend(
|
|
Ticket, # object
|
|
{}, # assets
|
|
query: "search query",
|
|
limit: 10,
|
|
current_user: user,
|
|
)
|
|
|
|
=end
|
|
|
|
def search_generic_backend(object, assets, params)
|
|
found_objects = object.search(params)
|
|
result = []
|
|
found_objects.each do |found_object|
|
|
item = {
|
|
id: found_object.id,
|
|
type: found_object.class.to_app_model.to_s
|
|
}
|
|
result.push item
|
|
assets = found_object.assets(assets)
|
|
end
|
|
result
|
|
end
|
|
end
|