Merge remote-tracking branch 'upstream/pull/2018'

[rails.git] / app / controllers / notes_controller.rb

diff --git a/app/controllers/notes_controller.rb b/app/controllers/notes_controller.rb
index 27c3f4f83d08fcbc7ff51fe7c97ffd4e6264cfdf..95566a1a1a5ff179f1019dea52eed6d20235e8c7 100644 (file)
--- a/app/controllers/notes_controller.rb
+++ b/app/controllers/notes_controller.rb
@@ -255,52 +255,50 @@ 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])
-    elsif params[:id]
-      @user = User.find_by(:id => params[:id])
-    end
+    # Get the initial set of notes
+    @notes = closed_condition(Note.all)
 
-    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
+    # Add any user filter
+    if params[:display_name] || params[:user]
+      if params[:display_name]
+        @user = User.find_by(:display_name => params[:display_name])
 
-    # Filter by a given string
-    if params[:q]
-      @notes = @notes.joins(:comments)
-      if @user
-        @notes = @notes.where("to_tsvector('english', comments_notes.body) @@ plainto_tsquery('english', ?)", params[:q])
+        raise OSM::APIBadUserInput, "User #{params[:display_name]} not known" unless @user
       else
-        @notes = @notes.where("to_tsvector('english', note_comments.body) @@ plainto_tsquery('english', ?)", params[:q])
+        @user = User.find_by(:id => params[:user])
+
+        raise OSM::APIBadUserInput, "User #{params[:user]} not known" unless @user
       end
+
+      @notes = @notes.joins(:comments).where(:note_comments => { :author_id => @user })
     end
 
-    # Filter by a given start date and an optional end date
+    # Add any text filter
+    @notes = @notes.joins(:comments).where("to_tsvector('english', note_comments.body) @@ plainto_tsquery('english', ?)", params[:q]) if params[:q]
+
+    # Add any date filter
     if params[:from]
       begin
         from = Time.parse(params[:from])
+      rescue ArgumentError
+        raise OSM::APIBadUserInput, "Date #{params[:from]} is in a wrong format"
+      end
+
+      begin
         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"
+        raise OSM::APIBadUserInput, "Date #{params[:to]} is in a wrong format"
       end
 
-      @notes = @notes.where("(created_at > '#{from}' AND created_at < '#{to}')")
+      @notes = @notes.where(:created_at => from..to)
     end
 
     # Find the notes we want to return
-    @notes = @notes.order("updated_at DESC").distinct.limit(result_limit).preload(:comments)
+    @notes = @notes.order("updated_at DESC").limit(result_limit).preload(:comments)
 
     # Render the result
     respond_to do |format|