X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/1c59d4a776c6dacb472889a3c68b374697b4cb4b..083500f056f5b995f1979f88b37793046d9e4d37:/app/controllers/notes_controller.rb?ds=sidebyside diff --git a/app/controllers/notes_controller.rb b/app/controllers/notes_controller.rb index fc7a9e3c7..ba2df3680 100644 --- a/app/controllers/notes_controller.rb +++ b/app/controllers/notes_controller.rb @@ -255,15 +255,48 @@ class NotesController < ApplicationController ## # Return a list of notes matching a given string def search - # Check the arguments are sane - raise OSM::APIBadUserInput, "No query string was given" unless params[:q] + # Filter either by the name or the id of the user + if params[:display_name] + @user = User.find_by(:display_name => params[:display_name]) + elsif params[:id] + @user = User.find_by(:id => params[:id]) + end - # Get any conditions that need to be applied - @notes = closed_condition(Note.all) - @notes = @notes.joins(:comments).where("to_tsvector('english', note_comments.body) @@ plainto_tsquery('english', ?)", params[:q]) + if @user + @notes = @user.notes + @notes = closed_condition(@notes) + elsif params[:display_name] || params[:id] + # Return an error message because obviously the user could not be found + raise OSM::APIBadUserInput, "The user could not be found" + else + @notes = closed_condition(Note.all) + end + + # Filter by a given string + if params[:q] + # TODO: why doesn't this work if we want to filter the notes of a given user? + @notes = @notes.joins(:comments).where("to_tsvector('english', note_comments.body) @@ plainto_tsquery('english', ?)", params[:q]) unless params[:display_name] || params[:id] + end + + # Filter by a given start date and an optional end date + if params[:from] + begin + from = Time.parse(params[:from]) + to = if params[:to] + Time.parse(params[:to]) + else + Time.now + end + rescue ArgumentError + # return a more generic error so that everybody knows what is wrong + raise OSM::APIBadUserInput, "The date is in a wrong format" + end + + @notes = @notes.where("(created_at > '#{from}' AND created_at < '#{to}')") + end # Find the notes we want to return - @notes = @notes.order("updated_at DESC").limit(result_limit).preload(:comments) + @notes = @notes.order("updated_at DESC").distinct.limit(result_limit).preload(:comments) # Render the result respond_to do |format|