| rev |
line source |
|
bsw/jbe@0
|
1 local areas_selector = param.get("areas_selector", "table")
|
|
bsw/jbe@0
|
2
|
|
bsw@9
|
3 areas_selector
|
|
bsw@9
|
4 :reset_fields()
|
|
bsw@9
|
5 :add_field("area.id", nil, { "grouped" })
|
|
bsw@9
|
6 :add_field("area.name", nil, { "grouped" })
|
|
bsw@9
|
7 :add_field("member_weight", nil, { "grouped" })
|
|
bsw@9
|
8 :add_field("direct_member_count", nil, { "grouped" })
|
|
bsw@9
|
9 :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
|
10 :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
|
11 :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
|
12 :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
|
13 :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
|
14 :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
|
15
|
|
bsw@51
|
16 if app.session.member_id then
|
|
bsw@51
|
17 areas_selector
|
|
bsw@51
|
18 :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
|
19 :left_join("membership", "_membership", { "_membership.area_id = area.id AND _membership.member_id = ?", app.session.member.id })
|
|
bsw@51
|
20 :add_field("_membership.member_id NOTNULL", "is_member", { "grouped" })
|
|
bsw@274
|
21 :left_join("delegation", nil, {
|
|
bsw@274
|
22 "delegation.truster_id = ? AND delegation.area_id = area.id AND delegation.scope = 'area'", app.session.member_id
|
|
bsw@274
|
23 })
|
|
bsw@274
|
24 :left_join("member", nil, "member.id = delegation.trustee_id")
|
|
bsw@274
|
25 :add_field("member.id", "trustee_member_id", { "grouped" })
|
|
bsw@274
|
26 :add_field("member.name", "trustee_member_name", { "grouped" })
|
|
bsw@51
|
27 else
|
|
bsw@51
|
28 areas_selector:add_field("0", "issues_to_vote_count")
|
|
bsw@51
|
29 end
|
|
bsw@9
|
30
|
|
bsw@373
|
31
|
|
bsw@373
|
32 ui.container{ attr = { class = "area_list" }, content = function()
|
|
bsw@373
|
33
|
|
bsw@373
|
34 for i, area in ipairs(areas_selector:exec()) do
|
|
bsw@373
|
35
|
|
bsw@373
|
36 ui.container{ attr = { class = "area" }, content = function()
|
|
bsw@373
|
37
|
|
bsw@373
|
38 ui.container{ attr = { class = "info" }, content = function()
|
|
bsw/jbe@19
|
39
|
|
bsw@373
|
40 ui.container{ attr = { class = "bar" }, content = function()
|
|
bsw@373
|
41 if area.member_weight and area.direct_member_count then
|
|
bsw@373
|
42 local max_value = MemberCount:get()
|
|
bsw@373
|
43 ui.bargraph{
|
|
bsw@373
|
44 max_value = max_value,
|
|
bsw@373
|
45 width = 100,
|
|
bsw@373
|
46 bars = {
|
|
bsw@373
|
47 { color = "#444", value = area.direct_member_count },
|
|
bsw@373
|
48 { color = "#777", value = area.member_weight - area.direct_member_count },
|
|
bsw@373
|
49 { color = "#ddd", value = max_value - area.member_weight },
|
|
bsw@373
|
50 }
|
|
bsw@269
|
51 }
|
|
bsw@373
|
52 end
|
|
bsw@373
|
53 end }
|
|
bsw@373
|
54
|
|
bsw@373
|
55 ui.container{ attr = { class = "name" }, content = function()
|
|
bsw@373
|
56 ui.link{
|
|
bsw@373
|
57 text = area.name,
|
|
bsw@373
|
58 module = "area",
|
|
bsw@373
|
59 view = "show",
|
|
bsw@373
|
60 id = area.id
|
|
bsw@373
|
61 }
|
|
bsw@373
|
62 slot.put(" ")
|
|
bsw@373
|
63 ui.tag{ content = "" }
|
|
bsw@373
|
64 end
|
|
bsw@269
|
65 }
|
|
bsw@373
|
66
|
|
bsw@373
|
67 ui.container{ attr = { class = "membership" }, content = function()
|
|
bsw@373
|
68 if area.is_member then
|
|
bsw@373
|
69 local text = _"Member of area"
|
|
bsw@373
|
70 ui.image{
|
|
bsw@373
|
71 attr = { title = text, alt = text },
|
|
bsw@373
|
72 static = "icons/16/user_gray.png",
|
|
bsw@373
|
73 }
|
|
bsw@373
|
74 else
|
|
bsw@373
|
75 slot.put('<img src="null.png" width="16" height="1" />')
|
|
bsw@373
|
76 end
|
|
bsw@373
|
77 end }
|
|
bsw@373
|
78
|
|
bsw@373
|
79 ui.container{ attr = { class = "delegatee" }, content = function()
|
|
bsw@373
|
80 if area.trustee_member_id then
|
|
bsw@373
|
81 local trustee_member = Member:by_id(area.trustee_member_id)
|
|
bsw@373
|
82 local text = _("Area delegated to '#{name}'", { name = area.trustee_member_name })
|
|
bsw@373
|
83 local text = _"delegated to"
|
|
bsw@373
|
84 ui.image{
|
|
bsw@373
|
85 attr = { class = "delegation_arrow", alt = text, title = text },
|
|
bsw@373
|
86 static = "delegation_arrow_24_horizontal.png"
|
|
bsw@373
|
87 }
|
|
bsw@373
|
88 execute.view{
|
|
bsw@373
|
89 module = "member_image",
|
|
bsw@373
|
90 view = "_show",
|
|
bsw@373
|
91 params = {
|
|
bsw@373
|
92 member = trustee_member,
|
|
bsw@373
|
93 image_type = "avatar",
|
|
bsw@373
|
94 show_dummy = true,
|
|
bsw@373
|
95 class = "micro_avatar",
|
|
bsw@373
|
96 popup_text = text
|
|
bsw@373
|
97 }
|
|
bsw@373
|
98 }
|
|
bsw@373
|
99 else
|
|
bsw@373
|
100 slot.put('<img src="null.png" width="24" height="1" />')
|
|
bsw@373
|
101 end
|
|
bsw@373
|
102 end }
|
|
bsw@373
|
103 end }
|
|
bsw/jbe@4
|
104
|
|
bsw@373
|
105 ui.container{ attr = { class = "phases" }, content = function()
|
|
bsw@373
|
106
|
|
bsw@373
|
107 ui.container{ attr = { class = "admission" }, content = function()
|
|
bsw@373
|
108 ui.link{
|
|
bsw@373
|
109 text = tostring(area.issues_new_count),
|
|
bsw@373
|
110 module = "area",
|
|
bsw@373
|
111 view = "show",
|
|
bsw@373
|
112 id = area.id,
|
|
bsw@373
|
113 params = { filter = "new", tab = "issues" }
|
|
bsw@373
|
114 }
|
|
bsw@373
|
115 end }
|
|
bsw/jbe@19
|
116
|
|
bsw@373
|
117 ui.container{ attr = { class = "discussion" }, content = function()
|
|
bsw@373
|
118 ui.link{
|
|
bsw@373
|
119 text = tostring(area.issues_discussion_count),
|
|
bsw@373
|
120 module = "area",
|
|
bsw@373
|
121 view = "show",
|
|
bsw@373
|
122 id = area.id,
|
|
bsw@373
|
123 params = { filter = "accepted", tab = "issues" }
|
|
bsw@373
|
124 }
|
|
bsw@373
|
125 end }
|
|
mail@240
|
126
|
|
bsw@373
|
127 ui.container{ attr = { class = "verification" }, content = function()
|
|
bsw@373
|
128 ui.link{
|
|
bsw@373
|
129 text = tostring(area.issues_frozen_count),
|
|
bsw@373
|
130 module = "area",
|
|
bsw@373
|
131 view = "show",
|
|
bsw@373
|
132 id = area.id,
|
|
bsw@373
|
133 params = { filter = "half_frozen", tab = "issues" }
|
|
bsw@373
|
134 }
|
|
bsw@373
|
135 end }
|
|
bsw/jbe@19
|
136
|
|
bsw@373
|
137 ui.container{ attr = { class = "voting" }, content = function()
|
|
bsw@373
|
138 ui.link{
|
|
bsw@373
|
139 text = tostring(area.issues_voting_count),
|
|
bsw@373
|
140 module = "area",
|
|
bsw@373
|
141 view = "show",
|
|
bsw@373
|
142 id = area.id,
|
|
bsw@373
|
143 params = { filter = "frozen", tab = "issues" }
|
|
bsw@373
|
144 }
|
|
bsw@373
|
145 end }
|
|
bsw/jbe@19
|
146
|
|
bsw@373
|
147 ui.container{ attr = { class = "finished" }, content = function()
|
|
bsw@373
|
148 ui.link{
|
|
bsw@373
|
149 text = tostring(area.issues_finished_count),
|
|
bsw@373
|
150 module = "area",
|
|
bsw@373
|
151 view = "show",
|
|
bsw@373
|
152 id = area.id,
|
|
bsw@373
|
153 params = { filter = "finished", issue_list = "newest", tab = "issues" }
|
|
bsw@373
|
154 }
|
|
bsw@373
|
155 end }
|
|
bsw/jbe@19
|
156
|
|
bsw@373
|
157 ui.container{ attr = { class = "cancelled" }, content = function()
|
|
bsw@373
|
158 ui.link{
|
|
bsw@373
|
159 text = tostring(area.issues_cancelled_count),
|
|
bsw@373
|
160 module = "area",
|
|
bsw@373
|
161 view = "show",
|
|
bsw@373
|
162 id = area.id,
|
|
bsw@373
|
163 params = { filter = "cancelled", issue_list = "newest", tab = "issues" }
|
|
bsw@373
|
164 }
|
|
bsw@373
|
165 end }
|
|
bsw/jbe@19
|
166
|
|
bsw@373
|
167 end }
|
|
bsw@373
|
168
|
|
bsw@373
|
169 slot.put("<br /")
|
|
bsw@373
|
170 end }
|
|
bsw@373
|
171
|
|
bsw@373
|
172 end
|
|
bsw@373
|
173
|
|
bsw@373
|
174 end }
|