1 local member = param.get("member", "table")

2 local for_member = param.get("for_member", atom.boolean)

3 local filter_unit = param.get_all_cgi()["filter_unit"] or "my_areas"

4

5 if not for_member then

6

7 ui.container{ attr = { class = "ui_filter" }, content = function()

8 ui.container{ attr = { class = "ui_filter_head" }, content = function()

9

10 ui.link{

11 attr = { class = filter_unit == "my_areas" and "ui_tabs_link active" or nil },

12 text = _"My areas",

13 module = "index", view = "index", params = { filter_unit = "my_areas" }

14 }

15

16 slot.put(" ")

17

18 ui.link{

19 attr = { class = filter_unit == "my_units" and "ui_tabs_link active" or nil },

20 text = _"All areas in my units",

21 module = "index", view = "index", params = { filter_unit = "my_units" }

22 }

23

24 slot.put(" ")

25

26 ui.link{

27 attr = { class = filter_unit == "global" and "active" or nil },

28 text = _"All units",

29 module = "index", view = "index", params = { filter_unit = "global" }

30 }

31 end }

32 end }

33 end

34

35 if not for_member then

36 if filter_unit == "global" then

37 execute.view{ module = "unit", view = "_list" }

38 return

39 end

40

41 end

42

43 local units = Unit:new_selector():add_order_by("name"):exec()

44

45 if member then

46 units:load_delegation_info_once_for_member_id(member.id)

47 end

48

49 for i, unit in ipairs(units) do

50 if member:has_voting_right_for_unit_id(unit.id) then

51

52 local areas_selector = Area:new_selector()

53 :reset_fields()

54 :add_field("area.id", nil, { "grouped" })

55 :add_field("area.unit_id", nil, { "grouped" })

56 :add_field("area.name", nil, { "grouped" })

57 :add_field("member_weight", nil, { "grouped" })

58 :add_field("direct_member_count", nil, { "grouped" })

59 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted ISNULL AND issue.closed ISNULL)", "issues_new_count")

60 :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")

61 :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")

62 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL)", "issues_voting_count")

63 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed NOTNULL)", "issues_finished_count")

64 :add_field("(SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen ISNULL AND issue.closed NOTNULL)", "issues_cancelled_count")

65 :add_where{ "area.unit_id = ?", unit.id }

66 :add_where{ "area.active" }

67 :add_order_by("area.name")

68

69 if filter_unit == "my_areas" then

70 areas_selector:join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ?", member.id })

71 else

72 areas_selector:join("privilege", nil, { "privilege.unit_id = area.unit_id AND privilege.member_id = ? AND privilege.voting_right", member.id })

73 end

74

75 local area_count = areas_selector:count()

76

77 local max_area_count = Area:new_selector()

78 :add_where{ "area.unit_id = ?", unit.id }

79 :add_where{ "area.active" }

80 :count()

81 local more_area_count = max_area_count - area_count

82 local delegated_count = Area:new_selector()

83 :add_where{ "area.unit_id = ?", unit.id }

84 :add_where{ "area.active" }

85 :left_join("membership", nil, { "membership.area_id = area.id AND membership.member_id = ?", member.id } )

86 :add_where{ "membership.member_id ISNULL" }

87 :join("delegation", nil, { "delegation.area_id = area.id AND delegation.truster_id = ?", member.id } )

88 :add_where{ "delegation.trustee_id NOTNULL" }

89 :count()

90

91 local more_area_text

92 if area_count == 0 and more_area_count == 1 then

93 more_area_text = _("You are not participating in the only area of the unit")

94 elseif area_count == 0 and more_area_count > 0 then

95 more_area_text = _("You are not participating in any of the #{count} areas in this unit", { count = more_area_count })

96 elseif area_count > 0 and more_area_count == 1 then

97 more_area_text = _("One more area in this unit")

98 elseif area_count > 0 and more_area_count > 0 then

99 more_area_text = _("#{count} more areas in this unit", { count = more_area_count })

100 end

101 local delegated_text

102 if delegated_count == 1 then

103 delegated_text = _("One of them have an area delegation set", { count = delegated_count })

104 elseif delegated_count > 0 then

105 delegated_text = _("#{count} of them have an area delegation set", { count = delegated_count })

106 end

107

108 ui.container{ attr = { class = "area_list" }, content = function()

109 execute.view{ module = "unit", view = "_head", params = { unit = unit, show_content = true } }

110

111 if area_count > 0 then

112 local areas = areas_selector:exec()

113

114 areas:load_delegation_info_once_for_member_id(member.id)

115

116 for i, area in ipairs(areas) do

117 execute.view{

118 module = "area", view = "_list_entry", params = {

119 area = area

120 }

121 }

122 end

123 end

124

125 if area_count == 0 and member:has_voting_right_for_unit_id(unit.id) or

126 more_area_count > 0 then

127

128 end

129 end }

130 ui.container{ attr = { class = "area", style="margin-top: 1ex; margin-left: 10px;" }, content = function()

131 ui.container{ attr = { class = "title" }, content = function()

132 if more_area_text then

133 ui.link{ module = "unit", view = "show", id = unit.id, text = more_area_text }

134 end

135 if delegated_text then

136 slot.put(" · ")

137 ui.tag{ content = delegated_text }

138 end

139 end }

140 end }

141 slot.put("<br />")

142 end

143 end

144

145