liquid_feedback_frontend
view app/main/member/show.lua @ 1103:0d917987a7f5
Show closed initiatives in member profile as initiated
| author | bsw |
|---|---|
| date | Wed Oct 29 14:42:27 2014 +0100 (2014-10-29) |
| parents | 701a5cf6b067 |
| children | 8874448bbb7a |
line source
1 local member = Member:by_id(param.get_id())
3 if not member or not member.activated then
4 execute.view { module = "index", view = "404" }
5 request.set_status("404 Not Found")
6 return
7 end
9 local limit = 25
11 local initiated_initiatives = Initiative:new_selector()
12 :join("initiator", nil, { "initiator.initiative_id = initiative.id and initiator.member_id = ?", member.id })
13 :join("issue", nil, "issue.id = initiative.issue_id")
14 :add_order_by("initiative.id DESC")
15 :limit(limit+1)
16 :exec()
18 initiated_initiatives:load("issue")
19 initiated_initiatives:load_everything_for_member_id(member.id)
21 local supported_initiatives = Initiative:new_selector()
22 :join("supporter", nil, { "supporter.initiative_id = initiative.id and supporter.member_id = ?", member.id })
23 :join("issue", nil, "issue.id = initiative.issue_id")
24 :add_where("issue.closed ISNULL")
25 :add_order_by("initiative.id DESC")
26 :limit(limit+1)
27 :exec()
29 supported_initiatives:load("issue")
30 supported_initiatives:load_everything_for_member_id(member.id)
32 local voted_initiatives = Initiative:new_selector()
33 :add_where("initiative.rank = 1")
34 :join("direct_voter", nil, { "direct_voter.issue_id = initiative.issue_id and direct_voter.member_id = ?", member.id })
35 :join("vote", nil, { "vote.initiative_id = initiative.id and vote.member_id = ?", member.id })
36 :join("issue", nil, "issue.id = initiative.issue_id")
37 :add_order_by("issue.closed DESC, initiative.id DESC")
38 :add_field("vote.grade", "vote_grade")
39 :add_field("vote.first_preference", "vote_first_preference")
40 :limit(limit+1)
41 :exec()
43 voted_initiatives:load("issue")
44 voted_initiatives:load_everything_for_member_id(member.id)
46 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
47 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id AND _member_showtab_issue.closed ISNULL")
48 :add_where("_member_showtab_issue.closed ISNULL")
49 :add_order_by("delegation.unit_id, delegation.area_id, delegation.issue_id")
50 :limit(limit+1)
52 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
53 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id AND _member_showtab_issue.closed ISNULL")
54 :add_where("_member_showtab_issue.closed ISNULL")
55 :add_order_by("delegation.unit_id, delegation.area_id, delegation.issue_id")
56 :limit(limit+1)
59 app.html_title.title = member.name
60 app.html_title.subtitle = _("Member")
62 ui.titleMember(member)
64 execute.view {
65 module = "member", view = "_sidebar_whatcanido", params = {
66 member = member
67 }
68 }
70 execute.view {
71 module = "member", view = "_sidebar_contacts", params = {
72 member = member
73 }
74 }
77 ui.section( function()
78 ui.sectionHead( function()
79 execute.view{
80 module = "member_image",
81 view = "_show",
82 params = {
83 member = member,
84 image_type = "avatar",
85 show_dummy = true,
86 class = "left"
87 }
88 }
89 ui.heading{ level = 1, content = member.name }
90 slot.put("<br />")
91 ui.container {
92 attr = { class = "right" },
93 content = function()
94 ui.link{
95 content = _"Account history",
96 module = "member", view = "history", id = member.id
97 }
98 end
99 }
100 if member.identification then
101 ui.container{ content = member.identification }
102 end
103 end )
104 ui.sectionRow( function()
105 execute.view{
106 module = "member",
107 view = "_profile",
108 params = { member = member }
109 }
110 end )
111 end )
114 ui.section( function()
115 ui.sectionHead( function()
116 ui.heading { level = 2, content = _"Initiatives created by this member" }
117 end )
118 ui.sectionRow( function()
119 for i, initiative in ipairs(initiated_initiatives) do
120 execute.view {
121 module = "initiative", view = "_list",
122 params = { initiative = initiative },
123 member = member
124 }
125 end
126 end )
127 end )
129 ui.section( function()
130 ui.sectionHead( function()
131 ui.heading { level = 2, content = _"What this member is currently supporting" }
132 end )
133 ui.sectionRow( function()
134 for i, initiative in ipairs(supported_initiatives) do
135 execute.view {
136 module = "initiative", view = "_list",
137 params = { initiative = initiative },
138 member = member
139 }
140 end
141 end )
142 end )
144 ui.section( function()
145 ui.sectionHead( function()
146 ui.heading { level = 2, content = _"How this member voted" }
147 end )
148 ui.sectionRow( function()
149 for i, initiative in ipairs(voted_initiatives) do
150 execute.view {
151 module = "initiative", view = "_list",
152 params = { initiative = initiative }
153 }
154 end
155 end )
156 end )
159 ui.section( function()
160 ui.sectionHead( function()
161 ui.heading { level = 2, content = _"Outgoing delegations" }
162 end )
163 ui.sectionRow( function()
164 execute.view {
165 module = "delegation", view = "_list",
166 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
167 }
168 end )
169 end )
172 ui.section( function()
174 ui.sectionHead( function()
175 ui.heading { level = 2, content = _"Incoming delegations" }
176 end )
177 ui.sectionRow( function()
178 execute.view {
179 module = "delegation", view = "_list",
180 params = { delegations_selector = incoming_delegations_selector, incoming = true },
181 }
182 end )
184 end )