diff options
Diffstat (limited to 'db-viewtable-html.lsp')
| -rw-r--r-- | db-viewtable-html.lsp | 70 |
1 files changed, 42 insertions, 28 deletions
diff --git a/db-viewtable-html.lsp b/db-viewtable-html.lsp index e1531d0..1d64ece 100644 --- a/db-viewtable-html.lsp +++ b/db-viewtable-html.lsp @@ -1,54 +1,68 @@ <% local form, viewlibrary, page_info, session = ... %> -<% require("htmlviewfunctions") %> +<% htmlviewfunctions = require("htmlviewfunctions") %> <% html = require("acf.html") %> +<script type="text/javascript"> + if (typeof jQuery == 'undefined') { + document.write('<script type="text/javascript" src="<%= html.html_escape(page_info.wwwprefix) %>/js/jquery-latest.js"><\/script>'); + } +</script> + +<script type="text/javascript"> + if (typeof $.tablesorter == 'undefined') { + document.write('<script type="text/javascript" src="<%= html.html_escape(page_info.wwwprefix) %>/js/jquery.tablesorter.js"><\/script>'); + } +</script> + +<script type="text/javascript"> + $(document).ready(function() { + $("#list").tablesorter({widgets: ['zebra']}); + $(".deletetableentry").click(function(){ return confirm("Are you sure you want to delete this entry?")}); + }); +</script> + <% htmlviewfunctions.displaycommandresults({"deletetableentry", "updatetableentry"}, session) %> <% htmlviewfunctions.displaycommandresults({"createtableentry"}, session, true) %> -<H1><%= html.html_escape(form.label) %> - <%= html.html_escape(form.value.table.value) %></H1> -<DL> -<TABLE> - <TR style="background:#eee;font-weight:bold;"> +<% form.label = form.label.." - "..form.value.table.value %> +<% local header_level = htmlviewfunctions.displaysectionstart(form, page_info) %> +<table id="list" class="tablesorter"><thead> + <tr> <% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %> - <TD style="padding-right:20px;white-space:nowrap;" class="header">Action</TD> + <th>Action</th> <% end %> <% for i,f in ipairs(form.value.fields.value) do %> - <TD style="padding-right:20px;white-space:nowrap;" class="header"><%= html.html_escape(f) %></TD> + <th><%= html.html_escape(f) %></th> <% end %> - </TR> - + </tr> +</thead><tbody> +<% local redir = cfe({ type="hidden", value=page_info.orig_action.."?table="..form.value.table.value }) %> +<% local table = cfe({ type="hidden", value=form.value.table.value }) %> +<% local id = cfe({ type="hidden" }) %> <% for i,tableentry in ipairs(form.value.entries.value) do %> - <TR> + <tr> <% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %> - <TD style="padding-right:20px;white-space:nowrap;"> + <% id.value = tableentry.id %> + <td> <% if viewlibrary.check_permission("updatetableentry") then %> - <form action="updatetableentry" method="POST"> - <input class="hidden" type="hidden" name="table" value="<%= html.html_escape(form.value.table.value) %>"> - <input class="hidden" type="hidden" name="id" value="<%= html.html_escape(tableentry.id) %>"> - <input class="hidden" type="hidden" name="redir" value="<%= html.html_escape(page_info.orig_action.."?table="..form.value.table.value) %>"> - <input class="submit" type="submit" value="Update"></form> + <% htmlviewfunctions.displayitem(cfe({type="link", value={table=table, id=id, redir=redir}, label="", option="Update", action="updatetableentry"}), page_info, -1) %> <% end %> <% if viewlibrary.check_permission("deletetableentry") then %> - <form action="deletetableentry" method="POST"> - <input class="hidden" type="hidden" name="table" value="<%= html.html_escape(form.value.table.value) %>"> - <input class="hidden" type="hidden" name="id" value="<%= html.html_escape(tableentry.id) %>"> - <input class="submit" type="submit" name="submit" value="Delete"></form> + <% htmlviewfunctions.displayitem(cfe({type="form", value={table=table, id=id}, label="", option="Delete", action="deletetableentry", class="deletetableentry"}), page_info, -1) %> <% end %> - </TD> + </td> <% end %> <% for i,f in ipairs(form.value.fields.value) do %> - <TD><%= html.html_escape(tableentry[f]) %></TD> + <td><%= html.html_escape(tableentry[f]) %></td> <% end %> - </TR> -<% end %> -</TABLE> -<% if form.errtxt then %> -<p class="error"><%= html.html_escape(form.errtxt) %></p> + </tr> <% end %> +</tbody></table> +<% htmlviewfunctions.displayinfo(form) %> <% if #form.value.entries.value == 0 then %> <p>No entries found</p> <% end %> -</DL> +<% htmlviewfunctions.displaysectionend(header_level) %> <% if page_info.action == "viewtable" and viewlibrary and viewlibrary.dispatch_component and viewlibrary.check_permission("createtableentry") then viewlibrary.dispatch_component("createtableentry", {table=form.value.table.value}) |