Lines 19-29
Link Here
|
19 |
<style type="text/css"> |
19 |
<style type="text/css"> |
20 |
#sql { width: 90%; height: 9em;} |
20 |
#sql { width: 90%; height: 9em;} |
21 |
</style> |
21 |
</style> |
22 |
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.tablesorter.min.js"></script> |
22 |
[% IF ( saved1 ) %] |
23 |
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.tablesorter.pager.js"></script> |
23 |
<link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" /> |
|
|
24 |
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.dataTables.min.js"></script> |
25 |
[% INCLUDE 'datatables-strings.inc' %] |
26 |
<script type="text/javascript" src="[% themelang %]/js/datatables.js"></script> |
27 |
[% END %] |
24 |
|
28 |
|
25 |
<script type="text/javascript"> |
29 |
<script type="text/javascript"> |
26 |
//<![CDATA[ |
30 |
//<![CDATA[ |
|
|
31 |
[% IF (dateformat == 'metric' && saved1) %] |
32 |
dt_add_type_uk_date(); |
33 |
[% END %] |
27 |
var group_subgroups = {}; |
34 |
var group_subgroups = {}; |
28 |
var no_subgroup_label = _( "(None)" ); |
35 |
var no_subgroup_label = _( "(None)" ); |
29 |
function load_group_subgroups () { |
36 |
function load_group_subgroups () { |
Lines 59-80
$(document).ready(function(){
Link Here
|
59 |
return false; |
66 |
return false; |
60 |
} |
67 |
} |
61 |
}); |
68 |
}); |
|
|
69 |
// call the datatables plugin |
70 |
$("#table_reports").dataTable($.extend(true, {}, dataTablesDefaults, { |
71 |
"aoColumnDefs": [ |
72 |
{ "aTargets": [ -1, -2, -3, -4 ], "bSortable": false, "bSearchable": false }, |
73 |
], |
74 |
"aaSorting": [[ 1, "asc" ]], |
75 |
"aLengthMenu": [[10, 20, 50, 100, -1], [10, 20, 50, 100, "All"]], |
76 |
"iDisplayLength": 20, |
77 |
"sPaginationType": "four_button" |
78 |
})); |
62 |
[% END %] |
79 |
[% END %] |
63 |
// call the tablesorter plugin |
|
|
64 |
$("#table_reports").tablesorter({ |
65 |
widgets : ['zebra'], |
66 |
sortList: [[1,0]], |
67 |
headers: { |
68 |
10: { sorter: false}, |
69 |
11: { sorter: false}, |
70 |
12: { sorter: false}, |
71 |
13: { sorter: false} |
72 |
} |
73 |
}).tablesorterPager({ |
74 |
container: $("#pagertable_reports"), |
75 |
positionFixed: false, |
76 |
size: 20 |
77 |
}); |
78 |
// redefine the datepicker's default because reports require ISO |
80 |
// redefine the datepicker's default because reports require ISO |
79 |
// http://jqueryui.com/demos/datepicker/#option-dateFormat |
81 |
// http://jqueryui.com/demos/datepicker/#option-dateFormat |
80 |
$( ".datepicker" ).datepicker( "option", "dateFormat", "yy-mm-dd" ); |
82 |
$( ".datepicker" ).datepicker( "option", "dateFormat", "yy-mm-dd" ); |
Lines 147-156
canned reports and writing custom SQL reports.</p>
Link Here
|
147 |
[% IF ( saved1 ) %] |
149 |
[% IF ( saved1 ) %] |
148 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
150 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
149 |
|
151 |
|
150 |
<div id="pagertable_reports"> |
|
|
151 |
[% INCLUDE 'table-pager.inc' perpage='20' %] |
152 |
</div> |
153 |
|
154 |
<table id="table_reports" class="tablesorter"> |
152 |
<table id="table_reports" class="tablesorter"> |
155 |
<thead> |
153 |
<thead> |
156 |
<tr> |
154 |
<tr> |
157 |
- |
|
|