|
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 |
- |
|
|