liquid_feedback_frontend
view app/main/member/show_tab.lua @ 242:2dc13655afca
Removed vote later support (which was removed from core-2)
| author | bsw |
|---|---|
| date | Fri Dec 30 03:02:09 2011 +0100 (2011-12-30) |
| parents | bfd8d88f72fc |
| children | 65a1f7a01e7b |
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 icon = { static = "icons/16/bell.png" },
28 module = "member",
29 view = "_email_unconfirmed",
30 params = {}
31 }
32 end
34 if config.motd_intern then
35 tabs[#tabs+1] = {
36 class = "yellow",
37 name = "motd",
38 label = _"Message of the day",
39 icon = { static = "icons/16/bell.png" },
40 module = "index",
41 view = "_motd",
42 params = {}
43 }
44 end
46 local broken_delegations = Delegation:new_selector()
47 :join("issue", nil, "issue.id = delegation.issue_id AND issue.closed ISNULL")
48 :join("member", nil, "delegation.trustee_id = member.id")
49 :add_where{"delegation.truster_id = ?", member.id}
50 :add_where{"member.active = 'f' OR (member.last_activity IS NULL OR age(member.last_activity) > ?::interval)", config.delegation_warning_time }
52 if broken_delegations:count() > 0 then
53 tabs[#tabs+1] = {
54 class = "red",
55 name = "broken_delegations",
56 label = _"Delegation problems" .. " (" .. tostring(broken_delegations:count()) .. ")",
57 icon = { static = "icons/16/table_go.png" },
58 module = "delegation",
59 view = "_list",
60 params = { delegations_selector = broken_delegations, outgoing = true },
61 }
62 end
64 local selector = Area:new_selector()
65 :reset_fields()
66 :add_field("area.id", nil, { "grouped" })
67 :add_field("area.name", nil, { "grouped" })
68 :add_field("membership.member_id NOTNULL", "is_member", { "grouped" })
69 :add_field("count(issue.id)", "issues_to_vote_count")
70 :add_field("count(interest.member_id)", "interested_issues_to_vote_count")
71 :add_field("count(interest.member_id NOTNULL OR interest.member_id NOTNULL)", "issues_to_vote_count_sum")
72 :join("issue", nil, "issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL")
73 :left_join("direct_voter", nil, { "direct_voter.issue_id = issue.id AND direct_voter.member_id = ?", app.session.member.id })
74 :add_where{ "direct_voter.member_id ISNULL" }
75 :left_join("interest", nil, { "interest.issue_id = issue.id AND interest.member_id = ?", app.session.member.id })
76 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ? ", app.session.member.id })
78 local not_voted_areas = {}
79 local issues_to_vote_count = 0
80 for i, area in ipairs(selector:exec()) do
81 if area.is_member or area.interested_issues_to_vote_count > 0 then
82 not_voted_areas[#not_voted_areas+1] = area
83 end
84 if area.is_member then
85 issues_to_vote_count = issues_to_vote_count + area.issues_to_vote_count_sum
86 end
87 end
89 if issues_to_vote_count > 0 then
90 tabs[#tabs+1] = {
91 class = "yellow",
92 name = "not_voted_issues",
93 label = _"Not voted issues" .. " (" .. tostring(issues_to_vote_count) .. ")",
94 icon = { static = "icons/16/email_open.png" },
95 module = "index",
96 view = "_not_voted_issues",
97 params = {
98 areas = not_voted_areas
99 }
100 }
101 end
103 local initiator_invites_selector = Initiative:new_selector()
104 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id")
105 :join("initiator", nil, { "initiator.initiative_id = initiative.id AND initiator.member_id = ? AND initiator.accepted ISNULL", app.session.member.id })
106 :add_where("_issue_state.closed ISNULL AND _issue_state.half_frozen ISNULL")
108 if initiator_invites_selector:count() > 0 then
109 tabs[#tabs+1] = {
110 class = "yellow",
111 name = "initiator_invites",
112 label = _"Initiator invites" .. " (" .. tostring(initiator_invites_selector:count()) .. ")",
113 icon = { static = "icons/16/user_add.png" },
114 module = "index",
115 view = "_initiator_invites",
116 params = {
117 initiatives_selector = initiator_invites_selector
118 }
119 }
120 end
122 local updated_drafts_selector = Initiative:new_selector()
123 :join("issue", "_issue_state", "_issue_state.id = initiative.issue_id AND _issue_state.closed ISNULL AND _issue_state.fully_frozen ISNULL")
124 :join("current_draft", "_current_draft", "_current_draft.initiative_id = initiative.id")
125 :join("supporter", "supporter", { "supporter.member_id = ? AND supporter.initiative_id = initiative.id AND supporter.draft_id < _current_draft.id", app.session.member_id })
126 :add_where("initiative.revoked ISNULL")
128 if updated_drafts_selector:count() > 0 then
129 tabs[#tabs+1] = {
130 class = "yellow",
131 name = "updated_drafts",
132 label = _"Updated drafts" .. " (" .. tostring(updated_drafts_selector:count()) .. ")",
133 icon = { static = "icons/16/script.png" },
134 module = "index",
135 view = "_updated_drafts",
136 params = {
137 initiatives_selector = updated_drafts_selector
138 }
139 }
140 end
141 end
143 tabs[#tabs+1] = {
144 name = "profile",
145 label = _"Profile",
146 icon = { static = "icons/16/application_form.png" },
147 module = "member",
148 view = "_profile",
149 params = { member = member },
150 }
152 local areas_selector = member:get_reference_selector("areas")
153 tabs[#tabs+1] = {
154 name = "areas",
155 label = _"Areas" .. " (" .. tostring(areas_selector:count()) .. ")",
156 icon = { static = "icons/16/package.png" },
157 module = "area",
158 view = "_list",
159 params = { areas_selector = areas_selector },
160 }
162 local issues_selector = member:get_reference_selector("issues")
163 tabs[#tabs+1] = {
164 name = "issues",
165 label = _"Issues" .. " (" .. tostring(issues_selector:count()) .. ")",
166 icon = { static = "icons/16/folder.png" },
167 module = "issue",
168 view = "_list",
169 params = { issues_selector = issues_selector },
170 }
172 local supported_initiatives_selector = member:get_reference_selector("supported_initiatives")
174 tabs[#tabs+1] = {
175 name = "supported_initiatives",
176 label = _"Supported initiatives" .. " (" .. tostring(supported_initiatives_selector:count()) .. ")",
177 icon = { static = "icons/16/thumb_up_green.png" },
178 module = "member",
179 view = "_list_supported_initiatives",
180 params = { initiatives_selector = supported_initiatives_selector,
181 member = member },
182 }
184 local initiated_initiatives_selector = member:get_reference_selector("initiated_initiatives"):add_where("initiator.accepted = true")
185 tabs[#tabs+1] = {
186 name = "initiatied_initiatives",
187 label = _"Initiated initiatives" .. " (" .. tostring(initiated_initiatives_selector:count()) .. ")",
188 icon = { static = "icons/16/user_edit.png" },
189 module = "member",
190 view = "_list_supported_initiatives",
191 params = { initiatives_selector = initiated_initiatives_selector,
192 member = member},
193 }
195 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
196 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
197 :add_where("_member_showtab_issue.closed ISNULL")
198 tabs[#tabs+1] = {
199 name = "incoming_delegations",
200 label = _"Incoming delegations" .. " (" .. tostring(incoming_delegations_selector:count()) .. ")",
201 icon = { static = "icons/16/table_go.png" },
202 module = "delegation",
203 view = "_list",
204 params = { delegations_selector = incoming_delegations_selector, incoming = true },
205 }
207 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
208 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id")
209 :add_where("_member_showtab_issue.closed ISNULL")
210 tabs[#tabs+1] = {
211 name = "outgoing_delegations",
212 label = _"Outgoing delegations" .. " (" .. tostring(outgoing_delegations_selector:count()) .. ")",
213 icon = { static = "icons/16/table_go.png" },
214 module = "delegation",
215 view = "_list",
216 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
217 }
219 local contacts_selector = member:get_reference_selector("saved_members"):add_where("public")
220 tabs[#tabs+1] = {
221 name = "contacts",
222 label = _"Contacts" .. " (" .. tostring(contacts_selector:count()) .. ")",
223 icon = { static = "icons/16/book_edit.png" },
224 module = "member",
225 view = "_list",
226 params = { members_selector = contacts_selector },
227 }
229 ui.tabs(tabs)