liquid_feedback_frontend

annotate app/main/member/show.lua @ 1103:0d917987a7f5

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

Impressum / About Us