From aef5273e952b814e171beab7c7d6ee09637350fb Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 11 Oct 2018 18:32:31 +0100 Subject: [PATCH 1/1] Tidy up notes#search --- app/controllers/notes_controller.rb | 30 +++++++++++++++++------------ 1 file changed, 18 insertions(+), 12 deletions(-) diff --git a/app/controllers/notes_controller.rb b/app/controllers/notes_controller.rb index 2fb9f8267..95566a1a1 100644 --- a/app/controllers/notes_controller.rb +++ b/app/controllers/notes_controller.rb @@ -255,23 +255,28 @@ class NotesController < ApplicationController ## # Return a list of notes matching a given string def search - # Filter either by the name or the id of the user - if params[:display_name] - @user = User.find_by(:display_name => params[:display_name]) - raise OSM::APIBadUserInput, "User #{params[:display_name]} not known" unless @user - elsif params[:user] - @user = User.find_by(:id => params[:user]) - raise OSM::APIBadUserInput, "User #{params[:user]} not known" unless @user - end - + # Get the initial set of notes @notes = closed_condition(Note.all) - @notes = @notes.joins(:comments).where(:note_comments => { :author_id => @user }) if @user + # Add any user filter + if params[:display_name] || params[:user] + if params[:display_name] + @user = User.find_by(:display_name => params[:display_name]) + + raise OSM::APIBadUserInput, "User #{params[:display_name]} not known" unless @user + else + @user = User.find_by(:id => params[:user]) + + raise OSM::APIBadUserInput, "User #{params[:user]} not known" unless @user + end - # Filter by a given string + @notes = @notes.joins(:comments).where(:note_comments => { :author_id => @user }) + end + + # Add any text filter @notes = @notes.joins(:comments).where("to_tsvector('english', note_comments.body) @@ plainto_tsquery('english', ?)", params[:q]) if params[:q] - # Filter by a given start date and an optional end date + # Add any date filter if params[:from] begin from = Time.parse(params[:from]) @@ -288,6 +293,7 @@ class NotesController < ApplicationController rescue ArgumentError raise OSM::APIBadUserInput, "Date #{params[:to]} is in a wrong format" end + @notes = @notes.where(:created_at => from..to) end -- 2.43.2