liquid_feedback_frontend

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

Impressum / About Us