liquid_feedback_frontend
annotate app/main/api/suggestion.lua @ 145:90520c9fca44
implement area filter in timeline
allows the user to ignore any area in the timeline filter.
better display in javascript off
allows the user to ignore any area in the timeline filter.
better display in javascript off
| author | Daniel Poelzleithner <poelzi@poelzi.org> |
|---|---|
| date | Thu Oct 07 00:35:48 2010 +0200 (2010-10-07) |
| parents | a33abf457d29 |
| children | ff6162022615 |
| rev | line source |
|---|---|
| bsw@95 | 1 local id = param.get("id") |
| bsw@95 | 2 local min_id = param.get("min_id") |
| bsw@95 | 3 local max_id = param.get("max_id") |
| bsw@95 | 4 local initiative_id = param.get("initiative_id") |
| bsw@95 | 5 local order = param.get("order") |
| bsw@95 | 6 local limit = param.get("limit", atom.integer) |
| bsw@95 | 7 |
| bsw@95 | 8 local suggestions_selector = Suggestion:new_selector() |
| bsw@95 | 9 |
| bsw@95 | 10 if id then |
| bsw@95 | 11 suggestions_selector:add_where{"suggestion.id = ?", id} |
| bsw@95 | 12 end |
| bsw@95 | 13 |
| bsw@95 | 14 if min_id then |
| bsw@95 | 15 suggestions_selector:add_where{"suggestion.id >= ?", min_id} |
| bsw@95 | 16 end |
| bsw@95 | 17 |
| bsw@95 | 18 if max_id then |
| bsw@95 | 19 suggestions_selector:add_where{"suggestion.id <= ?", max_id} |
| bsw@95 | 20 end |
| bsw@95 | 21 |
| poelzi@143 | 22 if initiative_id then |
| poelzi@143 | 23 suggestions_selector:add_where{"suggestion.initiative_id = ?", initiative_id} |
| poelzi@143 | 24 end |
| poelzi@143 | 25 |
| bsw@95 | 26 if order == "id_desc" then |
| bsw@95 | 27 suggestions_selector:add_order_by("suggestion.id DESC") |
| bsw@95 | 28 else |
| bsw@95 | 29 suggestions_selector:add_order_by("suggestion.id") |
| bsw@95 | 30 end |
| bsw@95 | 31 |
| bsw@95 | 32 if limit then |
| bsw@95 | 33 suggestions_selector:limit(limit) |
| bsw@95 | 34 end |
| bsw@95 | 35 |
| bsw@95 | 36 local api_engine = param.get("api_engine") or "xml" |
| bsw@95 | 37 |
| bsw@95 | 38 local fields = { |
| bsw@95 | 39 |
| bsw@95 | 40 { name = "id", field = "suggestion.id" }, |
| bsw@95 | 41 { name = "initiative_id", field = "suggestion.initiative_id" }, |
| bsw@95 | 42 { name = "name", field = "suggestion.name" }, |
| bsw@95 | 43 { name = "description", field = "suggestion.description" }, |
| bsw@95 | 44 { name = "minus2_unfulfilled_count", field = "suggestion.minus2_unfulfilled_count" }, |
| bsw@95 | 45 { name = "minus2_fulfilled_count", field = "suggestion.minus2_fulfilled_count" }, |
| bsw@95 | 46 { name = "minus1_unfulfilled_count", field = "suggestion.minus1_unfulfilled_count" }, |
| bsw@95 | 47 { name = "minus1_fulfilled_count", field = "suggestion.minus1_fulfilled_count" }, |
| bsw@95 | 48 { name = "plus1_unfulfilled_count", field = "suggestion.plus1_unfulfilled_count" }, |
| bsw@95 | 49 { name = "plus1_fulfilled_count", field = "suggestion.plus1_fulfilled_count" }, |
| bsw@95 | 50 { name = "plus2_unfulfilled_count", field = "suggestion.plus2_unfulfilled_count" }, |
| bsw@95 | 51 { name = "plus2_fulfilled_count", field = "suggestion.plus2_fulfilled_count" }, |
| bsw@95 | 52 |
| bsw@95 | 53 } |
| bsw@95 | 54 |
| bsw@95 | 55 util.autoapi{ |
| bsw@95 | 56 relation_name = "suggestion", |
| bsw@95 | 57 selector = suggestions_selector, |
| bsw@95 | 58 fields = fields, |
| bsw@95 | 59 api_engine = api_engine |
| bsw@95 | 60 } |