liquid_feedback_frontend
annotate app/main/initiative/list_rss.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 | 733f65c0c0a0 |
| children |
| rev | line source |
|---|---|
| bsw/jbe@52 | 1 if not config.feature_rss_enabled then |
| bsw/jbe@52 | 2 error("feature not enabled") |
| bsw/jbe@52 | 3 end |
| bsw/jbe@52 | 4 |
| bsw/jbe@52 | 5 local area_id = param.get("area_id", atom.integer) |
| bsw/jbe@52 | 6 local issue_id = param.get("issue_id", atom.integer) |
| bsw/jbe@52 | 7 local order = param.get("order") or "last_created" |
| bsw/jbe@52 | 8 |
| bsw/jbe@52 | 9 local initiatives_selector = Initiative:new_selector() |
| bsw/jbe@52 | 10 |
| bsw/jbe@52 | 11 local issue |
| bsw/jbe@52 | 12 local area |
| bsw/jbe@52 | 13 |
| bsw/jbe@52 | 14 if issue_id then |
| bsw/jbe@52 | 15 issue = Issue:by_id(issue_id) |
| bsw/jbe@52 | 16 initiatives_selector:add_where{ "initiative.issue_id = ?", issue_id } |
| bsw/jbe@52 | 17 elseif area_id then |
| bsw/jbe@52 | 18 area = Area:by_id(area_id) |
| bsw/jbe@52 | 19 initiatives_selector:join("issue", nil, "issue.id = initiative.issue_id") |
| bsw/jbe@52 | 20 initiatives_selector:add_where{ "issue.area_id = ?", area_id } |
| bsw/jbe@52 | 21 end |
| bsw/jbe@52 | 22 |
| bsw/jbe@52 | 23 |
| bsw/jbe@52 | 24 if order == "last_created" then |
| bsw/jbe@52 | 25 initiatives_selector:add_order_by("initiative.created DESC") |
| bsw/jbe@52 | 26 initiatives_selector:add_field("initiative.created", "created_or_updated") |
| bsw/jbe@52 | 27 elseif order == "last_updated" then |
| bsw/jbe@52 | 28 initiatives_selector:add_field("(SELECT MAX(created) FROM draft WHERE initiative_id = initiative.id GROUP BY initiative_id)", "created_or_updated") |
| bsw/jbe@52 | 29 initiatives_selector:add_order_by("(SELECT MAX(created) FROM draft WHERE initiative_id = initiative.id GROUP BY initiative_id) DESC") |
| bsw/jbe@52 | 30 else |
| bsw/jbe@52 | 31 error("Invalid order") |
| bsw/jbe@52 | 32 end |
| bsw/jbe@52 | 33 |
| bsw/jbe@52 | 34 initiatives_selector:add_order_by("id DESC") |
| bsw/jbe@52 | 35 |
| bsw/jbe@52 | 36 initiatives_selector:limit(25) |
| bsw/jbe@52 | 37 |
| bsw/jbe@52 | 38 local initiatives = initiatives_selector:exec() |
| bsw/jbe@52 | 39 |
| bsw/jbe@19 | 40 slot.set_layout("atom") |
| bsw/jbe@19 | 41 request.force_absolute_baseurl() |
| bsw/jbe@19 | 42 |
| bsw/jbe@52 | 43 ui.tag{ |
| bsw/jbe@52 | 44 tag = "author", |
| bsw/jbe@52 | 45 content = function() |
| bsw/jbe@52 | 46 ui.tag{ |
| bsw/jbe@52 | 47 tag = "name", |
| bsw/jbe@52 | 48 content = "LiquidFeedback" |
| bsw/jbe@52 | 49 } |
| bsw/jbe@52 | 50 end |
| bsw/jbe@52 | 51 } |
| bsw/jbe@52 | 52 |
| bsw/jbe@52 | 53 local title |
| bsw/jbe@52 | 54 |
| bsw/jbe@52 | 55 if issue then |
| bsw/jbe@52 | 56 title = "#" .. tostring(issue.id) .. " " .. issue.area.name |
| bsw/jbe@52 | 57 elseif area then |
| bsw/jbe@52 | 58 title = area.name |
| bsw/jbe@52 | 59 else |
| bsw/jbe@52 | 60 title = config.app_title |
| bsw/jbe@52 | 61 end |
| bsw/jbe@52 | 62 |
| bsw/jbe@52 | 63 ui.tag{ |
| bsw/jbe@52 | 64 tag = "title", |
| bsw/jbe@52 | 65 content = title |
| bsw/jbe@52 | 66 } |
| bsw/jbe@52 | 67 |
| bsw/jbe@52 | 68 local subtitle |
| bsw/jbe@52 | 69 if order == "last_created" then |
| bsw/jbe@52 | 70 subtitle = "Initiatives (last created first)" |
| bsw/jbe@52 | 71 elseif order == "last_updated" then |
| bsw/jbe@52 | 72 subtitle = "Initiatives (last updated first)" |
| bsw/jbe@52 | 73 end |
| bsw/jbe@52 | 74 |
| bsw/jbe@52 | 75 ui.tag{ |
| bsw/jbe@52 | 76 tag = "subtitle", |
| bsw/jbe@52 | 77 content = subtitle |
| bsw/jbe@52 | 78 } |
| bsw/jbe@52 | 79 |
| bsw/jbe@52 | 80 ui.tag{ |
| bsw/jbe@52 | 81 tag = "id", |
| bsw@75 | 82 -- content = "urn:uuid:60a76c80-d399-11d9-b93C-0003939e0af6" |
| bsw/jbe@52 | 83 } |
| bsw/jbe@52 | 84 |
| bsw@75 | 85 --[[ |
| bsw/jbe@52 | 86 ui.tag{ |
| bsw/jbe@52 | 87 tag = "updated", |
| bsw/jbe@52 | 88 content = "2003-12-14T10:20:09Z" |
| bsw/jbe@52 | 89 } |
| bsw@75 | 90 --]] |
| bsw/jbe@19 | 91 |
| bsw/jbe@19 | 92 for i, initiative in ipairs(initiatives) do |
| bsw/jbe@19 | 93 ui.tag{ |
| bsw/jbe@19 | 94 tag = "entry", |
| bsw/jbe@19 | 95 content = function() |
| bsw/jbe@52 | 96 slot.put("\n") |
| bsw/jbe@52 | 97 ui.tag{ tag = "category", attr = { term = encode.html(initiative.issue.area.name) } } |
| bsw/jbe@52 | 98 slot.put("\n") |
| bsw/jbe@52 | 99 ui.tag{ tag = "author", content = encode.html(initiative.current_draft.author.name) } |
| bsw/jbe@52 | 100 slot.put("\n") |
| bsw/jbe@52 | 101 ui.tag{ tag = "title", content = encode.html(initiative.shortened_name) } |
| bsw/jbe@52 | 102 slot.put("\n") |
| bsw/jbe@19 | 103 ui.tag{ tag = "link", attr = { |
| bsw/jbe@19 | 104 href = encode.url{ |
| bsw/jbe@19 | 105 module = "initiative", |
| bsw/jbe@19 | 106 view = "show", |
| bsw/jbe@19 | 107 id = initiative.id |
| bsw/jbe@19 | 108 } |
| bsw/jbe@19 | 109 } } |
| bsw/jbe@52 | 110 slot.put("\n") |
| bsw/jbe@52 | 111 ui.tag{ tag = "id", content = "initiative_" .. tostring(initiative.id) } |
| bsw/jbe@52 | 112 slot.put("\n") |
| bsw/jbe@52 | 113 ui.tag{ tag = "updated", content = tostring(initiative.created_or_updated) } |
| bsw/jbe@52 | 114 slot.put("\n") |
| bsw/jbe@52 | 115 ui.tag{ tag = "content", content = encode.html(initiative.current_draft.content or "") } |
| bsw/jbe@52 | 116 slot.put("\n") |
| bsw/jbe@19 | 117 end |
| bsw/jbe@19 | 118 } |
| bsw/jbe@52 | 119 slot.put("\n") |
| bsw/jbe@52 | 120 end |