| rev |
line source |
|
bsw/jbe@0
|
1 local areas_selector = param.get("areas_selector", "table")
|
|
bsw@375
|
2 local hide_membership = param.get("hide_membership", atom.boolean)
|
|
bsw/jbe@0
|
3
|
|
bsw@9
|
4 areas_selector
|
|
bsw@9
|
5 :reset_fields()
|
|
bsw@9
|
6 :add_field("area.id", nil, { "grouped" })
|
|
bsw@9
|
7 :add_field("area.name", nil, { "grouped" })
|
|
bsw@9
|
8 :add_field("member_weight", nil, { "grouped" })
|
|
bsw@9
|
9 :add_field("direct_member_count", nil, { "grouped" })
|
|
bsw@9
|
10 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted ISNULL AND issue.closed ISNULL)", "issues_new_count")
|
|
bsw@9
|
11 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL)", "issues_discussion_count")
|
|
bsw@9
|
12 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL)", "issues_frozen_count")
|
|
bsw@9
|
13 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL)", "issues_voting_count")
|
|
bsw@10
|
14 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed NOTNULL)", "issues_finished_count")
|
|
bsw@10
|
15 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen ISNULL AND issue.closed NOTNULL)", "issues_cancelled_count")
|
|
bsw@51
|
16
|
|
bsw@51
|
17 if app.session.member_id then
|
|
bsw@51
|
18 areas_selector
|
|
bsw@51
|
19 :add_field({ "(SELECT COUNT(*) FROM issue LEFT JOIN direct_voter ON direct_voter.issue_id = issue.id AND direct_voter.member_id = ? WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL AND direct_voter.member_id ISNULL)", app.session.member.id }, "issues_to_vote_count")
|
|
bsw@51
|
20 :left_join("membership", "_membership", { "_membership.area_id = area.id AND _membership.member_id = ?", app.session.member.id })
|
|
bsw@51
|
21 :add_field("_membership.member_id NOTNULL", "is_member", { "grouped" })
|
|
bsw@274
|
22 :left_join("delegation", nil, {
|
|
bsw@274
|
23 "delegation.truster_id = ? AND delegation.area_id = area.id AND delegation.scope = 'area'", app.session.member_id
|
|
bsw@274
|
24 })
|
|
bsw@274
|
25 :left_join("member", nil, "member.id = delegation.trustee_id")
|
|
bsw@274
|
26 :add_field("member.id", "trustee_member_id", { "grouped" })
|
|
bsw@274
|
27 :add_field("member.name", "trustee_member_name", { "grouped" })
|
|
bsw@51
|
28 else
|
|
bsw@51
|
29 areas_selector:add_field("0", "issues_to_vote_count")
|
|
bsw@51
|
30 end
|
|
bsw@9
|
31
|
|
bsw@598
|
32 slot.put("<br />")
|
|
bsw@381
|
33
|
|
bsw@598
|
34 for i, area in ipairs(areas_selector:exec()) do
|
|
bsw@375
|
35
|
|
bsw@598
|
36 ui.container{ attr = { class = "area_list" }, content = function()
|
|
bsw@598
|
37 execute.view { module = "area", view = "_list_entry", params = { area = area } }
|
|
bsw@598
|
38 end }
|
|
bsw@598
|
39
|
|
bsw@598
|
40 end
|
|
bsw/jbe@19
|
41
|