Guest User

Untitled

a guest
Feb 19th, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. def search
  2. unless params[:order]
  3. params[:order] = 'created_at'
  4. end
  5.  
  6. cond = ["1=1"]
  7. if not (params[:filename] ||= nil).to_s.empty?
  8. cond[0] << " AND filename LIKE ?"
  9. cond << "%" + params[:filename] + "%"
  10. end
  11. if not (params[:created_at_min] ||= nil).to_s.empty?
  12. cond[0] << " AND created_at > ?"
  13. cond << params[:created_at_min]
  14. end
  15. if not (params[:created_at_max] ||= nil).to_s.empty?
  16. cond[0] << " AND created_at < ?"
  17. cond << params[:created_at_max]
  18. end
  19. if not (params[:location_min] ||= nil).to_s.empty? and not (params[:location_max] ||= nil).to_s.empty?
  20. cond[0] << " AND wgs84location && ?::box3d"
  21. cond << "BOX3D(" +params[:location_min] +", " + params[:location_max] +")"
  22. end
  23.  
  24. @order = params[:order]
  25. @condition = cond
  26. @result_pages, @results = paginate(Image, :per_page => 5, :select => "id, filename, created_at, wgs84location", :order => params[:order] +" DESC", :conditions => cond)
  27. end
Add Comment
Please, Sign In to add comment