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