liquid_feedback_frontend
view app/main/member/show.lua @ 1045:701a5cf6b067
Imported LiquidFeedback Frontend 3.0 branch
| author | bsw |
|---|---|
| date | Thu Jul 10 01:19:48 2014 +0200 (2014-07-10) |
| parents | ea2449916c12 |
| children | 0d917987a7f5 |
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_where("issue.closed ISNULL")
15 :add_order_by("initiative.id DESC")
16 :limit(limit+1)
17 :exec()
19 initiated_initiatives:load("issue")
20 initiated_initiatives:load_everything_for_member_id(member.id)
22 local supported_initiatives = Initiative:new_selector()
23 :join("supporter", nil, { "supporter.initiative_id = initiative.id and supporter.member_id = ?", member.id })
24 :join("issue", nil, "issue.id = initiative.issue_id")
25 :add_where("issue.closed ISNULL")
26 :add_order_by("initiative.id DESC")
27 :limit(limit+1)
28 :exec()
30 supported_initiatives:load("issue")
31 supported_initiatives:load_everything_for_member_id(member.id)
33 local voted_initiatives = Initiative:new_selector()
34 :add_where("initiative.rank = 1")
35 :join("direct_voter", nil, { "direct_voter.issue_id = initiative.issue_id and direct_voter.member_id = ?", member.id })
36 :join("vote", nil, { "vote.initiative_id = initiative.id and vote.member_id = ?", member.id })
37 :join("issue", nil, "issue.id = initiative.issue_id")
38 :add_order_by("issue.closed DESC, initiative.id DESC")
39 :add_field("vote.grade", "vote_grade")
40 :add_field("vote.first_preference", "vote_first_preference")
41 :limit(limit+1)
42 :exec()
44 voted_initiatives:load("issue")
45 voted_initiatives:load_everything_for_member_id(member.id)
47 local incoming_delegations_selector = member:get_reference_selector("incoming_delegations")
48 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id AND _member_showtab_issue.closed ISNULL")
49 :add_where("_member_showtab_issue.closed ISNULL")
50 :add_order_by("delegation.unit_id, delegation.area_id, delegation.issue_id")
51 :limit(limit+1)
53 local outgoing_delegations_selector = member:get_reference_selector("outgoing_delegations")
54 :left_join("issue", "_member_showtab_issue", "_member_showtab_issue.id = delegation.issue_id AND _member_showtab_issue.closed ISNULL")
55 :add_where("_member_showtab_issue.closed ISNULL")
56 :add_order_by("delegation.unit_id, delegation.area_id, delegation.issue_id")
57 :limit(limit+1)
60 app.html_title.title = member.name
61 app.html_title.subtitle = _("Member")
63 ui.titleMember(member)
65 execute.view {
66 module = "member", view = "_sidebar_whatcanido", params = {
67 member = member
68 }
69 }
71 execute.view {
72 module = "member", view = "_sidebar_contacts", params = {
73 member = member
74 }
75 }
78 ui.section( function()
79 ui.sectionHead( function()
80 execute.view{
81 module = "member_image",
82 view = "_show",
83 params = {
84 member = member,
85 image_type = "avatar",
86 show_dummy = true,
87 class = "left"
88 }
89 }
90 ui.heading{ level = 1, content = member.name }
91 slot.put("<br />")
92 ui.container {
93 attr = { class = "right" },
94 content = function()
95 ui.link{
96 content = _"Account history",
97 module = "member", view = "history", id = member.id
98 }
99 end
100 }
101 if member.identification then
102 ui.container{ content = member.identification }
103 end
104 end )
105 ui.sectionRow( function()
106 execute.view{
107 module = "member",
108 view = "_profile",
109 params = { member = member }
110 }
111 end )
112 end )
115 ui.section( function()
116 ui.sectionHead( function()
117 ui.heading { level = 2, content = _"Initiatives created by this member" }
118 end )
119 ui.sectionRow( function()
120 for i, initiative in ipairs(initiated_initiatives) do
121 execute.view {
122 module = "initiative", view = "_list",
123 params = { initiative = initiative },
124 member = member
125 }
126 end
127 end )
128 end )
130 ui.section( function()
131 ui.sectionHead( function()
132 ui.heading { level = 2, content = _"What this member is currently supporting" }
133 end )
134 ui.sectionRow( function()
135 for i, initiative in ipairs(supported_initiatives) do
136 execute.view {
137 module = "initiative", view = "_list",
138 params = { initiative = initiative },
139 member = member
140 }
141 end
142 end )
143 end )
145 ui.section( function()
146 ui.sectionHead( function()
147 ui.heading { level = 2, content = _"How this member voted" }
148 end )
149 ui.sectionRow( function()
150 for i, initiative in ipairs(voted_initiatives) do
151 execute.view {
152 module = "initiative", view = "_list",
153 params = { initiative = initiative }
154 }
155 end
156 end )
157 end )
160 ui.section( function()
161 ui.sectionHead( function()
162 ui.heading { level = 2, content = _"Outgoing delegations" }
163 end )
164 ui.sectionRow( function()
165 execute.view {
166 module = "delegation", view = "_list",
167 params = { delegations_selector = outgoing_delegations_selector, outgoing = true },
168 }
169 end )
170 end )
173 ui.section( function()
175 ui.sectionHead( function()
176 ui.heading { level = 2, content = _"Incoming delegations" }
177 end )
178 ui.sectionRow( function()
179 execute.view {
180 module = "delegation", view = "_list",
181 params = { delegations_selector = incoming_delegations_selector, incoming = true },
182 }
183 end )
185 end )