summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorTed Trask <ttrask01@yahoo.com>2013-11-19 15:19:25 +0000
committerTed Trask <ttrask01@yahoo.com>2013-11-19 15:19:25 +0000
commit636c0e5eca04816c42c07337aa6ac8704e0271d5 (patch)
treedb4824e21157c0de7fce372175ddaa81354b059f
parent6a84042c9cb4235fb29acee39fb778b5c0016e5b (diff)
downloadacf-weblog-636c0e5eca04816c42c07337aa6ac8704e0271d5.tar.bz2
acf-weblog-636c0e5eca04816c42c07337aa6ac8704e0271d5.tar.xz
Modify adhocquery to use tablesorter for formatting result
-rw-r--r--weblog-adhocquery-html.lsp48
1 files changed, 39 insertions, 9 deletions
diff --git a/weblog-adhocquery-html.lsp b/weblog-adhocquery-html.lsp
index 0c24cd7..192dcf3 100644
--- a/weblog-adhocquery-html.lsp
+++ b/weblog-adhocquery-html.lsp
@@ -5,31 +5,61 @@ html = require("acf.html")
<style type="text/css">
#content table { border-collapse: collapse; width: 100%; }
- #content table td { white-space: normal; padding-right:20px; border-bottom:1px solid #999; }
- #content table tr.mark { background: #E9E9E9; }
+ #content table td { white-space: normal; padding-right:20px; }
</style>
+<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>
+
+<%
+local tablesortercolumns = {}
+if form.value.types then
+
+ for i,t in ipairs(form.value.types.value) do
+ if string.match(t, "undefined") then
+ tablesortercolumns[#tablesortercolumns+1] = (i-1)..":{sorter: false}"
+ end
+ end
+end
+%>
+
+<script type="text/javascript">
+ $(function(){
+ $("#adhocresult").tablesorter({headers: {<%= table.concat(tablesortercolumns, ", ") %>}, widgets: ['zebra']});
+ });
+</script>
+
<% if form.value.result then %>
<H1><%= html.html_escape(form.value.result.label) %></H1>
<% if #form.value.result.value == 0 then %>
<p>No results, try adjusting query</p>
<% else %>
- <TABLE>
+ <TABLE id="adhocresult" class="tablesorter">
+ <THEAD>
<TR style="font-weight:bold;">
<% for i,name in ipairs(form.value.names.value) do %>
- <TD class="header"><%= html.html_escape(name) %></TD>
+ <TH class="header"><%= html.html_escape(name) %></TH>
<% end %>
</TR>
- <% for i,row in ipairs(form.value.result.value) do
- local a,b = math.modf((i/2))
- local mark = ''
- if (b == 0) then mark=' class="mark"' end %>
- <TR<%= mark %>>
+ </THEAD>
+ <TBODY>
+ <% for i,row in ipairs(form.value.result.value) do %>
+ <TR>
<% for j,name in ipairs(form.value.names.value) do %>
<TD><%= html.html_escape(row[name]) %></TD>
<% end %>
</TR>
<% end %>
+ <TBODY>
</TABLE>
<% if viewlibrary.check_permission("downloadadhocquery") then %>