Guest User

Untitled

a guest
Feb 19th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.06 KB | None | 0 0
  1. def self.query(query)
  2. if @parser.nil?
  3. @parser = Searcher::Parser.new
  4. @parser.lookup(:academic_field, "academic_fields.name")
  5. @parser.lookup(:sat_1600, "(sat_1600_math_score + sat_1600_verbal_score)")
  6. @parser.lookup(:sat_2400, "(sat_2400_math_score + sat_2400_critical_reading_score + sat_2400_writing_score)")
  7. @parser.lookup(:act, "(act_english_score + act_math_score + act_reading_score + act_science_reasoning_score)")
  8. @parser.lookup(:job_type, "job_types.name")
  9. @parser.lookup(:field_of_interest, "field_of_interests.name")
  10. @parser.lookup(:location) do |value|
  11. location = PreferredLocation.find_by_name(value)
  12. tolerance = 1
  13. ["((preferred_locations.lat between ? and ?) AND (preferred_locations.lon between ? and ?))", location.lat - tolerance, location.lat + tolerance, location.lon - tolerance, location.lon + tolerance]
  14. end
  15. end
  16. self.find(:all, :conditions => @parser.parse(query), :include => [:academic_fields, {:job_types => :field_of_interest}, :preferred_locations])
  17. end
Add Comment
Please, Sign In to add comment