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.name", nil, { "grouped" })

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

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

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

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

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

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

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

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

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

65 :add_where{ "area.active" }

66 :add_order_by("area.name")

67

68 if filter_unit == "my_areas" then

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

70 end

71

72 local area_count = areas_selector:count()

73

74 local max_area_count = Area:new_selector()

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

76 :add_where{ "area.active" }

77 :count()

78 local more_area_count = max_area_count - area_count

79 local delegated_count = Area:new_selector()

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

81 :add_where{ "area.active" }

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

83 :add_where{ "membership.member_id ISNULL" }

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

85 :add_where{ "delegation.trustee_id NOTNULL" }

86 :count()

87

88 local more_area_text

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

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

91 elseif area_count == 0 and more_area_count > 0 then

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

93 elseif area_count > 0 and more_area_count == 1 then

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

95 elseif area_count > 0 and more_area_count > 0 then

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

97 end

98 local delegated_text

99 if delegated_count == 1 then

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

101 elseif delegated_count > 0 then

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

103 end

104

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

106

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

108

109 if area_count > 0 then

110 local areas = areas_selector:exec()

111 for i, area in ipairs(areas) do

112 execute.view{

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

114 area = area

115 }

116 }

117 end

118 end

119

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

121 more_area_count > 0 then

122

123 end

124 end }

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

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

127 if more_area_text then

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

129 end

130 if delegated_text then

131 slot.put(" · ")

132 ui.tag{ content = delegated_text }

133 end

134 end }

135 end }

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

137 end

138 end

139

140