From 7737dbd5def8fe3f38553e6e5c91bfc389fcae64 Mon Sep 17 00:00:00 2001
From: Ted Trask <ttrask01@yahoo.com>
Date: Sat, 8 Jan 2011 19:54:34 +0000
Subject: Added actions for listing and editing database tables. Relys on
 kamctlrc.

---
 kamailio-viewtable-html.lsp | 48 +++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 kamailio-viewtable-html.lsp

(limited to 'kamailio-viewtable-html.lsp')

diff --git a/kamailio-viewtable-html.lsp b/kamailio-viewtable-html.lsp
new file mode 100644
index 0000000..7d0aa41
--- /dev/null
+++ b/kamailio-viewtable-html.lsp
@@ -0,0 +1,48 @@
+<% local form, viewlibrary, page_info, session = ... %>
+<% require("viewfunctions") %>
+
+<% displaycommandresults({"deletetableentry", "updatetableentry"}, session) %>
+<% 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;">
+	<% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %>
+		<TD style="padding-right:20px;white-space:nowrap;" class="header">Action</TD>
+	<% 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>
+	<% end %>
+	</TR>
+
+<% for i,tableentry in ipairs(form.value.entries.value) do %>
+	<TR>
+	<% if viewlibrary.check_permission("deletetableentry") or viewlibrary.check_permission("updatetableentry") then %>
+		<TD style="padding-right:20px;white-space:nowrap;">
+	<% 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>
+	<% 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" value="Delete"></form>
+	<% end %>
+		</TD>
+	<% end %>
+	<% for i,f in ipairs(form.value.fields.value) do %>
+		<TD><%= html.html_escape(tableentry[f]) %></TD>
+	<% end %>
+	</TR>
+<% end %>
+</TABLE>
+</DL>
+
+<% if viewlibrary and viewlibrary.dispatch_component and viewlibrary.check_permission("createtableentry") then
+	viewlibrary.dispatch_component("createtableentry", {table=form.value.table.value})
+end %>
-- 
cgit v1.2.3