Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def search
- unless params[:order]
- params[:order] = 'created_at'
- end
- cond = ["1=1"]
- if not (params[:filename] ||= nil).to_s.empty?
- cond[0] << " AND filename LIKE ?"
- cond << "%" + params[:filename] + "%"
- end
- if not (params[:created_at_min] ||= nil).to_s.empty?
- cond[0] << " AND created_at > ?"
- cond << params[:created_at_min]
- end
- if not (params[:created_at_max] ||= nil).to_s.empty?
- cond[0] << " AND created_at < ?"
- cond << params[:created_at_max]
- end
- if not (params[:location_min] ||= nil).to_s.empty? and not (params[:location_max] ||= nil).to_s.empty?
- cond[0] << " AND wgs84location && ?::box3d"
- cond << "BOX3D(" +params[:location_min] +", " + params[:location_max] +")"
- end
- @order = params[:order]
- @condition = cond
- @result_pages, @results = paginate(Image, :per_page => 5, :select => "id, filename, created_at, wgs84location", :order => params[:order] +" DESC", :conditions => cond)
- end
Add Comment
Please, Sign In to add comment