liquid_feedback_frontend

view app/main/member/show_tab.lua @ 57:4f39f0a0d5b5

find changesets by author, revision, files, or words in the commit message
Listing of updated drafts on start page; Code cleanup; Minor bugfix

MOTD, initiator invite, issues to vote and listing of updated drafts shown as tabs on start page;
Bugfix: Initiator icon only shown when initiatorship has been accepted
author bsw
date Sat Apr 17 21:59:02 2010 +0200 (2010-04-17)
parents 81586ea68d57
children 0e75b5f04fe5
line source
1 local show_as_homepage = param.get("show_as_homepage", atom.boolean)
2
3 local member
4
5 if request.get_json_request_slots() then
6 member = Member:by_id(param.get("member_id"))
7 else
8 member = param.get("member", "table")
9 end
10
11 local tabs = {
12 module = "member",
13 view = "show_tab",
14 static_params = {
15 member_id = member.id,
16 show_as_homepage = show_as_homepage
17 }
18 }
19
20 if show_as_homepage and app.session.member_id == member.id then
21 tabs[#tabs+1] = {
22 class = "yellow",
23 name = "motd",
24 label = _"Message of the day",
25 icon = { static = "icons/16/bell.png" },
26 module = "index",
27 view = "_motd",
28 params = {}
29 }
30
31 local selector = Area:new_selector()
32 :reset_fields()
33 :add_field("area.id", nil, { "grouped" })
34 :add_field("area.name", nil, { "grouped" })
35 :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
36 :add_field("count(issue.id)", "issues_to_vote_count")
37 :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
38 :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
39 :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
40 :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
41 :add_where{ "direct_voter.member_id ISNULL" }
42 :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
43 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
44
45 local not_voted_areas = {}
46 local issues_to_vote_count = 0
47 for i, area in ipairs(selector:exec()) do
48 if area.is_member or area.interested_issues_to_vote_count > 0 then
49 not_voted_areas[#not_voted_areas+1] = area
50 end
51 issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
52 end
53
54 if issues_to_vote_count > 0 then
55 tabs[#tabs+1] = {
56 class = "yellow",
57 name = "not_voted_issues",
58 label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
59 icon = { static = "icons/16/email_open.png" },
60 module = "index",
61 view = "_not_voted_issues",
62 params = {
63 areas = not_voted_areas
64 }
65 }
66 end
67
68 local initiator_invites_selector = Initiative:new_selector()
69 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
70 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
71 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
72
73 if initiator_invites_selector:count() > 0 then
74 tabs[#tabs+1] = {
75 class = "yellow",
76 name = "initiator_invites",
77 label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
78 icon = { static = "icons/16/user_add.png" },
79 module = "index",
80 view = "_initiator_invites",
81 params = {
82 initiatives_selector = initiator_invites_selector
83 }
84 }
85 end
86
87 local updated_drafts_selector = Initiative:new_selector()
88 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
89 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
90 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
91
92 if updated_drafts_selector:count() > 0 then
93 tabs[#tabs+1] = {
94 class = "yellow",
95 name = "updated_drafts",
96 label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
97 icon = { static = "icons/16/script.png" },
98 module = "index",
99 view = "_updated_drafts",
100 params = {
101 initiatives_selector = updated_drafts_selector
102 }
103 }
104 end
105 end
106
107 tabs[#tabs+1] = {
108 name = "profile",
109 label = _"Profile",
110 icon = { static = "icons/16/application_form.png" },
111 module = "member",
112 view = "_profile",
113 params = { member = member },
114 }
115
116 local areas_selector = member:get_reference_selector("areas")
117 tabs[#tabs+1] = {
118 name = "areas",
119 label = _"Areas" .. " (" .. tostring(areas_selector:count()) .. ")",
120 icon = { static = "icons/16/package.png" },
121 module = "area",
122 view = "_list",
123 params = { areas_selector = areas_selector },
124 }
125
126 local issues_selector = member:get_reference_selector("issues")
127 tabs[#tabs+1] = {
128 name = "issues",
129 label = _"Issues" .. " (" .. tostring(issues_selector:count()) .. ")",
130 icon = { static = "icons/16/folder.png" },
131 module = "issue",
132 view = "_list",
133 params = { issues_selector = issues_selector },
134 }
135
136 local supported_initiatives_selector = member:get_reference_selector("supported_initiatives")
137 tabs[#tabs+1] = {
138 name = "supported_initiatives",
139 label = _"Supported initiatives" .. " (" .. tostring(supported_initiatives_selector:count()) .. ")",
140 icon = { static = "icons/16/thumb_up_green.png" },
141 module = "initiative",
142 view = "_list",
143 params = { initiatives_selector = supported_initiatives_selector },
144 }
145
146 local initiated_initiatives_selector = member:get_reference_selector("initiated_initiatives"):add_where("initiator.accepted = true")
147 tabs[#tabs+1] = {
148 name = "initiatied_initiatives",
149 label = _"Initiated initiatives" .. " (" .. tostring(initiated_initiatives_selector:count()) .. ")",
150 icon = { static = "icons/16/user_edit.png" },
151 module = "initiative",
152 view = "_list",
153 params = { initiatives_selector = initiated_initiatives_selector },
154 }
155
156 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
157 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
158 :add_where("_member_showtab_issue.closed ISNULL")
159 tabs[#tabs+1] = {
160 name = "incoming_delegations",
161 label = _"Incoming delegations" .. " (" .. tostring(incoming_delegations_selector:count()) .. ")",
162 icon = { static = "icons/16/table_go.png" },
163 module = "delegation",
164 view = "_list",
165 params = { delegations_selector = incoming_delegations_selector, incoming = true },
166 }
167
168 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
169 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
170 :add_where("_member_showtab_issue.closed ISNULL")
171 tabs[#tabs+1] = {
172 name = "outgoing_delegations",
173 label = _"Outgoing delegations" .. " (" .. tostring(outgoing_delegations_selector:count()) .. ")",
174 icon = { static = "icons/16/table_go.png" },
175 module = "delegation",
176 view = "_list",
177 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
178 }
179
180 local contacts_selector = member:get_reference_selector("saved_members"):add_where("public")
181 tabs[#tabs+1] = {
182 name = "contacts",
183 label = _"Contacts" .. " (" .. tostring(contacts_selector:count()) .. ")",
184 icon = { static = "icons/16/book_edit.png" },
185 module = "member",
186 view = "_list",
187 params = { members_selector = contacts_selector },
188 }
189
190 ui.tabs(tabs)

Impressum / About Us