webmcp
annotate framework/env/ui/paginate.lua @ 4:5e32ef998acf
Version 1.0.4
ui.link{...} with POST target can now be parameterized with BOTH content and text to allow HTML content for JavaScript browsers and a text-only version for accessiblity
Changes related to database selectors:
- Support for row-based locking
- New method :count(), caching and returning the number of rows, which WOULD have been returned by :exec()
- Bugfix: WHERE and HAVING expressions are now enclosed in parenthesis to avoid problems with operator precedence
ui.script{...} now supports external .js files
Changes in langtool.lua to cope with escaped new-line chars (\n)
ui.link{...} with POST target can now be parameterized with BOTH content and text to allow HTML content for JavaScript browsers and a text-only version for accessiblity
Changes related to database selectors:
- Support for row-based locking
- New method :count(), caching and returning the number of rows, which WOULD have been returned by :exec()
- Bugfix: WHERE and HAVING expressions are now enclosed in parenthesis to avoid problems with operator precedence
ui.script{...} now supports external .js files
Changes in langtool.lua to cope with escaped new-line chars (\n)
| author | jbe/bsw |
|---|---|
| date | Fri Dec 25 12:00:00 2009 +0100 (2009-12-25) |
| parents | 72860d232f32 |
| children | f02e14d1e69e |
| rev | line source |
|---|---|
| jbe/bsw@0 | 1 --[[-- |
| jbe/bsw@0 | 2 ui.paginate{ |
| jbe/bsw@0 | 3 selector = selector, -- a selector for items from the database |
| jbe/bsw@0 | 4 per_page = per_page, -- items per page, defaults to 10 |
| jbe/bsw@0 | 5 name = name, -- name of the CGI get variable, defaults to "page" |
| jbe@1 | 6 page = page, -- directly specify a page, and ignore 'name' parameter |
| jbe/bsw@0 | 7 content = function() |
| jbe/bsw@0 | 8 ... -- code block which should be encapsulated with page selection links |
| jbe/bsw@0 | 9 end |
| jbe/bsw@0 | 10 } |
| jbe/bsw@0 | 11 |
| jbe@1 | 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. |
| jbe@1 | 13 |
| jbe/bsw@0 | 14 --]]-- |
| jbe/bsw@0 | 15 |
| jbe/bsw@0 | 16 function ui.paginate(args) |
| jbe/bsw@0 | 17 local selector = args.selector |
| jbe/bsw@0 | 18 local per_page = args.per_page or 10 |
| jbe/bsw@0 | 19 local name = args.name or 'page' |
| jbe/bsw@0 | 20 local content = args.content |
| jbe/bsw@0 | 21 local count_selector = selector:get_db_conn():new_selector() |
| jbe/bsw@0 | 22 count_selector:add_field('count(1)') |
| jbe/bsw@0 | 23 count_selector:add_from(selector) |
| jbe/bsw@0 | 24 count_selector:single_object_mode() |
| jbe/bsw@0 | 25 local count = count_selector:exec().count |
| jbe/bsw@0 | 26 local page_count = math.floor((count - 1) / per_page) + 1 |
| jbe@1 | 27 local current_page = atom.integer:load(cgi.params[name]) or 1 |
| jbe/bsw@2 | 28 if current_page > page_count then |
| jbe/bsw@2 | 29 current_page = page_count |
| jbe/bsw@2 | 30 end |
| jbe/bsw@0 | 31 selector:limit(per_page) |
| jbe/bsw@0 | 32 selector:offset((current_page - 1) * per_page) |
| jbe/bsw@0 | 33 local id = param.get_id_cgi() |
| jbe/bsw@0 | 34 local params = param.get_all_cgi() |
| jbe/bsw@0 | 35 local function pagination_elements() |
| jbe/bsw@0 | 36 if page_count > 1 then |
| jbe/bsw@0 | 37 for page = 1, page_count do |
| jbe/bsw@0 | 38 if page > 1 then |
| jbe/bsw@0 | 39 slot.put(" ") |
| jbe/bsw@0 | 40 end |
| jbe/bsw@0 | 41 params[name] = page |
| jbe/bsw@0 | 42 local attr = {} |
| jbe/bsw@0 | 43 if current_page == page then |
| jbe/bsw@0 | 44 attr.class = "active" |
| jbe/bsw@0 | 45 end |
| jbe/bsw@0 | 46 ui.link{ |
| jbe/bsw@0 | 47 attr = attr, |
| jbe/bsw@0 | 48 module = request.get_module(), |
| jbe/bsw@0 | 49 view = request.get_view(), |
| jbe/bsw@0 | 50 id = id, |
| jbe/bsw@0 | 51 params = params, |
| jbe/bsw@0 | 52 text = tostring(page) |
| jbe/bsw@0 | 53 } |
| jbe/bsw@0 | 54 end |
| jbe/bsw@0 | 55 end |
| jbe/bsw@0 | 56 end |
| jbe/bsw@0 | 57 ui.container{ |
| jbe/bsw@0 | 58 attr = { class = 'ui_paginate' }, |
| jbe/bsw@0 | 59 content = function() |
| jbe/bsw@0 | 60 ui.container{ |
| jbe/bsw@0 | 61 attr = { class = 'ui_paginate_head ui_paginate_select' }, |
| jbe/bsw@0 | 62 content = pagination_elements |
| jbe/bsw@0 | 63 } |
| jbe/bsw@0 | 64 ui.container{ |
| jbe/bsw@0 | 65 attr = { class = 'ui_paginate_content' }, |
| jbe/bsw@0 | 66 content = content |
| jbe/bsw@0 | 67 } |
| jbe/bsw@0 | 68 ui.container{ |
| jbe/bsw@0 | 69 attr = { class = 'ui_paginate_foot ui_paginate_select' }, |
| jbe/bsw@0 | 70 content = pagination_elements |
| jbe/bsw@0 | 71 } |
| jbe/bsw@0 | 72 end |
| jbe/bsw@0 | 73 } |
| jbe/bsw@0 | 74 end |