|
Lines 19-24
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="<!-- TMPL_VAR name="themelang" -->/lib/jquery/plugins/jquery.tablesorter.min.js"></script> |
| 23 |
<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/jquery/plugins/jquery.tablesorter.pager.js"></script> |
| 24 |
|
| 22 |
<script type="text/javascript"> |
25 |
<script type="text/javascript"> |
| 23 |
//<![CDATA[ |
26 |
//<![CDATA[ |
| 24 |
$(document).ready(function(){ |
27 |
$(document).ready(function(){ |
|
Lines 38-43
$(document).ready(function(){
Link Here
|
| 38 |
} |
41 |
} |
| 39 |
}); |
42 |
}); |
| 40 |
<!-- /TMPL_IF --> |
43 |
<!-- /TMPL_IF --> |
|
|
44 |
// call the tablesorter plugin |
| 45 |
$("#table_reports").tablesorter({ |
| 46 |
sortList: [[1,0]], |
| 47 |
headers: { |
| 48 |
6: { sorter: false}, |
| 49 |
7: { sorter: false}, |
| 50 |
8: { sorter: false}, |
| 51 |
9: { sorter: false}, |
| 52 |
10: { sorter: false} |
| 53 |
} |
| 54 |
}).tablesorterPager({ |
| 55 |
container: $("#pagertable_reports"), |
| 56 |
positionFixed: false, |
| 57 |
size: 50 |
| 58 |
}); |
| 41 |
}); |
59 |
}); |
| 42 |
//]]> |
60 |
//]]> |
| 43 |
</script> |
61 |
</script> |
|
Lines 106-114
canned reports and writing custom SQL reports.</p>
Link Here
|
| 106 |
<!-- TMPL_IF NAME="saved1" --> |
124 |
<!-- TMPL_IF NAME="saved1" --> |
| 107 |
<!-- TMPL_IF NAME="savedreports" --><h1>Saved Reports</h1> |
125 |
<!-- TMPL_IF NAME="savedreports" --><h1>Saved Reports</h1> |
| 108 |
<p>Choose the report to run from the list</p> |
126 |
<p>Choose the report to run from the list</p> |
| 109 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
127 |
|
| 110 |
<table> |
128 |
<span id="pagertable_reports" class="pager"> |
| 111 |
<tr><th>ID</th><th>Report Name</th><th>Type</th><th>Notes</th><th>Author</th><th>Creation Date</th><th>Saved Results</th><th>Saved SQL</th><th colspan="3"> </th></tr> |
129 |
<form class="formpager"> <strong>page(s)</strong> : |
|
|
130 |
<img src="<!-- TMPL_VAR name="interface" -->/prog/img/first.png" class="first"/> |
| 131 |
<img src="<!-- TMPL_VAR name="interface" -->/prog/img/prev.png" class="prev"/> |
| 132 |
<input type="text" size="5" class="pagedisplay"/> |
| 133 |
<img src="<!-- TMPL_VAR name="interface" -->/prog/img/next.png" class="next"/> |
| 134 |
<img src="<!-- TMPL_VAR name="interface" -->/prog/img/last.png" class="last"/> |
| 135 |
, entries/page: |
| 136 |
<select class="pagesize"> |
| 137 |
<option value="10">10</option> |
| 138 |
<option value="25" selected="selected">25</option> |
| 139 |
<option value="50">50</option> |
| 140 |
<option value="100">100</option> |
| 141 |
<option value="200">200</option> |
| 142 |
</select> |
| 143 |
</form> |
| 144 |
</span> |
| 145 |
|
| 146 |
<table id="table_reports" class="tablesorter"> |
| 147 |
<thead> |
| 148 |
<tr> |
| 149 |
<th>ID</th> |
| 150 |
<th>Report Name</th> |
| 151 |
<th>Type</th> |
| 152 |
<th>Notes</th> |
| 153 |
<th>Author</th> |
| 154 |
<th>Creation Date</th> |
| 155 |
<th>Saved Results</th> |
| 156 |
<th>Saved SQL</th> |
| 157 |
<th> </th> |
| 158 |
<th> </th> |
| 159 |
</tr> |
| 160 |
</thead> |
| 161 |
<tbody> |
| 112 |
<!-- TMPL_LOOP NAME="savedreports" --> |
162 |
<!-- TMPL_LOOP NAME="savedreports" --> |
| 113 |
<!-- TMPL_UNLESS NAME="__odd__" --><tr class="highlight"><!-- TMPL_ELSE --><tr><!-- /TMPL_UNLESS --> |
163 |
<!-- TMPL_UNLESS NAME="__odd__" --><tr class="highlight"><!-- TMPL_ELSE --><tr><!-- /TMPL_UNLESS --> |
| 114 |
<td><!-- TMPL_VAR NAME="id" --></td> |
164 |
<td><!-- TMPL_VAR NAME="id" --></td> |
|
Lines 120-139
canned reports and writing custom SQL reports.</p>
Link Here
|
| 120 |
<td><!-- TMPL_IF NAME="date_run" --><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="date_run" --></a><!-- /TMPL_IF --> |
170 |
<td><!-- TMPL_IF NAME="date_run" --><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="date_run" --></a><!-- /TMPL_IF --> |
| 121 |
</td> |
171 |
</td> |
| 122 |
<td> |
172 |
<td> |
| 123 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Show%20SQL">Show SQL</a> |
173 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Show%20SQL">Show</a> |
| 124 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
174 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
| 125 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Edit%20SQL">Edit SQL</a> |
175 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Edit%20SQL">Edit</a> |
| 126 |
<!-- /TMPL_IF --> |
176 |
<!-- /TMPL_IF --> |
| 127 |
</td> |
177 |
</td> |
| 128 |
<td><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Run%20this%20report">Run</a></td> |
178 |
<td><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Run%20this%20report">Run</a> |
| 129 |
<td><a href="/cgi-bin/koha/tools/scheduler.pl?id=<!-- TMPL_VAR NAME="id" -->">Schedule</a></td> |
179 |
<a href="/cgi-bin/koha/tools/scheduler.pl?id=<!-- TMPL_VAR NAME="id" -->">Schedule</a></td> |
| 130 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
180 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
| 131 |
<td><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Delete%20Saved">Delete</a></td> |
181 |
<td><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Delete%20Saved">Delete</a></td> |
| 132 |
<!-- /TMPL_IF --> |
182 |
<!-- /TMPL_IF --> |
| 133 |
</tr> |
183 |
</tr> |
| 134 |
<!-- /TMPL_LOOP --> |
184 |
<!-- /TMPL_LOOP --> |
|
|
185 |
</tbody> |
| 135 |
</table> |
186 |
</table> |
| 136 |
</form> |
|
|
| 137 |
<!-- TMPL_ELSE --><h4>There are no saved reports. |
187 |
<!-- TMPL_ELSE --><h4>There are no saved reports. |
| 138 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
188 |
<!-- TMPL_IF name="CAN_user_reports_create_reports" --> |
| 139 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build new?</a> |
189 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build new?</a> |
| 140 |
- |
|
|