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

2

3 local unit = param.get ( "unit", "table" )

4

5 local areas_selector = Area:new_selector()

6 :reset_fields()

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

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

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

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

11 :add_where{ "area.active" }

12 :add_order_by("area.name")

13

14 if member then

15 areas_selector:left_join (

16 "membership", nil,

17 { "membership.area_id = area.id AND membership.member_id = ?", member.id }

18 )

19 areas_selector:add_field("membership.member_id NOTNULL", "subscribed", { "grouped" })

20 end

21

22

23 local areas = areas_selector:exec()

24 if member then

25 unit:load_delegation_info_once_for_member_id(member.id)

26 areas:load_delegation_info_once_for_member_id(member.id)

27 end

28

29

30 ui.sidebar ( "tab-whatcanido", function ()

31

32 ui.sidebarHead( function ()

33 ui.heading {

34 level = 2, content = _"Subject areas"

35 }

36 end )

37

38 if #areas > 0 then

39

40 ui.container { class = "areas", content = function ()

41

42 for i, area in ipairs ( areas ) do

43

44 ui.container { attr = { class = "sidebarRow" }, content = function ()

45

46 if member then

47 local delegation = Delegation:by_pk(member.id, nil, area.id, nil)

48

49 if delegation then

50 ui.link {

51 module = "delegation", view = "show", params = {

52 area_id = area.id

53 },

54 attr = { class = "delegation_info" },

55 content = function ()

56 ui.delegation(delegation.trustee_id, delegation.trustee_id and delegation.trustee.name)

57 end

58 }

59 end

60 end

61

62 if area.subscribed then

63 ui.image { attr = { class = "icon16 star" }, static = "icons/48/star.png" }

64 end

65

66 ui.link {

67 attr = { class = "area" },

68 module = "area", view = "show", id = area.id,

69 content = area.name

70 }

71

72 end } -- ui.tag "li"

73

74 end -- for i, area

75

76 end } -- ui.tag "ul"

77

78 end -- if #areas > 0

79

80 end ) -- ui.sidebar