liquid_feedback_frontend
view app/main/member/show_tab.lua @ 438:bbd0dcb5be63
Show event timeline as homepage
| author | bsw |
|---|---|
| date | Sun Mar 11 12:22:40 2012 +0100 (2012-03-11) |
| parents | 699b9fa7bc36 |
| children | e953e56ecf55 |
line source
1 local show_as_homepage = param.get("show_as_homepage", atom.boolean)
3 local member
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
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 }
20 if show_as_homepage and app.session.member_id == member.id then
22 if app.session.member.notify_email_unconfirmed then
23 tabs[#tabs+1] = {
24 class = "yellow",
25 name = "email_unconfirmed",
26 label = _"Email unconfirmed",
27 module = "member",
28 view = "_email_unconfirmed",
29 params = {}
30 }
31 end
33 if app.session.member.notify_level == nil then
34 tabs[#tabs+1] = {
35 class = "yellow",
36 name = "notify_level_not_set",
37 label = _"Notifications",
38 module = "member",
39 view = "_notify_level_not_set"
40 }
41 end
43 --[[
44 if config.motd_intern then
45 tabs[#tabs+1] = {
46 class = "yellow",
47 name = "motd",
48 label = _"Message of the day",
49 module = "index",
50 view = "_motd",
51 params = {}
52 }
53 end
54 --]]
56 local broken_delegations = Delegation:new_selector()
57 :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
58 :join("member", nil, "delegation.trustee_id = member.id")
59 :add_where{"delegation.truster_id = ?", member.id}
60 :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }
62 if broken_delegations:count() > 0 then
63 tabs[#tabs+1] = {
64 class = "red",
65 name = "broken_delegations",
66 label = _"Delegation problems" .. " (" .. tostring(broken_delegations:count()) .. ")",
67 icon = { static = "icons/16/table_go.png" },
68 module = "delegation",
69 view = "_list",
70 params = { delegations_selector = broken_delegations, outgoing = true },
71 }
72 end
74 local selector = Area:new_selector()
75 :reset_fields()
76 :join("privilege", nil, { "privilege.unit_id = area.unit_id AND privilege.member_id = ? AND privilege.voting_right", app.session.member_id })
77 :add_field("area.id", nil, { "grouped" })
78 :add_field("area.name", nil, { "grouped" })
79 :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
80 :add_field("count(issue.id)", "issues_to_vote_count")
81 :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
82 :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
83 :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
84 :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
85 :add_where{ "direct_voter.member_id ISNULL" }
86 :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
87 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
89 local not_voted_areas = {}
90 local issues_to_vote_count = 0
91 for i, area in ipairs(selector:exec()) do
92 if area.is_member or area.interested_issues_to_vote_count > 0 then
93 not_voted_areas[#not_voted_areas+1] = area
94 end
95 if area.is_member then
96 issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
97 end
98 end
100 if issues_to_vote_count > 0 then
101 tabs[#tabs+1] = {
102 class = "yellow",
103 name = "not_voted_issues",
104 label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
105 icon = { static = "icons/16/email_open.png" },
106 module = "index",
107 view = "_not_voted_issues",
108 params = {
109 areas = not_voted_areas
110 }
111 }
112 end
114 local initiator_invites_selector = Initiative:new_selector()
115 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
116 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
117 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
119 if initiator_invites_selector:count() > 0 then
120 tabs[#tabs+1] = {
121 class = "yellow",
122 name = "initiator_invites",
123 label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
124 icon = { static = "icons/16/user_add.png" },
125 module = "index",
126 view = "_initiator_invites",
127 params = {
128 initiatives_selector = initiator_invites_selector
129 }
130 }
131 end
133 local updated_drafts_selector = Initiative:new_selector()
134 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
135 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
136 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
137 :add_where("initiative.revoked ISNULL")
139 if updated_drafts_selector:count() > 0 then
140 tabs[#tabs+1] = {
141 class = "yellow",
142 name = "updated_drafts",
143 label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
144 icon = { static = "icons/16/script.png" },
145 module = "index",
146 view = "_updated_drafts",
147 params = {
148 initiatives_selector = updated_drafts_selector
149 }
150 }
151 end
152 end
154 if not show_as_homepage then
155 tabs[#tabs+1] = {
156 name = "profile",
157 label = _"Profile",
158 icon = { static = "icons/16/application_form.png" },
159 module = "member",
160 view = "_profile",
161 params = { member = member },
162 }
163 end
165 if show_as_homepage then
166 tabs[#tabs+1] = {
167 name = "timeline",
168 label = _"Events",
169 module = "member",
170 view = "_event_list",
171 params = { }
172 }
173 else
174 tabs[#tabs+1] = {
175 name = "timeline",
176 label = _"Events",
177 module = "event",
178 view = "_list",
179 params = { for_member = member }
180 }
181 end
183 tabs[#tabs+1] = {
184 name = "open",
185 label = _"Open issues",
186 module = "issue",
187 view = "_list",
188 params = {
189 for_state = "open",
190 issues_selector = Issue:new_selector()
191 :add_where("issue.closed ISNULL")
192 :add_order_by("coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()")
193 }
194 }
196 tabs[#tabs+1] = {
197 name = "closed",
198 label = _"Closed issues",
199 module = "issue",
200 view = "_list",
201 params = {
202 for_state = "closed",
203 issues_selector = Issue:new_selector()
204 :add_where("issue.closed NOTNULL")
205 :add_order_by("issue.closed DESC")
207 }
208 }
210 local areas_selector = member:get_reference_selector("areas")
211 tabs[#tabs+1] = {
212 name = "areas",
213 label = _"Areas",
214 icon = { static = "icons/16/package.png" },
215 module = "member",
216 view = "_area_list",
217 params = { areas_selector = areas_selector, member = member },
218 }
220 if not show_as_homepage then
221 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
222 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
223 :add_where("_member_showtab_issue.closed ISNULL")
224 tabs[#tabs+1] = {
225 name = "outgoing_delegations",
226 label = _"Outgoing delegations" .. " (" .. tostring(outgoing_delegations_selector:count()) .. ")",
227 icon = { static = "icons/16/table_go.png" },
228 module = "delegation",
229 view = "_list",
230 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
231 }
233 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
234 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
235 :add_where("_member_showtab_issue.closed ISNULL")
236 tabs[#tabs+1] = {
237 name = "incoming_delegations",
238 label = _"Incoming delegations" .. " (" .. tostring(incoming_delegations_selector:count()) .. ")",
239 icon = { static = "icons/16/table_go.png" },
240 module = "delegation",
241 view = "_list",
242 params = { delegations_selector = incoming_delegations_selector, incoming = true },
243 }
245 local contacts_selector = member:get_reference_selector("saved_members"):add_where("public")
246 tabs[#tabs+1] = {
247 name = "contacts",
248 label = _"Contacts" .. " (" .. tostring(contacts_selector:count()) .. ")",
249 icon = { static = "icons/16/book_edit.png" },
250 module = "member",
251 view = "_list",
252 params = { members_selector = contacts_selector },
253 }
254 end
256 ui.tabs(tabs)