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