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

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

25 26
<% htmlviewfunctions.displaycommandresults({"createdatabase"}, session) %>

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
<% local header_level = htmlviewfunctions.displaysectionstart(form, page_info) %>
<% htmlviewfunctions.displayinfo(form) %>
<% if #form.value>0 then %>
<table id="listtables" class="tablesorter"><thead>
        <tr>
		<th>Action</th>
		<th>Table</th>
	</tr>
</thead><tbody>
<% local table = cfe({ type="hidden" }) %>
<% for i,tab in ipairs(form.value) do %>
	<% table.value = tab %>
	<tr>
		<td>
		<% if viewlibrary.check_permission("viewtable") then %>
			<% htmlviewfunctions.displayitem(cfe({type="link", value={table=table}, label="", option="View", action="viewtable"}), page_info, -1) %>
		<% end %>
		</td>
		<td><%= html.html_escape(tab) %></td>
	</tr>
47
<% end %>
48 49 50 51 52
</tbody></table>
<% elseif viewlibrary.check_permission("createdatabase") then %>
	<% htmlviewfunctions.displayitem(cfe({type="form", value={}, label="Create Database", option="Create", action="createdatabase" }), page_info, 0) %>
<% else %>
<p>No tables found</p>
53
<% end %>
54
<% htmlviewfunctions.displaysectionend(header_level) %>