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