projects
/
rails.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
db13180
)
Tidy up notes#search
author
Tom Hughes
<tom@compton.nu>
Thu, 11 Oct 2018 17:32:31 +0000
(18:32 +0100)
committer
Tom Hughes
<tom@compton.nu>
Thu, 11 Oct 2018 17:32:31 +0000
(18:32 +0100)
app/controllers/notes_controller.rb
patch
|
blob
|
history
diff --git
a/app/controllers/notes_controller.rb
b/app/controllers/notes_controller.rb
index 2fb9f826777d50829931bf1a62a2d1fa8cb01bb0..95566a1a1a5ff179f1019dea52eed6d20235e8c7 100644
(file)
--- 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
##
# 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 = 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]
@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])
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
rescue ArgumentError
raise OSM::APIBadUserInput, "Date #{params[:to]} is in a wrong format"
end
+
@notes = @notes.where(:created_at => from..to)
end
@notes = @notes.where(:created_at => from..to)
end