39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
# File 'lib/app/models/geo_code_curacao.rb', line 39
def self.lookup(term)
street = term.gsub(/\\/, '\&\&').gsub(/'/, "''")
sql = "select CONCAT( CONCAT_WS( ', ', S.NAME, B.NAME, Z.NAME), ' (', LPAD( S.ZONECODE, 2, '0' ), LPAD( S.NBRHCODE, 2, '0' ), LPAD( S.STREETCODE, 2, '0' ), ')' )
FROM Straatcode S, Buurten B, Zones Z
WHERE
B.RECORDTYPE='NBRHOOD'
AND S.ZONECODE=Z.ZONECODE
AND B.ZONECODE=Z.ZONECODE
AND S.ZONECODE=B.ZONECODE
AND S.NBRHCODE = B.NBRHCODE
AND S.NAME LIKE '#{street}'
ORDER BY S.NAME"
q = []
ActiveRecord::Base.connection.execute(sql).to_a.each do |r|
q << { :label => r[0] }
end
q.to_json.html_safe
end
|