diff options
Diffstat (limited to 'web/lib/api/v4/tag.rb')
| -rw-r--r-- | web/lib/api/v4/tag.rb | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/web/lib/api/v4/tag.rb b/web/lib/api/v4/tag.rb index d46f03c..b6fdbbe 100644 --- a/web/lib/api/v4/tag.rb +++ b/web/lib/api/v4/tag.rb @@ -256,6 +256,12 @@ class Taginfo < Sinatra::Base :query => 'Only show results where the value matches this query (substring match, optional).' }, :paging => :optional, + :filter => { + :all => { :doc => 'No filter.' }, + :nodes => { :doc => 'Only values on tags used on nodes.' }, + :ways => { :doc => 'Only values on tags used on ways.' }, + :relations => { :doc => 'Only values on tags used on relations.' } + }, :sort => %w( project_name tag ), :result => paging_results([ [:project_id, :STRING, 'Project ID'], @@ -276,17 +282,25 @@ class Taginfo < Sinatra::Base }) do key = params[:key] value = params[:value] + filter_type = get_filter() q = like_contains(params[:query]) + total = @db.select('SELECT count(distinct project_id) FROM projects.projects p, projects.project_tags t ON p.id=t.project_id'). condition("status = 'OK'"). condition('key = ?', key). condition('value = ? OR VALUE IS NULL', value). condition_if("value LIKE ? ESCAPE '@' OR name LIKE ? ESCAPE '@'", q, q). + condition_if("on_node = ?", filter_type == 'nodes' ? 1 : ''). + condition_if("on_way = ? OR on_area = 1", filter_type == 'ways' ? 1 : ''). + condition_if("on_relation = ? OR on_area = 1", filter_type == 'relations' ? 1 : ''). get_first_value().to_i res = @db.select("SELECT p.name, p.icon_url AS project_icon_url, t.* FROM (SELECT project_id, key, MAX(value) AS value FROM projects.project_tags WHERE key=? AND (value=? OR value IS NULL) GROUP BY project_id, key) AS s JOIN projects.project_tags t JOIN projects.projects p ON p.id=t.project_id AND t.project_id=s.project_id AND t.key=s.key AND (t.value=s.value OR (t.value IS NULL AND s.value IS NULL))", key, value). condition("p.status = 'OK'"). condition_if("value LIKE ? ESCAPE '@' OR name LIKE ? ESCAPE '@'", q, q). + condition_if("on_node = ?", filter_type == 'nodes' ? 1 : ''). + condition_if("on_way = ? OR on_area = 1", filter_type == 'ways' ? 1 : ''). + condition_if("on_relation = ? OR on_area = 1", filter_type == 'relations' ? 1 : ''). order_by(@ap.sortname, @ap.sortorder) { |o| o.project_name 'lower(p.name)' o.project_name :value |