liquid_feedback_frontend

view app/main/member/show_tab.lua @ 70:a934d06661b1

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

Impressum / About Us