liquid_feedback_frontend
view app/main/member/show.lua @ 1167:93b32111526f
Work on network configuration
| author | jbe | 
|---|---|
| date | Tue Mar 24 18:38:39 2015 +0100 (2015-03-24) | 
| parents | 8874448bbb7a | 
| children | 254661fb5d83 | 
 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         force_update = true
    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 )
   188 if app.session.member.id == member.id then
   189   ui.script{ script = [[
   190     var url = $(".microAvatar")[0].src;
   191     var onload = function() {
   192       this.contentWindow.location.reload(true);
   193       this.removeEventListener("load", onload, false);
   194       this.parentElement.removeChild(this);
   195     }
   196     var iframeEl = document.createElement("iframe");
   197     iframeEl.style.display = "none";
   198     iframeEl.src = url;
   199     iframeEl.addEventListener("load", onload, false);
   200     document.body.appendChild(iframeEl);
   201   ]] }
   202 end
