diff options
Diffstat (limited to 'db-viewtable-html.lsp')
| -rw-r--r-- | db-viewtable-html.lsp | 51 |
1 files changed, 43 insertions, 8 deletions
diff --git a/db-viewtable-html.lsp b/db-viewtable-html.lsp index d67ec37..283d624 100644 --- a/db-viewtable-html.lsp +++ b/db-viewtable-html.lsp @@ -21,13 +21,34 @@ }); </script> -<% local redir = cfe({ type="hidden", value=page_info.orig_action.."?table="..html.url_encode(form.value.table.value) }) %> +<% +local redir = cfe({ type="hidden", value=page_info.orig_action.."?table="..html.url_encode(form.value.table.value) }) +local keyvalues = {table=form.value.table.value} +if form.value.connection then + keyvalues.connection = {} + for n,v in pairs(form.value.connection.value) do + redir.value = redir.value.."&connection."..n.."="..html.url_encode(v.value) + keyvalues.connection[n] = v.value + end +end +keyvalues.redir = redir.value +%> <% htmlviewfunctions.displaycommandresults({"deletetableentry", "updatetableentry"}, session) %> <% htmlviewfunctions.displaycommandresults({"createtableentry"}, session, true) %> -<% form.label = form.label.." - "..form.value.table.value %> +<% if form.value.table.value ~= "" then form.label = form.label.." - "..form.value.table.value end %> <% local header_level = htmlviewfunctions.displaysectionstart(form, page_info) %> +<% +local header_level2 = htmlviewfunctions.incrementheader(header_level) +htmlviewfunctions.displayformstart(form, page_info) +if form.value.connection and next(form.value.connection.value) ~= nil then + htmlviewfunctions.displayitem(form.value.connection, page_info, header_level2, "connection") +end +htmlviewfunctions.displayitem(form.value.table, page_info, header_level2, "table") +form.option = "Update" +htmlviewfunctions.displayformend(form, htmlviewfunctions.incrementheader(header_level)) +%> <table id="list" class="tablesorter"><thead> <tr> <% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %> @@ -38,18 +59,32 @@ <% end %> </tr> </thead><tbody> -<% local table = cfe({ type="hidden", value=form.value.table.value }) %> -<% local id = cfe({ type="hidden" }) %> +<% -- We will reuse the form connection structure to pass key values to updatetableentry and deletetableentry +local formvalues = {} +if form.value.connection then + formvalues.connection = form.value.connection + for n,v in pairs(form.value.connection.value) do v.type="hidden" end +end +if form.value.fields then + formvalues.fields = cfe({ type="group", value={} }) + for i,f in ipairs(form.value.fields.value) do + formvalues.fields.value[f] = cfe({ type="hidden" }) + end +end +formvalues.table = form.value.table +form.value.table.type = "hidden" +formvalues.redir = redir +%> <% for i,tableentry in ipairs(form.value.entries.value) do %> <tr> <% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %> - <% id.value = tableentry.id %> + <% formvalues.fields.value.id.value = tableentry.id %> <td> <% if viewlibrary.check_permission("updatetableentry") then %> - <% htmlviewfunctions.displayitem(cfe({type="link", value={table=table, id=id, redir=redir}, label="", option="Update", action="updatetableentry"}), page_info, -1) %> + <% htmlviewfunctions.displayitem(cfe({type="link", value=formvalues, label="", option="Update", action="updatetableentry"}), page_info, -1) %> <% end %> <% if viewlibrary.check_permission("deletetableentry") then %> - <% htmlviewfunctions.displayitem(cfe({type="form", value={table=table, id=id, redir=redir}, label="", option="Delete", action="deletetableentry", class="deletetableentry"}), page_info, -1) %> + <% htmlviewfunctions.displayitem(cfe({type="form", value=formvalues, label="", option="Delete", action="deletetableentry", class="deletetableentry"}), page_info, -1) %> <% end %> </td> <% end %> @@ -66,5 +101,5 @@ <% 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, redir=redir.value}) + viewlibrary.dispatch_component("createtableentry", keyvalues) end %> |