liquid_feedback_frontend

annotate app/main/timeline/index.lua @ 10:72c5e0ee7c98

Version beta6

Bugfixes:
- Security fix: Every user was able to change the discussion URL of an initiative
- Creation of new issues in areas without default policies is now possible
- Members can now be sorted in different ways
- No error when trying to compare a draft with itself
- Added missing local statement to variable initialization in app/main/delegation/new.lua
- CSS flaw in initiative action bar fixed

New features:
- Possiblity to invite other users to become initiator
- Revokation of initiatives implemented
- Number of suggestions, supporters, etc. is shown on corresponding tabs of initiative view
- Members can now be sorted by account creation (default sorting is "newest first")
- Configuration option to create an automatic discussion link for all issues
- First draft of global timeline feature (not accessible via link yet)
- Custom stylesheet URL for users marked as developers

In area listing the number of closed issues is shown too

Renamed "author" field of initiative to "last author"

Removed wrongly included file app/main/member/_show_thumb.lua.orig in the distribution

Help texts updated
author bsw
date Sun Jan 10 12:00:00 2010 +0100 (2010-01-10)
parents
children 77d58efe99fd
rev   line source
bsw@10 1
bsw@10 2 local function format_dow(dow)
bsw@10 3 local dows = {
bsw@10 4 _"Monday",
bsw@10 5 _"Tuesday",
bsw@10 6 _"Wednesday",
bsw@10 7 _"Thursday",
bsw@10 8 _"Friday",
bsw@10 9 _"Saturday",
bsw@10 10 _"Sunday"
bsw@10 11 }
bsw@10 12 return dows[dow+1]
bsw@10 13 end
bsw@10 14
bsw@10 15 slot.put_into("title", _"Global timeline")
bsw@10 16
bsw@10 17
bsw@10 18 ui.form{
bsw@10 19 attr = { class = "vertical" },
bsw@10 20 module = "timeline",
bsw@10 21 view = "index",
bsw@10 22 method = "get",
bsw@10 23 content = function()
bsw@10 24 local tmp = db:query("select EXTRACT(DOW FROM date) as dow, date FROM (SELECT (now() - (to_char(days_before, '0') || ' days')::interval)::date as date from (select generate_series(0,7) as days_before) as series) as date; ")
bsw@10 25 local today = tmp[1].date
bsw@10 26 for i, record in ipairs(tmp) do
bsw@10 27 local content
bsw@10 28 if i == 1 then
bsw@10 29 content = _"Today"
bsw@10 30 elseif i == 2 then
bsw@10 31 content = _"Yesterday"
bsw@10 32 else
bsw@10 33 content = format_dow(record.dow)
bsw@10 34 end
bsw@10 35 ui.link{
bsw@10 36 content = content,
bsw@10 37 attr = { onclick = "el = document.getElementById('timeline_search_date'); el.value = '" .. tostring(record.date) .. "'; el.form.submit(); return(false);" },
bsw@10 38 module = "timeline",
bsw@10 39 view = "index",
bsw@10 40 params = { date = record.date }
bsw@10 41 }
bsw@10 42 slot.put(" ")
bsw@10 43 end
bsw@10 44 ui.field.hidden{
bsw@10 45 attr = { id = "timeline_search_date" },
bsw@10 46 name = "date",
bsw@10 47 value = param.get("date") or today
bsw@10 48 }
bsw@10 49 ui.field.select{
bsw@10 50 attr = { onchange = "this.form.submit();" },
bsw@10 51 name = "per_page",
bsw@10 52 label = _"Issues per page",
bsw@10 53 foreign_records = {
bsw@10 54 { id = "10", name = "10" },
bsw@10 55 { id = "25", name = "25" },
bsw@10 56 { id = "50", name = "50" },
bsw@10 57 { id = "100", name = "100" },
bsw@10 58 { id = "250", name = "250" },
bsw@10 59 { id = "all", name = _"All" },
bsw@10 60 },
bsw@10 61 foreign_id = "id",
bsw@10 62 foreign_name = "name",
bsw@10 63 value = param.get("per_page")
bsw@10 64 }
bsw@10 65 local initiatives_per_page = param.get("initiatives_per_page", atom.integer) or 3
bsw@10 66
bsw@10 67 ui.field.select{
bsw@10 68 attr = { onchange = "this.form.submit();" },
bsw@10 69 name = "initiatives_per_page",
bsw@10 70 label = _"Initiatives per page",
bsw@10 71 foreign_records = {
bsw@10 72 { id = 1, name = "1" },
bsw@10 73 { id = 3, name = "3" },
bsw@10 74 { id = 5, name = "5" },
bsw@10 75 { id = 10, name = "10" },
bsw@10 76 { id = 25, name = "25" },
bsw@10 77 { id = 50, name = "50" },
bsw@10 78 },
bsw@10 79 foreign_id = "id",
bsw@10 80 foreign_name = "name",
bsw@10 81 value = initiatives_per_page
bsw@10 82 }
bsw@10 83 end
bsw@10 84 }
bsw@10 85
bsw@10 86 local date = param.get("date")
bsw@10 87 if not date then
bsw@10 88 date = "today"
bsw@10 89 end
bsw@10 90 local issues_selector = db:new_selector()
bsw@10 91 issues_selector._class = Issue
bsw@10 92
bsw@10 93 issues_selector
bsw@10 94 :add_field("*")
bsw@10 95 :add_where{ "sort::date = ?", date }
bsw@10 96 :add_from{ "($) as issue", {
bsw@10 97 Issue:new_selector()
bsw@10 98 :add_field("''", "old_state")
bsw@10 99 :add_field("'new'", "new_state")
bsw@10 100 :add_field("created", "sort")
bsw@10 101 :union(Issue:new_selector()
bsw@10 102 :add_field("'new'", "old_state")
bsw@10 103 :add_field("'accepted'", "new_state")
bsw@10 104 :add_field("accepted", "sort")
bsw@10 105 :add_where("accepted NOTNULL")
bsw@10 106 ):union(Issue:new_selector()
bsw@10 107 :add_field("'accepted'", "old_state")
bsw@10 108 :add_field("'frozen'", "new_state")
bsw@10 109 :add_field("half_frozen", "sort")
bsw@10 110 :add_where("half_frozen NOTNULL")
bsw@10 111 ):union(Issue:new_selector()
bsw@10 112 :add_field("'frozen'", "old_state")
bsw@10 113 :add_field("'voting'", "new_state")
bsw@10 114 :add_field("fully_frozen", "sort")
bsw@10 115 :add_where("fully_frozen NOTNULL")
bsw@10 116 ):union(Issue:new_selector()
bsw@10 117 :add_field("'new'", "old_state")
bsw@10 118 :add_field("'cancelled'", "new_state")
bsw@10 119 :add_field("closed", "sort")
bsw@10 120 :add_where("closed NOTNULL AND accepted ISNULL")
bsw@10 121 ):union(Issue:new_selector()
bsw@10 122 :add_field("'accepted'", "old_state")
bsw@10 123 :add_field("'cancelled'", "new_state")
bsw@10 124 :add_field("closed", "sort")
bsw@10 125 :add_where("closed NOTNULL AND half_frozen ISNULL AND accepted NOTNULL")
bsw@10 126 ):union(Issue:new_selector()
bsw@10 127 :add_field("'frozen'", "old_state")
bsw@10 128 :add_field("'cancelled'", "new_state")
bsw@10 129 :add_field("closed", "sort")
bsw@10 130 :add_where("closed NOTNULL AND fully_frozen ISNULL AND half_frozen NOTNULL")
bsw@10 131 ):union(Issue:new_selector()
bsw@10 132 :add_field("'voting'", "old_state")
bsw@10 133 :add_field("'finished'", "new_state")
bsw@10 134 :add_field("closed", "sort")
bsw@10 135 :add_where("closed NOTNULL AND fully_frozen NOTNULL AND half_frozen ISNULL")
bsw@10 136 )
bsw@10 137 }
bsw@10 138 }
bsw@10 139
bsw@10 140 execute.view{
bsw@10 141 module = "issue",
bsw@10 142 view = "_list",
bsw@10 143 params = {
bsw@10 144 issues_selector = issues_selector,
bsw@10 145 initiatives_per_page = param.get("initiatives_per_page", atom.number),
bsw@10 146 initiatives_no_sort = true,
bsw@10 147 no_filter = true,
bsw@10 148 no_sort = true,
bsw@10 149 per_page = param.get("per_page"),
bsw@10 150 }
bsw@10 151 }

Impressum / About Us