X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/5e407dfb34f47e6fbbbf3c11c1a8318256abb5cd..083500f056f5b995f1979f88b37793046d9e4d37:/app/controllers/notes_controller.rb diff --git a/app/controllers/notes_controller.rb b/app/controllers/notes_controller.rb index 19ff725dc..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| @@ -289,10 +322,10 @@ class NotesController < ApplicationController @notes = @notes.visible unless current_user&.moderator? @notes = @notes.order("updated_at DESC, id").distinct.offset((@page - 1) * @page_size).limit(@page_size).preload(:comments => :author).to_a else - @title = t "user.no_such_user.title" + @title = t "users.no_such_user.title" @not_found_user = params[:display_name] - render :template => "user/no_such_user", :status => :not_found + render :template => "users/no_such_user", :status => :not_found end end end