db-listdatabases-html.lsp 2.51 KB
Newer Older
1
<% local form, viewlibrary, page_info, session = ... %>
2
<% htmlviewfunctions = require("htmlviewfunctions") %>
3 4
<% html = require("acf.html") %>

5
<% if form.value.databases and #form.value.databases.value>0 then %>
6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
<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() {
		$("#listdatabases").tablesorter({headers: {0:{sorter: false}}, widgets: ['zebra']});
	});
</script>
<% end %>

<% local header_level = htmlviewfunctions.displaysectionstart(form, page_info) %>
26 27 28 29 30 31 32 33 34 35 36 37 38
<% if form.value.connection then
	-- hide the database, user, and password, since we don't need them to list databases
	form.value.connection.value.database = nil
	form.value.connection.value.user = nil
	form.value.connection.value.password = nil
end %>
<% if form.value.connection and next(form.value.connection.value) ~= nil then
	htmlviewfunctions.displayformstart(form, page_info)
	htmlviewfunctions.displayitem(form.value.connection, page_info, htmlviewfunctions.incrementheader(header_level), "connection")
	form.option = "Update"
	htmlviewfunctions.displayformend(form, htmlviewfunctions.incrementheader(header_level))
end %>
<% if form.value.databases and #form.value.databases.value>0 then %>
39 40 41 42 43 44
<table id="listdatabases" class="tablesorter"><thead>
        <tr>
		<th>Action</th>
		<th>Database</th>
	</tr>
</thead><tbody>
45 46 47 48 49 50 51 52 53 54
<% -- We need to pass the connection key values to listtables
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
form.value.connection.value.database = cfe({ type="hidden" })
%>
<% for i,dbase in ipairs(form.value.databases.value) do %>
	<% formvalues.connection.value.database.value = dbase %>
55 56 57
	<tr>
		<td>
		<% if viewlibrary.check_permission("listtables") then %>
58
			<% htmlviewfunctions.displayitem(cfe({type="link", value=formvalues, label="", option="View", action="listtables"}), page_info, -1) %>
59 60 61 62
		<% end %>
		</td>
		<td><%= html.html_escape(dbase) %></td>
	</tr>
63
<% end %>
64 65 66
</tbody></table>
<% else %>
<p>No databases found</p>
67
<% end %>
68
<% htmlviewfunctions.displaysectionend(header_level) %>