1 --[[--

2 ui.paginate{

3 selector = selector, -- a selector for items from the database

4 per_page = per_page, -- items per page, defaults to 10

5 name = name, -- name of the CGI get variable, defaults to "page"

6 page = page, -- directly specify a page, and ignore 'name' parameter

7 content = function()

8 ... -- code block which should be encapsulated with page selection links

9 end

10 }

11

12 This function preceeds and appends the output of the given 'content' function with page selection links. The passed selector will be modified to show only a limited amount ('per_page') of items. The currently displayed page will be determined directly by cgi.params, and not via the param.get(...) function, in order to pass page selections automatically to sub-views.

13

14 --]]--

15

16 function ui.paginate(args)

17 local selector = args.selector

18 local per_page = args.per_page or 10

19 local name = args.name or 'page'

20 local content = args.content

21 local count_selector = selector:get_db_conn():new_selector()

22 count_selector:add_field('count(1)')

23 count_selector:add_from(selector)

24 count_selector:single_object_mode()

25 local count = count_selector:exec().count

26 local page_count = 1

27 if count > 0 then

28 page_count = math.floor((count - 1) / per_page) + 1

29 end

30 local current_page = atom.integer:load(cgi.params[name]) or 1

31 if current_page > page_count then

32 current_page = page_count

33 end

34 selector:limit(per_page)

35 selector:offset((current_page - 1) * per_page)

36 local id = param.get_id_cgi()

37 local params = param.get_all_cgi()

38 local function pagination_elements()

39 if page_count > 1 then

40 for page = 1, page_count do

41 if page > 1 then

42 slot.put(" ")

43 end

44 params[name] = page

45 local attr = {}

46 if current_page == page then

47 attr.class = "active"

48 end

49 local partial

50 if ui.is_partial_loading_enabled() then

51 partial = {

52 params = {

53 [name] = tostring(page)

54 }

55 }

56 end

57 ui.link{

58 attr = attr,

59 module = request.get_module(),

60 view = request.get_view(),

61 id = id,

62 params = params,

63 text = tostring(page),

64 partial = partial

65 }

66 end

67 end

68 end

69 ui.container{

70 attr = { class = 'ui_paginate' },

71 content = function()

72 ui.container{

73 attr = { class = 'ui_paginate_head ui_paginate_select' },

74 content = pagination_elements

75 }

76 ui.container{

77 attr = { class = 'ui_paginate_content' },

78 content = content

79 }

80 ui.container{

81 attr = { class = 'ui_paginate_foot ui_paginate_select' },

82 content = pagination_elements

83 }

84 end

85 }

86 end