|
Lines 1-3
Link Here
|
|
|
1 |
[% PROCESS 'i18n.inc' %] |
| 1 |
[% USE Asset %] |
2 |
[% USE Asset %] |
| 2 |
[% USE KohaDates %] |
3 |
[% USE KohaDates %] |
| 3 |
[% USE Koha %] |
4 |
[% USE Koha %] |
|
Lines 5-33
Link Here
|
| 5 |
[% SET footerjs = 1 %] |
6 |
[% SET footerjs = 1 %] |
| 6 |
[%- BLOCK area_name -%] |
7 |
[%- BLOCK area_name -%] |
| 7 |
[%- SWITCH area -%] |
8 |
[%- SWITCH area -%] |
| 8 |
[%- CASE 'CIRC' -%]Circulation |
9 |
[%- CASE 'CIRC' -%][% t('Circulation') %] |
| 9 |
[%- CASE 'CAT' -%]Catalog |
10 |
[%- CASE 'CAT' -%][% t('Catalog') %] |
| 10 |
[%- CASE 'PAT' -%]Patrons |
11 |
[%- CASE 'PAT' -%][% t('Patrons') %] |
| 11 |
[%- CASE 'ACQ' -%]Acquisitions |
12 |
[%- CASE 'ACQ' -%][% t('Acquisitions') %] |
| 12 |
[%- CASE 'ACC' -%]Accounts |
13 |
[%- CASE 'ACC' -%][% t('Accounts') %] |
| 13 |
[%- CASE 'SER' -%]Serials |
14 |
[%- CASE 'SER' -%][% t('Serials') %] |
| 14 |
[%- END -%] |
15 |
[%- END -%] |
| 15 |
[%- END -%] |
16 |
[%- END -%] |
| 16 |
|
17 |
|
| 17 |
[% INCLUDE 'doc-head-open.inc' %] |
18 |
[% INCLUDE 'doc-head-open.inc' %] |
| 18 |
|
19 |
|
| 19 |
<title>Koha › Reports › Guided reports wizard [%- IF ( saved1 ) -%]› Saved reports |
20 |
<title>[% t('Koha › Reports › Guided reports wizard') %] [%- IF ( saved1 ) -%][% t('› Saved reports') %] |
| 20 |
[%- ELSIF ( create ) -%]› Create from SQL |
21 |
[%- ELSIF ( create ) -%][% t('› Create from SQL') %] |
| 21 |
[%- ELSIF ( showsql ) -%]› Saved reports › SQL view |
22 |
[%- ELSIF ( showsql ) -%][% t('› Saved reports › SQL view') %] |
| 22 |
[%- ELSIF ( execute ) -%]› Saved reports › [% name %] Report |
23 |
[%- ELSIF ( execute ) -%][% t('› Saved reports ›') %] [% name %] [% t('Report') %] |
| 23 |
[%- ELSIF ( editsql ) -%]› Saved reports › Edit SQL report |
24 |
[%- ELSIF ( editsql ) -%][% t('› Saved reports › Edit SQL report') %] |
| 24 |
[%- END -%] |
25 |
[%- END -%] |
| 25 |
[%- IF ( build1 ) -%]› Build a report, step 1 of 6: Choose a module |
26 |
[%- IF ( build1 ) -%][% t('› Build a report, step 1 of 6: Choose a module') %] |
| 26 |
[%- ELSIF ( build2 ) -%]› Build a report, step 2 of 6: Pick a report type |
27 |
[%- ELSIF ( build2 ) -%][% t('› Build a report, step 2 of 6: Pick a report type') %] |
| 27 |
[%- ELSIF ( build3 ) -%]› Build a report, step 3 of 6: Select columns for display |
28 |
[%- ELSIF ( build3 ) -%][% t('› Build a report, step 3 of 6: Select columns for display') %] |
| 28 |
[%- ELSIF ( build4 ) -%]› Build a report, step 4 of 6: Select criteria to limit on |
29 |
[%- ELSIF ( build4 ) -%][% t('› Build a report, step 4 of 6: Select criteria to limit on') %] |
| 29 |
[%- ELSIF ( build5 ) -%]› Build a report, step 5 of 6: Pick which columns to total |
30 |
[%- ELSIF ( build5 ) -%][% t('› Build a report, step 5 of 6: Pick which columns to total') %] |
| 30 |
[%- ELSIF ( build6 ) -%]› Build a report, step 6 of 6: Select how you want the report ordered |
31 |
[%- ELSIF ( build6 ) -%][% t('› Build a report, step 6 of 6: Select how you want the report ordered') %] |
| 31 |
[%- END -%]</title> |
32 |
[%- END -%]</title> |
| 32 |
|
33 |
|
| 33 |
[% INCLUDE 'doc-head-close.inc' %] |
34 |
[% INCLUDE 'doc-head-close.inc' %] |
|
Lines 59-80
Link Here
|
| 59 |
[% INCLUDE 'header.inc' %] |
60 |
[% INCLUDE 'header.inc' %] |
| 60 |
[% INCLUDE 'circ-search.inc' %] |
61 |
[% INCLUDE 'circ-search.inc' %] |
| 61 |
|
62 |
|
| 62 |
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> |
63 |
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> |
| 63 |
› <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> |
64 |
› <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> |
| 64 |
› <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a> |
65 |
› <a href="/cgi-bin/koha/reports/guided_reports.pl">[% t('Guided reports wizard') %]</a> |
| 65 |
|
66 |
|
| 66 |
[% IF ( saved1 ) %]› Saved reports |
67 |
[% IF ( saved1 ) %][% t('› Saved reports') %] |
| 67 |
[% ELSIF ( create ) %]› Create from SQL |
68 |
[% ELSIF ( create ) %][% t('› Create from SQL') %] |
| 68 |
[% ELSIF ( showsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › SQL view |
69 |
[% ELSIF ( showsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> [% t('› SQL view') %] |
| 69 |
[% ELSIF ( editsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › Edit SQL report |
70 |
[% ELSIF ( editsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> [% t('› Edit SQL report') %] |
| 70 |
[% ELSIF ( execute ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> › <em>[% name %]</em> Report |
71 |
[% ELSIF ( execute ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> › <em>[% name %]</em> [% t('Report') %] |
| 71 |
[% ELSIF ( build1 || build2 || build3 || build4 || build5 || build6 ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build a report</a> |
72 |
[% ELSIF ( build1 || build2 || build3 || build4 || build5 || build6 ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">[% t('Build a report') %]</a> |
| 72 |
[% IF ( build1 ) %]› Step 1 of 6: Choose a module |
73 |
[% IF ( build1 ) %][% t('› Step 1 of 6: Choose a module') %] |
| 73 |
[% ELSIF ( build2 ) %]› Step 2 of 6: Pick a report type |
74 |
[% ELSIF ( build2 ) %][% t('› Step 2 of 6: Pick a report type') %] |
| 74 |
[% ELSIF ( build3 ) %]› Step 3 of 6: Select columns for display |
75 |
[% ELSIF ( build3 ) %][% t('› Step 3 of 6: Select columns for display') %] |
| 75 |
[% ELSIF ( build4 ) %]› Step 4 of 6: Select criteria to limit on |
76 |
[% ELSIF ( build4 ) %][% t('› Step 4 of 6: Select criteria to limit on') %] |
| 76 |
[% ELSIF ( build5 ) %]› Step 5 of 6: Pick which columns to total |
77 |
[% ELSIF ( build5 ) %][% t('› Step 5 of 6: Pick which columns to total') %] |
| 77 |
[% ELSIF ( build6 ) %]› Step 6 of 6: Select how you want the report ordered |
78 |
[% ELSIF ( build6 ) %][% t('› Step 6 of 6: Select how you want the report ordered') %] |
| 78 |
[% END %] |
79 |
[% END %] |
| 79 |
[% END %] |
80 |
[% END %] |
| 80 |
</div> |
81 |
</div> |
|
Lines 84-97
Link Here
|
| 84 |
<div class="modal-content"> |
85 |
<div class="modal-content"> |
| 85 |
<div class="modal-header"> |
86 |
<div class="modal-header"> |
| 86 |
<button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button> |
87 |
<button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button> |
| 87 |
<h3 id="update_sql_label">Update SQL</h3> |
88 |
<h3 id="update_sql_label">[% t('Update SQL') %]</h3> |
| 88 |
</div> |
89 |
</div> |
| 89 |
<div class="modal-body"> |
90 |
<div class="modal-body"> |
| 90 |
<div id="loading"> <img src="[% interface %]/[% theme %]/img/spinner-small.gif" alt="" /> Loading </div> |
91 |
<div id="loading"> <img src="[% interface %]/[% theme %]/img/spinner-small.gif" alt="" /> [% t('Loading') %] </div> |
| 91 |
</div> |
92 |
</div> |
| 92 |
<div class="modal-footer"> |
93 |
<div class="modal-footer"> |
| 93 |
<a href="#" class="btn btn-default" id="update_sql_button" role="button" data-toggle="modal">Update</a> |
94 |
<a href="#" class="btn btn-default" id="update_sql_button" role="button" data-toggle="modal">[% t('Update') %]</a> |
| 94 |
<button class="btn btn-default" data-dismiss="modal" aria-hidden="true">Close</button> |
95 |
<button class="btn btn-default" data-dismiss="modal" aria-hidden="true">[% t('Close') %]</button> |
| 95 |
</div> |
96 |
</div> |
| 96 |
</div> |
97 |
</div> |
| 97 |
</div> |
98 |
</div> |
|
Lines 104-162
Link Here
|
| 104 |
[% INCLUDE "reports-toolbar.inc" %] |
105 |
[% INCLUDE "reports-toolbar.inc" %] |
| 105 |
|
106 |
|
| 106 |
[% IF ( start ) %] |
107 |
[% IF ( start ) %] |
| 107 |
<h2>Guided reports</h2> |
108 |
<h2>[% t('Guided reports') %]</h2> |
| 108 |
<p>Use the guided reports engine to create non standard reports. |
109 |
<p>[% t('Use the guided reports engine to create non standard reports.') %] |
| 109 |
This feature aims to provide some middle ground between the built in |
110 |
[% t('This feature aims to provide some middle ground between the built in') %] |
| 110 |
canned reports and writing custom SQL reports.</p> |
111 |
[% t('canned reports and writing custom SQL reports.') %]</p> |
| 111 |
|
112 |
|
| 112 |
<h3>Build and run reports</h3> |
113 |
<h3>[% t('Build and run reports') %]</h3> |
| 113 |
[% IF ( CAN_user_reports_create_reports ) %] |
114 |
[% IF ( CAN_user_reports_create_reports ) %] |
| 114 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
115 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 115 |
<input type="hidden" name="phase" value="Build new" /> |
116 |
<input type="hidden" name="phase" value="Build new" /> |
| 116 |
<input type="submit" name="submit" value="Build new"/> |
117 |
<input type="submit" name="submit" value="Build new" /> |
| 117 |
</form> |
118 |
</form> |
| 118 |
[% END %] |
119 |
[% END %] |
| 119 |
[% IF ( CAN_user_reports_execute_reports ) %] |
120 |
[% IF ( CAN_user_reports_execute_reports ) %] |
| 120 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
121 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 121 |
<input type="hidden" name="phase" value="Use saved"/> |
122 |
<input type="hidden" name="phase" value="Use saved" /> |
| 122 |
<input type="submit" name="submit" value="Use saved"/> |
123 |
<input type="submit" name="submit" value="Use saved" /> |
| 123 |
</form> |
124 |
</form> |
| 124 |
[% END %] |
125 |
[% END %] |
| 125 |
[% IF ( CAN_user_reports_create_reports ) %] |
126 |
[% IF ( CAN_user_reports_create_reports ) %] |
| 126 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
127 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 127 |
<input type="hidden" name="phase" value="Create report from SQL"/> |
128 |
<input type="hidden" name="phase" value="Create report from SQL" /> |
| 128 |
<input type="submit" name="submit" value="Create report from SQL"/> |
129 |
<input type="submit" name="submit" value="Create report from SQL" /> |
| 129 |
</form> |
130 |
</form> |
| 130 |
[% END %] |
131 |
[% END %] |
| 131 |
<h3>Reports Dictionary</h3> |
132 |
<h3>[% t('Reports Dictionary') %]</h3> |
| 132 |
<p>Use the reports dictionary to define custom criteria to use in your reports</p> |
133 |
<p>[% t('Use the reports dictionary to define custom criteria to use in your reports') %]</p> |
| 133 |
<form action="/cgi-bin/koha/reports/dictionary.pl"> |
134 |
<form action="/cgi-bin/koha/reports/dictionary.pl"> |
| 134 |
<input type="hidden" name="phase" value="View Dictionary"/> |
135 |
<input type="hidden" name="phase" value="View Dictionary" /> |
| 135 |
<input type="submit" name="submit" value="View dictionary"/> |
136 |
<input type="submit" name="submit" value="View dictionary" /> |
| 136 |
</form> |
137 |
</form> |
| 137 |
[% END %] |
138 |
[% END %] |
| 138 |
|
139 |
|
| 139 |
[% IF report_converted %] |
140 |
[% IF report_converted %] |
| 140 |
<div class="dialog message"> |
141 |
<div class="dialog message"> |
| 141 |
The report "[% report_converted %]" has been converted. |
142 |
[% t('The report "') %][% report_converted %][% t('" has been converted.') %] |
| 142 |
</div> |
143 |
</div> |
| 143 |
[% END %] |
144 |
[% END %] |
| 144 |
|
145 |
|
| 145 |
[% IF ( saved1 ) %] |
146 |
[% IF ( saved1 ) %] |
| 146 |
[% IF ( savedreports ) %]<h1>Saved reports</h1> |
147 |
[% IF ( savedreports ) %]<h1>[% t('Saved reports') %]</h1> |
| 147 |
|
148 |
|
| 148 |
<div id="tabs" class="toptabs"> |
149 |
<div id="tabs" class="toptabs"> |
| 149 |
<ul> |
150 |
<ul> |
| 150 |
<li><a href="#reports">All</a></li> |
151 |
<li><a href="#reports">[% t('All') %]</a></li> |
| 151 |
[% FOREACH group IN groups_with_subgroups %] |
152 |
[% FOREACH group IN groups_with_subgroups %] |
| 152 |
<li><a id="[% group.id %]" href="#reports">[% group.name %]</a></li> |
153 |
<li><a id="[% group.id %]" href="#reports">[% group.name %]</a></li> |
| 153 |
[% END %] |
154 |
[% END %] |
| 154 |
</ul> |
155 |
</ul> |
| 155 |
<div id="reports"> |
156 |
<div id="reports"> |
| 156 |
<div id="subgroup_filter_block"> |
157 |
<div id="subgroup_filter_block"> |
| 157 |
<label for="subgroup_filter">Subgroup:</label> |
158 |
<label for="subgroup_filter">[% t('Subgroup:') %]</label> |
| 158 |
<select id="subgroup_filter"> |
159 |
<select id="subgroup_filter"> |
| 159 |
<option value="">All</option> |
160 |
<option value="">[% t('All') %]</option> |
| 160 |
</select> |
161 |
</select> |
| 161 |
</div> |
162 |
</div> |
| 162 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post"> |
163 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post"> |
|
Lines 164-186
canned reports and writing custom SQL reports.</p>
Link Here
|
| 164 |
<table id="table_reports"> |
165 |
<table id="table_reports"> |
| 165 |
<thead> |
166 |
<thead> |
| 166 |
<tr> |
167 |
<tr> |
| 167 |
<th> </th> |
168 |
<th> </th> |
| 168 |
<th>ID</th> |
169 |
<th>[% t('ID') %]</th> |
| 169 |
<th>Report name</th> |
170 |
<th>[% t('Report name') %]</th> |
| 170 |
<th>Type</th> |
171 |
<th>[% t('Type') %]</th> |
| 171 |
<th>Group</th> |
172 |
<th>[% t('Group') %]</th> |
| 172 |
<th>Subgroup</th> |
173 |
<th>[% t('Subgroup') %]</th> |
| 173 |
<th>Notes</th> |
174 |
<th>[% t('Notes') %]</th> |
| 174 |
<th>Author</th> |
175 |
<th>[% t('Author') %]</th> |
| 175 |
<th class="title-string">Creation date</th> |
176 |
<th class="title-string">[% t('Creation date') %]</th> |
| 176 |
<th class="title-string">Last edit</th> |
177 |
<th class="title-string">[% t('Last edit') %]</th> |
| 177 |
<th class="title-string">Last run</th> |
178 |
<th class="title-string">[% t('Last run') %]</th> |
| 178 |
<th class="report_public">Public</th> |
179 |
<th class="report_public">[% t('Public') %]</th> |
| 179 |
<th class="report_json_url">JSON URL</th> |
180 |
<th class="report_json_url">[% t('JSON URL') %]</th> |
| 180 |
[% IF (usecache) %] <th>Cache expiry (seconds)</th> [% END %] |
181 |
[% IF (usecache) %] <th>[% t('Cache expiry (seconds)') %]</th> [% END %] |
| 181 |
<th>Saved results</th> |
182 |
<th>[% t('Saved results') %]</th> |
| 182 |
[% IF has_obsolete_reports %]<th>Update</th>[% END %] |
183 |
[% IF has_obsolete_reports %]<th>[% t('Update') %]</th>[% END %] |
| 183 |
<th>Actions</th> |
184 |
<th>[% t('Actions') %]</th> |
| 184 |
</tr> |
185 |
</tr> |
| 185 |
</thead> |
186 |
</thead> |
| 186 |
<tbody> |
187 |
<tbody> |
|
Lines 209-238
canned reports and writing custom SQL reports.</p>
Link Here
|
| 209 |
<td><span title="[% savedreport.last_run %]">[% savedreport.last_run | $KohaDates with_hours => 1 %]</span></td> |
210 |
<td><span title="[% savedreport.last_run %]">[% savedreport.last_run | $KohaDates with_hours => 1 %]</span></td> |
| 210 |
<td class="report_public"> |
211 |
<td class="report_public"> |
| 211 |
[% IF (savedreport.public) %] |
212 |
[% IF (savedreport.public) %] |
| 212 |
Yes |
213 |
[% t('Yes') %] |
| 213 |
[% ELSE %] |
214 |
[% ELSE %] |
| 214 |
No |
215 |
[% t('No') %] |
| 215 |
[% END %] |
216 |
[% END %] |
| 216 |
</td> |
217 |
</td> |
| 217 |
<td class="report_json_url"> |
218 |
<td class="report_json_url"> |
| 218 |
[% IF (savedreport.public) %] |
219 |
[% IF (savedreport.public) %] |
| 219 |
<a href="[% OPACBaseURL %]/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% OPACBaseURL %]/cgi-bin/koha/svc/report?id=[% savedreport.id | html %]</a> |
220 |
<a href="[% OPACBaseURL %]/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% OPACBaseURL %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %]</a> |
| 220 |
[% ELSE %] |
221 |
[% ELSE %] |
| 221 |
<a href="/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% Koha.Preference('staffClientBaseURL') %]/cgi-bin/koha/svc/report?id=[% savedreport.id | html %]</a> |
222 |
<a href="/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% Koha.Preference('staffClientBaseURL') %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %]</a> |
| 222 |
[% END %] |
223 |
[% END %] |
| 223 |
</td> |
224 |
</td> |
| 224 |
[% IF (usecache) %] <td>[% savedreport.cache_expiry %]</td> [% END %] |
225 |
[% IF (usecache) %] <td>[% savedreport.cache_expiry %]</td> [% END %] |
| 225 |
<td> |
226 |
<td> |
| 226 |
[% FOR result IN savedreport.results %] |
227 |
[% FOR result IN savedreport.results %] |
| 227 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=[% result.id %]">[% result.date_run %]</a> |
228 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=[% result.id %]">[% result.date_run %]</a> |
| 228 |
<br/> |
229 |
<br /> |
| 229 |
[% END %] |
230 |
[% END %] |
| 230 |
</td> |
231 |
</td> |
| 231 |
[% IF has_obsolete_reports %] |
232 |
[% IF has_obsolete_reports %] |
| 232 |
<td> |
233 |
<td> |
| 233 |
[% IF savedreport.seems_obsolete %] |
234 |
[% IF savedreport.seems_obsolete %] |
| 234 |
This report seems obsolete, it uses biblioitems.marcxml field. |
235 |
[% t('This report seems obsolete, it uses biblioitems.marcxml field.') %] |
| 235 |
<a href="/cgi-bin/koha/svc/convert_report?report_id=[% savedreport.id %]" data-report_id="[% savedreport.id %]" class="update_sql btn btn-default btn-xs" title="Update SQL"><i class="fa fa-eye"></i> Update SQL</a> |
236 |
<a href="/cgi-bin/koha/svc/convert_report?report_id=[% savedreport.id %]" data-report_id="[% savedreport.id %]" class="update_sql btn btn-default btn-xs" title="[% t('Update SQL') %]"><i class="fa fa-eye"></i> [% t('Update SQL') %]</a> |
| 236 |
[% END %] |
237 |
[% END %] |
| 237 |
</td> |
238 |
</td> |
| 238 |
[% END %] |
239 |
[% END %] |
|
Lines 240-259
canned reports and writing custom SQL reports.</p>
Link Here
|
| 240 |
<div class="dropup"> |
241 |
<div class="dropup"> |
| 241 |
<div class="btn-group"> |
242 |
<div class="btn-group"> |
| 242 |
[%# There should be no space between these two buttons, it would render badly %] |
243 |
[%# There should be no space between these two buttons, it would render badly %] |
| 243 |
<a class="btn btn-default btn-xs" role="button" |
244 |
<a class="btn btn-default btn-xs" role="button" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Run%20this%20report"><i class="fa fa-play"></i> [% t('Run') %]</a><a class="btn btn-default btn-xs dropdown-toggle" id="reportactions[% savedreport.id %]" role="button" data-toggle="dropdown" href="#"><b class="caret"></b></a> |
| 244 |
href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Run%20this%20report"><i |
|
|
| 245 |
class="fa fa-play"></i> Run</a><a |
| 246 |
class="btn btn-default btn-xs dropdown-toggle" id="reportactions[% savedreport.id %]" role="button" data-toggle="dropdown" |
| 247 |
href="#"><b class="caret"></b></a> |
| 248 |
<ul class="dropdown-menu pull-right" role="menu" aria-labelledby="reportactions[% savedreport.id %]"> |
245 |
<ul class="dropdown-menu pull-right" role="menu" aria-labelledby="reportactions[% savedreport.id %]"> |
| 249 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Show%20SQL"><i class="fa fa-search"></i> Show</a></li> |
246 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Show%20SQL"><i class="fa fa-search"></i> [% t('Show') %]</a></li> |
| 250 |
[% IF ( CAN_user_reports_create_reports ) %] |
247 |
[% IF ( CAN_user_reports_create_reports ) %] |
| 251 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Edit%20SQL"><i class="fa fa-pencil"></i> Edit</a></li> |
248 |
<li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Edit%20SQL"><i class="fa fa-pencil"></i> [% t('Edit') %]</a></li> |
| 252 |
<li><a title="Duplicate this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create report from SQL&sql=[% savedreport.savedsql |uri %]&reportname=[% savedreport.report_name |uri %]&notes=[% savedreport.notes |uri %]"><i class="fa fa-copy"></i> Duplicate</a></li> |
249 |
<li><a title="[% t('Duplicate this saved report') %]" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create report from SQL&sql=[% savedreport.savedsql |uri %]&reportname=[% savedreport.report_name |uri %]¬es=[% savedreport.notes |uri %]"><i class="fa fa-copy"></i> [% t('Duplicate') %]</a></li> |
| 253 |
[% END %] |
250 |
[% END %] |
| 254 |
<li><a href="/cgi-bin/koha/tools/scheduler.pl?id=[% savedreport.id %]"><i class="fa fa-clock-o"></i> Schedule</a></li> |
251 |
<li><a href="/cgi-bin/koha/tools/scheduler.pl?id=[% savedreport.id %]"><i class="fa fa-clock-o"></i> [% t('Schedule') %]</a></li> |
| 255 |
[% IF ( CAN_user_reports_delete_reports ) %] |
252 |
[% IF ( CAN_user_reports_delete_reports ) %] |
| 256 |
<li><a class="confirmdelete" title="Delete this saved report" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Delete%20Saved"><i class="fa fa-trash"></i> Delete</a></li> |
253 |
<li><a class="confirmdelete" title="[% t('Delete this saved report') %]" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Delete%20Saved"><i class="fa fa-trash"></i> [% t('Delete') %]</a></li> |
| 257 |
[% END %] |
254 |
[% END %] |
| 258 |
</ul> |
255 |
</ul> |
| 259 |
</div> |
256 |
</div> |
|
Lines 273-302
canned reports and writing custom SQL reports.</p>
Link Here
|
| 273 |
</div> |
270 |
</div> |
| 274 |
[% ELSE %]<div class="dialog message"> |
271 |
[% ELSE %]<div class="dialog message"> |
| 275 |
[% IF (filter_set || filters.date || filters.author || filters.keyword) %] |
272 |
[% IF (filter_set || filters.date || filters.author || filters.keyword) %] |
| 276 |
<h4>No saved reports match your criteria. </h4> |
273 |
<h4>[% t('No saved reports match your criteria.') %] </h4> |
| 277 |
[% IF ( CAN_user_reports_create_reports ) %] |
274 |
[% IF ( CAN_user_reports_create_reports ) %] |
| 278 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
275 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
| 279 |
<input type="hidden" name="phase" value="Build new" /> |
276 |
<input type="hidden" name="phase" value="Build new" /> |
| 280 |
<button type="submit" class="new"><i class="fa fa-plus"></i> New guided report</button> |
277 |
<button type="submit" class="new"><i class="fa fa-plus"></i> [% t('New guided report') %]</button> |
| 281 |
</form> |
278 |
</form> |
| 282 |
|
279 |
|
| 283 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
280 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
| 284 |
<input type="hidden" name="phase" value="Create report from SQL" /> |
281 |
<input type="hidden" name="phase" value="Create report from SQL" /> |
| 285 |
<button type="submit" class="new"><i class="fa fa-plus"></i> New SQL report</button> |
282 |
<button type="submit" class="new"><i class="fa fa-plus"></i> [% t('New SQL report') %]</button> |
| 286 |
</form> |
283 |
</form> |
| 287 |
|
284 |
|
| 288 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
285 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get"> |
| 289 |
<input type="hidden" name="phase" value="Use saved" /> |
286 |
<input type="hidden" name="phase" value="Use saved" /> |
| 290 |
<input type="hidden" name="filter_set" value="1" /> |
287 |
<input type="hidden" name="filter_set" value="1" /> |
| 291 |
<input type="hidden" name="filter_keyword" value="" /> |
288 |
<input type="hidden" name="filter_keyword" value="" /> |
| 292 |
<button type="submit" class="deny"><i class="fa fa-fw fa-remove"></i> Cancel filter</button> |
289 |
<button type="submit" class="deny"><i class="fa fa-fw fa-remove"></i> [% t('Cancel filter') %]</button> |
| 293 |
</form> |
290 |
</form> |
| 294 |
|
291 |
|
| 295 |
[% END %] |
292 |
[% END %] |
| 296 |
[% ELSE %] |
293 |
[% ELSE %] |
| 297 |
<h4>There are no saved reports. </h4> |
294 |
<h4>[% t('There are no saved reports.') %] </h4> |
| 298 |
[% IF ( CAN_user_reports_create_reports ) %] |
295 |
[% IF ( CAN_user_reports_create_reports ) %] |
| 299 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build a new report?</a> |
296 |
<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">[% t('Build a new report?') %]</a> |
| 300 |
[% END %] |
297 |
[% END %] |
| 301 |
[% END %] |
298 |
[% END %] |
| 302 |
</div> |
299 |
</div> |
|
Lines 307-322
canned reports and writing custom SQL reports.</p>
Link Here
|
| 307 |
[% IF ( build1 ) %] |
304 |
[% IF ( build1 ) %] |
| 308 |
[% IF ( cache_error) %] |
305 |
[% IF ( cache_error) %] |
| 309 |
<div class="dialog alert"> |
306 |
<div class="dialog alert"> |
| 310 |
<b> Please choose a cache_expiry less than 30 days </b> |
307 |
<b> [% t('Please choose a cache_expiry less than 30 days') %] </b> |
| 311 |
</div> |
308 |
</div> |
| 312 |
[% END %] |
309 |
[% END %] |
| 313 |
<h1>Build a report</h1> |
310 |
<h1>[% t('Build a report') %]</h1> |
| 314 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
311 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 315 |
<fieldset class="rows"> |
312 |
<fieldset class="rows"> |
| 316 |
<legend>Step 1 of 6: Choose a module to report on,[% IF (usecache) %] Set cache expiry, [% END %] and choose report visibility </legend> |
313 |
<legend>[% t('Step 1 of 6: Choose a module to report on,') %][% IF (usecache) %] [% t('Set cache expiry,') %] [% END %] [% t('and choose report visibility') %] </legend> |
| 317 |
<ol> |
314 |
<ol> |
| 318 |
<li> |
315 |
<li> |
| 319 |
<label for="area">Choose: </label> |
316 |
<label for="area">[% t('Choose:') %] </label> |
| 320 |
<select name="area" id="area"> |
317 |
<select name="area" id="area"> |
| 321 |
[%- FOREACH area IN areas -%] |
318 |
[%- FOREACH area IN areas -%] |
| 322 |
<option value="[% area %]">[%- PROCESS area_name area=area -%]</option> |
319 |
<option value="[% area %]">[%- PROCESS area_name area=area -%]</option> |
|
Lines 324-347
canned reports and writing custom SQL reports.</p>
Link Here
|
| 324 |
</select> |
321 |
</select> |
| 325 |
</li> |
322 |
</li> |
| 326 |
[% IF (public) %] |
323 |
[% IF (public) %] |
| 327 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">No (default)</option> <option value="1" selected="selected">Yes</option> </select></li> |
324 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li> |
| 328 |
[% ELSE %] |
325 |
[% ELSE %] |
| 329 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selected">No (default)</option> <option value="1">Yes</option> </select></li> |
326 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li> |
| 330 |
[% END %] |
327 |
[% END %] |
| 331 |
[% IF (usecache) %] <li> |
328 |
[% IF (usecache) %] <li> |
| 332 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
329 |
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
| 333 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
330 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
| 334 |
<option value="seconds">Seconds (default)</option> |
331 |
<option value="seconds">[% t('Seconds (default)') %]</option> |
| 335 |
<option value="minutes">Minutes</option> |
332 |
<option value="minutes">[% t('Minutes') %]</option> |
| 336 |
<option value="hours">Hours</option> |
333 |
<option value="hours">[% t('Hours') %]</option> |
| 337 |
<option value="days">Days</option> |
334 |
<option value="days">[% t('Days') %]</option> |
| 338 |
</select> |
335 |
</select> |
| 339 |
</li>[% END %] |
336 |
</li>[% END %] |
| 340 |
</ol> |
337 |
</ol> |
| 341 |
</fieldset> |
338 |
</fieldset> |
| 342 |
<fieldset class="action"> |
339 |
<fieldset class="action"> |
| 343 |
<input type="hidden" name="phase" value="Report on this Area" /> |
340 |
<input type="hidden" name="phase" value="Report on this Area" /> |
| 344 |
<input type="submit" name="submit" value="Next >>" /> |
341 |
<input type="submit" name="submit" value="Next >>" /> |
| 345 |
|
342 |
|
| 346 |
</fieldset> |
343 |
</fieldset> |
| 347 |
</form> |
344 |
</form> |
|
Lines 349-372
canned reports and writing custom SQL reports.</p>
Link Here
|
| 349 |
|
346 |
|
| 350 |
|
347 |
|
| 351 |
[% IF ( build2 ) %] |
348 |
[% IF ( build2 ) %] |
| 352 |
<h1>Build a report</h1> |
349 |
<h1>[% t('Build a report') %]</h1> |
| 353 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
350 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 354 |
<input type="hidden" name="area" value="[% area %]" /> |
351 |
<input type="hidden" name="area" value="[% area %]" /> |
| 355 |
<input type="hidden" name="public" value="[% public %]" /> |
352 |
<input type="hidden" name="public" value="[% public %]" /> |
| 356 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
353 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
| 357 |
<fieldset class="rows"><legend>Step 2 of 6: Pick a report type</legend> |
354 |
<fieldset class="rows"><legend>[% t('Step 2 of 6: Pick a report type') %]</legend> |
| 358 |
<ol><li><label for="types">Choose: </label> |
355 |
<ol><li><label for="types">[% t('Choose:') %] </label> |
| 359 |
<select id="types" name="types"> |
356 |
<select id="types" name="types"> |
| 360 |
<option value="1">Tabular</option> |
357 |
<option value="1">[% t('Tabular') %]</option> |
| 361 |
<option value="2" disabled="disabled">Summary</option> |
358 |
<option value="2" disabled="disabled">[% t('Summary') %]</option> |
| 362 |
<option value="3" disabled="disabled">Matrix</option> |
359 |
<option value="3" disabled="disabled">[% t('Matrix') %]</option> |
| 363 |
</select> |
360 |
</select> |
| 364 |
</li></ol></fieldset> |
361 |
</li></ol></fieldset> |
| 365 |
|
362 |
|
| 366 |
<fieldset class="action"> |
363 |
<fieldset class="action"> |
| 367 |
<input type="hidden" name="phase" value="Choose this type" /> |
364 |
<input type="hidden" name="phase" value="Choose this type" /> |
| 368 |
<input type="button" name="back" value="<< Back" class="goback" /> |
365 |
<input type="button" name="back" value="<< Back" class="goback" /> |
| 369 |
<input type="submit" name="submit" value="Next >>" /> |
366 |
<input type="submit" name="submit" value="Next >>" /> |
| 370 |
</fieldset> |
367 |
</fieldset> |
| 371 |
</form> |
368 |
</form> |
| 372 |
</div> |
369 |
</div> |
|
Lines 381-389
canned reports and writing custom SQL reports.</p>
Link Here
|
| 381 |
[% END %] |
378 |
[% END %] |
| 382 |
|
379 |
|
| 383 |
[% IF ( build3 ) %] |
380 |
[% IF ( build3 ) %] |
| 384 |
<h1>Build a report</h1> |
381 |
<h1>[% t('Build a report') %]</h1> |
| 385 |
<h3>Step 3 of 6: Select columns for display</h3> |
382 |
<h3>[% t('Step 3 of 6: Select columns for display') %]</h3> |
| 386 |
<p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p> |
383 |
<p>[% t('Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.') %]</p> |
| 387 |
|
384 |
|
| 388 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
385 |
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 389 |
<input type="hidden" name="area" value="[% area %]" /> |
386 |
<input type="hidden" name="area" value="[% area %]" /> |
|
Lines 404-410
canned reports and writing custom SQL reports.</p>
Link Here
|
| 404 |
<optgroup label="[% column.table %]"> |
401 |
<optgroup label="[% column.table %]"> |
| 405 |
[% ELSE %] |
402 |
[% ELSE %] |
| 406 |
<option value="[% column.name %]"> |
403 |
<option value="[% column.name %]"> |
| 407 |
[% IF ( column.description ) %][% column.description %] / [% column.name %] |
404 |
[% IF ( column.description ) %][% column.description %] / [% column.name %] |
| 408 |
[% ELSE %] |
405 |
[% ELSE %] |
| 409 |
[% column.name %] |
406 |
[% column.name %] |
| 410 |
[% END %] |
407 |
[% END %] |
|
Lines 414-420
canned reports and writing custom SQL reports.</p>
Link Here
|
| 414 |
</optgroup> |
411 |
</optgroup> |
| 415 |
</select></div> |
412 |
</select></div> |
| 416 |
<div style="width: 6.3em; float: right; margin-top: 100px"><input type="button" name="Add" value="Add" class="button" style="width:6em;" id="addColumn" /><br /> |
413 |
<div style="width: 6.3em; float: right; margin-top: 100px"><input type="button" name="Add" value="Add" class="button" style="width:6em;" id="addColumn" /><br /> |
| 417 |
<input type="button" name="delete" value="<< Delete" class="button" style="width: 6em; margin: 1em 0;" id="delColumn" /></div> |
414 |
<input type="button" name="delete" value="<< Delete" class="button" style="width: 6em; margin: 1em 0;" id="delColumn" /></div> |
| 418 |
</div> |
415 |
</div> |
| 419 |
|
416 |
|
| 420 |
<div class="yui-u"> |
417 |
<div class="yui-u"> |
|
Lines 425-432
canned reports and writing custom SQL reports.</p>
Link Here
|
| 425 |
<div class="yui-g"> |
422 |
<div class="yui-g"> |
| 426 |
<fieldset class="action"> |
423 |
<fieldset class="action"> |
| 427 |
<input type="hidden" name="phase" value="Choose these columns" /> |
424 |
<input type="hidden" name="phase" value="Choose these columns" /> |
| 428 |
<input type="button" name="back" value="<< Back" class="goback" /> |
425 |
<input type="button" name="back" value="<< Back" class="goback" /> |
| 429 |
<input type="submit" name="submit" value="Next >>" /> |
426 |
<input type="submit" name="submit" value="Next >>" /> |
| 430 |
</fieldset> |
427 |
</fieldset> |
| 431 |
</div> |
428 |
</div> |
| 432 |
</form> |
429 |
</form> |
|
Lines 434-447
canned reports and writing custom SQL reports.</p>
Link Here
|
| 434 |
[% END %] |
431 |
[% END %] |
| 435 |
|
432 |
|
| 436 |
[% IF ( build4 ) %] |
433 |
[% IF ( build4 ) %] |
| 437 |
<h1>Build a report</h1> |
434 |
<h1>[% t('Build a report') %]</h1> |
| 438 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" > |
435 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 439 |
<input type="hidden" name="area" value="[% area %]" /> |
436 |
<input type="hidden" name="area" value="[% area %]" /> |
| 440 |
<input type="hidden" name="type" value="[% type %]" /> |
437 |
<input type="hidden" name="type" value="[% type %]" /> |
| 441 |
<input type="hidden" name="column" value="[% column %]" /> |
438 |
<input type="hidden" name="column" value="[% column %]" /> |
| 442 |
<input type="hidden" name="public" value="[% public %]" /> |
439 |
<input type="hidden" name="public" value="[% public %]" /> |
| 443 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
440 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
| 444 |
<fieldset><legend>Step 4 of 6: Select criteria to limit on</legend> |
441 |
<fieldset><legend>[% t('Step 4 of 6: Select criteria to limit on') %]</legend> |
| 445 |
<table> |
442 |
<table> |
| 446 |
[% FOREACH criteri IN criteria %] |
443 |
[% FOREACH criteri IN criteria %] |
| 447 |
<tr> |
444 |
<tr> |
|
Lines 457-472
canned reports and writing custom SQL reports.</p>
Link Here
|
| 457 |
</tr> |
454 |
</tr> |
| 458 |
[% ELSE %] |
455 |
[% ELSE %] |
| 459 |
[% IF ( criteri.textrange ) %] |
456 |
[% IF ( criteri.textrange ) %] |
| 460 |
<td>from |
457 |
<td>[% t('from') %] |
| 461 |
<input type="text" size="10" id="[% criteri.from %]_value" name="[% criteri.from %]_value" value="" /> to |
458 |
<input type="text" size="10" id="[% criteri.from %]_value" name="[% criteri.from %]_value" value="" /> [% t('to') %] |
| 462 |
<input type="text" size="10" id="[% criteri.to %]_value" name="[% criteri.to %]_value" value="" /> |
459 |
<input type="text" size="10" id="[% criteri.to %]_value" name="[% criteri.to %]_value" value="" /> |
| 463 |
</td> |
460 |
</td> |
| 464 |
</tr> |
461 |
</tr> |
| 465 |
[% ELSE %] |
462 |
[% ELSE %] |
| 466 |
[% IF ( criteri.daterange ) %] |
463 |
[% IF ( criteri.daterange ) %] |
| 467 |
<td>from |
464 |
<td>[% t('from') %] |
| 468 |
<input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" class="datepickerfrom" /> |
465 |
<input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" class="datepickerfrom" /> |
| 469 |
to |
466 |
[% t('to') %] |
| 470 |
<input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" class="datepickerto" /> |
467 |
<input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" class="datepickerto" /> |
| 471 |
<span class="hint">[% INCLUDE 'date-format.inc' %]</span> |
468 |
<span class="hint">[% INCLUDE 'date-format.inc' %]</span> |
| 472 |
</td> |
469 |
</td> |
|
Lines 475-481
canned reports and writing custom SQL reports.</p>
Link Here
|
| 475 |
<td> |
472 |
<td> |
| 476 |
<select name="[% criteri.name %]_value"> |
473 |
<select name="[% criteri.name %]_value"> |
| 477 |
[% FOREACH value IN criteri.values %] |
474 |
[% FOREACH value IN criteri.values %] |
| 478 |
<option value="[% value.availablevalues %]">[% IF ( value.default ) %]Default[% ELSE %][% value.display_value |html %][% END %]</option> |
475 |
<option value="[% value.availablevalues %]">[% IF ( value.default ) %][% t('Default') %][% ELSE %][% value.display_value |html %][% END %]</option> |
| 479 |
[% END %] |
476 |
[% END %] |
| 480 |
</select> |
477 |
</select> |
| 481 |
</td> |
478 |
</td> |
|
Lines 488-494
canned reports and writing custom SQL reports.</p>
Link Here
|
| 488 |
</fieldset> |
485 |
</fieldset> |
| 489 |
|
486 |
|
| 490 |
[% IF ( definitions ) %] |
487 |
[% IF ( definitions ) %] |
| 491 |
<fieldset><legend>Dictionary definitions</legend> |
488 |
<fieldset><legend>[% t('Dictionary definitions') %]</legend> |
| 492 |
<table> |
489 |
<table> |
| 493 |
[% FOREACH definition IN definitions %] |
490 |
[% FOREACH definition IN definitions %] |
| 494 |
<tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> |
491 |
<tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr> |
|
Lines 498-512
canned reports and writing custom SQL reports.</p>
Link Here
|
| 498 |
[% END %] |
495 |
[% END %] |
| 499 |
|
496 |
|
| 500 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose these criteria" /> |
497 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose these criteria" /> |
| 501 |
<input type="button" name="back" value="<< Back" class="goback" /> |
498 |
<input type="button" name="back" value="<< Back" class="goback" /> |
| 502 |
<input type="submit" name="submit" value="Next >>" /> </fieldset> |
499 |
<input type="submit" name="submit" value="Next >>" /> </fieldset> |
| 503 |
</form> |
500 |
</form> |
| 504 |
[% END %] |
501 |
[% END %] |
| 505 |
|
502 |
|
| 506 |
|
503 |
|
| 507 |
[% IF ( build5 ) %] |
504 |
[% IF ( build5 ) %] |
| 508 |
<h1>Build a report</h1> |
505 |
<h1>[% t('Build a report') %]</h1> |
| 509 |
<h3>Step 5 of 6: Pick which columns to total</h3> |
506 |
<h3>[% t('Step 5 of 6: Pick which columns to total') %]</h3> |
| 510 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
507 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 511 |
<input type="hidden" name="area" value="[% area %]" /> |
508 |
<input type="hidden" name="area" value="[% area %]" /> |
| 512 |
<input type="hidden" name="type" value="[% type %]" /> |
509 |
<input type="hidden" name="type" value="[% type %]" /> |
|
Lines 530-544
canned reports and writing custom SQL reports.</p>
Link Here
|
| 530 |
</table></fieldset> |
527 |
</table></fieldset> |
| 531 |
|
528 |
|
| 532 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" /> |
529 |
<fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" /> |
| 533 |
<input type="button" name="back" value="<< Back" class="goback" /> |
530 |
<input type="button" name="back" value="<< Back" class="goback" /> |
| 534 |
<input type="submit" name="submit" value="Next >>" /></fieldset> |
531 |
<input type="submit" name="submit" value="Next >>" /></fieldset> |
| 535 |
</form> |
532 |
</form> |
| 536 |
[% END %] |
533 |
[% END %] |
| 537 |
|
534 |
|
| 538 |
|
535 |
|
| 539 |
[% IF ( build6 ) %] |
536 |
[% IF ( build6 ) %] |
| 540 |
<h1>Build a report</h1> |
537 |
<h1>[% t('Build a report') %]</h1> |
| 541 |
<h3>Step 6 of 6: Choose how you want the report ordered</h3> |
538 |
<h3>[% t('Step 6 of 6: Choose how you want the report ordered') %]</h3> |
| 542 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
539 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 543 |
<input type="hidden" name="area" value="[% area %]" /> |
540 |
<input type="hidden" name="area" value="[% area %]" /> |
| 544 |
<input type="hidden" name="type" value="[% type %]" /> |
541 |
<input type="hidden" name="type" value="[% type %]" /> |
|
Lines 569-576
canned reports and writing custom SQL reports.</p>
Link Here
|
| 569 |
|
566 |
|
| 570 |
|
567 |
|
| 571 |
[% IF ( showreport ) %] |
568 |
[% IF ( showreport ) %] |
| 572 |
<h1>Confirm custom report</h1> |
569 |
<h1>[% t('Confirm custom report') %]</h1> |
| 573 |
<p>Your report will be generated with the following SQL statement.</p> |
570 |
<p>[% t('Your report will be generated with the following SQL statement.') %]</p> |
| 574 |
<p> |
571 |
<p> |
| 575 |
[% sql |html %] |
572 |
[% sql |html %] |
| 576 |
</p> |
573 |
</p> |
|
Lines 580-586
canned reports and writing custom SQL reports.</p>
Link Here
|
| 580 |
<input type="hidden" name="type" value="[% type %]" /> |
577 |
<input type="hidden" name="type" value="[% type %]" /> |
| 581 |
<input type="hidden" name="public" value="[% public %]" /> |
578 |
<input type="hidden" name="public" value="[% public %]" /> |
| 582 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
579 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
| 583 |
<p>You will need to save the report before you can execute it</p> |
580 |
<p>[% t('You will need to save the report before you can execute it') %]</p> |
| 584 |
<fieldset class="action"><input type="hidden" name="phase" value="Save" /> |
581 |
<fieldset class="action"><input type="hidden" name="phase" value="Save" /> |
| 585 |
<input type="submit" name="submit" value="Save" /> </fieldset> |
582 |
<input type="submit" name="submit" value="Save" /> </fieldset> |
| 586 |
</form> |
583 |
</form> |
|
Lines 594-604
canned reports and writing custom SQL reports.</p>
Link Here
|
| 594 |
<input type="hidden" name="public" value="[% public %]" /> |
591 |
<input type="hidden" name="public" value="[% public %]" /> |
| 595 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
592 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
| 596 |
<fieldset class="rows"> |
593 |
<fieldset class="rows"> |
| 597 |
<legend>Save your custom report</legend> |
594 |
<legend>[% t('Save your custom report') %]</legend> |
| 598 |
<ol> |
595 |
<ol> |
| 599 |
<li><label for="reportname" class="required">Report name: </label><input type="text" id="reportname" name="reportname" class="required" required="required" /> <span class="required">Required</span></li> |
596 |
<li><label for="reportname" class="required">[% t('Report name:') %] </label><input type="text" id="reportname" name="reportname" class="required" required="required" /> <span class="required">[% t('Required') %]</span></li> |
| 600 |
[% PROCESS group_and_subgroup_selection %] |
597 |
[% PROCESS group_and_subgroup_selection %] |
| 601 |
<li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li> |
598 |
<li><label for="notes">[% t('Notes:') %]</label> <textarea name="notes" id="notes"></textarea></li> |
| 602 |
</ol></fieldset> |
599 |
</ol></fieldset> |
| 603 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
600 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
| 604 |
<input type="submit" name="submit" value="Save report" /></fieldset> |
601 |
<input type="submit" name="submit" value="Save report" /></fieldset> |
|
Lines 607-665
canned reports and writing custom SQL reports.</p>
Link Here
|
| 607 |
|
604 |
|
| 608 |
[% IF ( warn_authval_problem ) %] |
605 |
[% IF ( warn_authval_problem ) %] |
| 609 |
<div class="dialog alert"> |
606 |
<div class="dialog alert"> |
| 610 |
<h3>Errors found when processing parameters for report: [% name %]</h3> |
607 |
<h3>[% t('Errors found when processing parameters for report:') %] [% name %]</h3> |
| 611 |
[% FOREACH problematic_authval IN problematic_authvals %] |
608 |
[% FOREACH problematic_authval IN problematic_authvals %] |
| 612 |
<p> |
609 |
<p> |
| 613 |
<strong>[% problematic_authval.name %]:</strong> The authorized value category (<strong>[% problematic_authval.authval %]</strong>) |
610 |
<strong>[% problematic_authval.name %]:</strong> [% t('The authorized value category (') %]<strong>[% problematic_authval.authval %]</strong>) |
| 614 |
you selected does not exist. |
611 |
[% t('you selected does not exist.') %] |
| 615 |
</p> |
612 |
</p> |
| 616 |
[% END %] |
613 |
[% END %] |
| 617 |
<!-- Save Anyway Form --> |
614 |
<!-- Save Anyway Form --> |
| 618 |
<form action='/cgi-bin/koha/reports/guided_reports.pl'> |
615 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 619 |
<!--Every parameter the user issued is provided as a hidden field for recovery--> |
616 |
<!--Every parameter the user issued is provided as a hidden field for recovery--> |
| 620 |
<input type='hidden' name='id' value='[% id %]' /> |
617 |
<input type="hidden" name="id" value="[% id %]" /> |
| 621 |
<input type='hidden' name='sql' value='[% sql %]' /> |
618 |
<input type="hidden" name="sql" value="[% sql %]" /> |
| 622 |
<input type='hidden' name='reportname' value='[% reportname %]' /> |
619 |
<input type="hidden" name="reportname" value="[% reportname %]" /> |
| 623 |
<input type='hidden' name='group' value='[% group %]' /> |
620 |
<input type="hidden" name="group" value="[% group %]" /> |
| 624 |
<input type='hidden' name='subgroup' value='[% subgroup %]' /> |
621 |
<input type="hidden" name="subgroup" value="[% subgroup %]" /> |
| 625 |
<input type='hidden' name='notes' value='[% notes %]' /> |
622 |
<input type="hidden" name="notes" value="[% notes %]" /> |
| 626 |
<input type='hidden' name='cache_expiry' value='[% cache_expiry %]' /> |
623 |
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" /> |
| 627 |
<input type='hidden' name='cache_expiry_units' value='[% cache_expiry_units %]' /> |
624 |
<input type="hidden" name="cache_expiry_units" value="[% cache_expiry_units %]" /> |
| 628 |
<input type='hidden' name='public' value='[% public %]' /> |
625 |
<input type="hidden" name="public" value="[% public %]" /> |
| 629 |
[% IF ( phase_update) %] |
626 |
[% IF ( phase_update) %] |
| 630 |
<input type='hidden' name='phase' value='Update SQL' /> |
627 |
<input type="hidden" name="phase" value="Update SQL" /> |
| 631 |
<button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> Save anyway</button> |
628 |
<button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> [% t('Save anyway') %]</button> |
| 632 |
[% ELSIF ( phase_save) %] |
629 |
[% ELSIF ( phase_save) %] |
| 633 |
<input type='hidden' name='area' value='[% area %]' /> |
630 |
<input type="hidden" name="area" value="[% area %]" /> |
| 634 |
<input type='hidden' name='phase' value='Save Report' /> |
631 |
<input type="hidden" name="phase" value="Save Report" /> |
| 635 |
<button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> Save anyway</button> |
632 |
<button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> [% t('Save anyway') %]</button> |
| 636 |
[% END %] |
633 |
[% END %] |
| 637 |
</form> |
634 |
</form> |
| 638 |
<!-- Go back to editing --> |
635 |
<!-- Go back to editing --> |
| 639 |
<form action='/cgi-bin/koha/reports/guided_reports.pl'> |
636 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 640 |
<button type="button" class="new goback"><i class="fa fa-fw fa-pencil"></i> Edit SQL</button> |
637 |
<button type="button" class="new goback"><i class="fa fa-fw fa-pencil"></i> [% t('Edit SQL') %]</button> |
| 641 |
</form> |
638 |
</form> |
| 642 |
</div> |
639 |
</div> |
| 643 |
[% END %] |
640 |
[% END %] |
| 644 |
|
641 |
|
| 645 |
[% IF ( enter_params ) %] |
642 |
[% IF ( enter_params ) %] |
| 646 |
<form action='/cgi-bin/koha/reports/guided_reports.pl'> |
643 |
<form action="/cgi-bin/koha/reports/guided_reports.pl"> |
| 647 |
<input type='hidden' name='reports' value="[% reports %]" /> |
644 |
<input type="hidden" name="reports" value="[% reports %]" /> |
| 648 |
[% IF ( auth_val_error ) %] |
645 |
[% IF ( auth_val_error ) %] |
| 649 |
<input type='hidden' name='phase' value='Edit SQL' /> |
646 |
<input type="hidden" name="phase" value="Edit SQL" /> |
| 650 |
<div class="dialog alert"> |
647 |
<div class="dialog alert"> |
| 651 |
<h3>Errors found when processing parameters for report: [% name %]</h3> |
648 |
<h3>[% t('Errors found when processing parameters for report:') %] [% name %]</h3> |
| 652 |
[% FOREACH auth_val_error IN auth_val_errors %] |
649 |
[% FOREACH auth_val_error IN auth_val_errors %] |
| 653 |
<p> |
650 |
<p> |
| 654 |
<strong>[% auth_val_error.entry %]:</strong> The authorized value category (<strong>[% auth_val_error.auth_val %]</strong>) |
651 |
<strong>[% auth_val_error.entry %]:</strong> [% t('The authorized value category (') %]<strong>[% auth_val_error.auth_val %]</strong>) |
| 655 |
you selected does not exist. |
652 |
[% t('you selected does not exist.') %] |
| 656 |
</p> |
653 |
</p> |
| 657 |
[% END %] |
654 |
[% END %] |
| 658 |
</div> |
655 |
</div> |
| 659 |
<fieldset class="action"><input type="submit" value="Edit SQL" /></fieldset> |
656 |
<fieldset class="action"><input type="submit" value="Edit SQL" /></fieldset> |
| 660 |
[% ELSE %] |
657 |
[% ELSE %] |
| 661 |
<input type='hidden' name='phase' value='Run this report' /> |
658 |
<input type="hidden" name="phase" value="Run this report" /> |
| 662 |
<h1>Enter parameters for report [% name %]:</h1> |
659 |
<h1>[% t('Enter parameters for report') %] [% name %]:</h1> |
| 663 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
660 |
[% IF ( notes ) %]<p>[% notes %]</p>[% END %] |
| 664 |
<fieldset class="rows"> |
661 |
<fieldset class="rows"> |
| 665 |
<ol> |
662 |
<ol> |
|
Lines 673-679
canned reports and writing custom SQL reports.</p>
Link Here
|
| 673 |
<li><label for="sql_params[% loop.count %]">[% sql_param.entry %]: </label><input id="sql_params[% loop.count %]" type="text" name="sql_params" /></li> |
670 |
<li><label for="sql_params[% loop.count %]">[% sql_param.entry %]: </label><input id="sql_params[% loop.count %]" type="text" name="sql_params" /></li> |
| 674 |
[% ELSE %] |
671 |
[% ELSE %] |
| 675 |
<li><label for="sql_params_[% sql_param.labelid %]">[% sql_param.entry %]:</label> |
672 |
<li><label for="sql_params_[% sql_param.labelid %]">[% sql_param.entry %]:</label> |
| 676 |
<select name="[%- sql_param.input.name -%]" tabindex="1" size="1" id="[%- sql_param.input.id -%]"> |
673 |
<select name="[%- sql_param.input.name -%]" tabindex="1" size="1" id="[%- sql_param.input.id -%]"> |
| 677 |
[% FOREACH value IN sql_param.input.values %] |
674 |
[% FOREACH value IN sql_param.input.values %] |
| 678 |
<option value="[%- value -%]">[%- sql_param.input.labels.$value -%]</option> |
675 |
<option value="[%- value -%]">[%- sql_param.input.labels.$value -%]</option> |
| 679 |
[% END %] |
676 |
[% END %] |
|
Lines 690-709
canned reports and writing custom SQL reports.</p>
Link Here
|
| 690 |
|
687 |
|
| 691 |
[% IF ( execute ) %] |
688 |
[% IF ( execute ) %] |
| 692 |
<h1>[% name %]</h1> |
689 |
<h1>[% name %]</h1> |
| 693 |
[% IF ( notes ) %]<p><span class="label">Notes:</span> [% notes %]</p>[% END %] |
690 |
[% IF ( notes ) %]<p><span class="label">[% t('Notes:') %]</span> [% notes %]</p>[% END %] |
| 694 |
[% IF ( unlimited_total ) %]<p><span class="label">Total number of results:</span> [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] shown)[% END %].</p>[% END %] |
691 |
[% IF ( unlimited_total ) %]<p><span class="label">[% t('Total number of results:') %]</span> [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] [% t('shown)') %][% END %].</p>[% END %] |
| 695 |
<div id="sql_output" style="display:none;"><span class="label">Report SQL:</span><pre>[% sql |html %]</pre></div> |
692 |
<div id="sql_output" style="display:none;"><span class="label">[% t('Report SQL:') %]</span><pre>[% sql |html %]</pre></div> |
| 696 |
</br> |
693 |
</br> |
| 697 |
|
694 |
|
| 698 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect"> |
695 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect"> |
| 699 |
<input type="hidden" name="phase" value="Run this report"/> |
696 |
<input type="hidden" name="phase" value="Run this report" /> |
| 700 |
<input type="hidden" name="reports" value="[% report_id %]"/> |
697 |
<input type="hidden" name="reports" value="[% report_id %]" /> |
| 701 |
|
698 |
|
| 702 |
[% FOREACH p IN sql_params %] |
699 |
[% FOREACH p IN sql_params %] |
| 703 |
<input type="hidden" name="sql_params" value="[% p %]"/> |
700 |
<input type="hidden" name="sql_params" value="[% p %]" /> |
| 704 |
[% END %] |
701 |
[% END %] |
| 705 |
|
702 |
|
| 706 |
<label for="limit">Rows per page: </label> |
703 |
<label for="limit">[% t('Rows per page:') %] </label> |
| 707 |
<select name="limit" id="limit"> |
704 |
<select name="limit" id="limit"> |
| 708 |
[% limits = [ 10, 20, 50, 100, 200, 300, 400, 500, 1000 ] %] |
705 |
[% limits = [ 10, 20, 50, 100, 200, 300, 400, 500, 1000 ] %] |
| 709 |
[% FOREACH l IN limits %] |
706 |
[% FOREACH l IN limits %] |
|
Lines 725-731
canned reports and writing custom SQL reports.</p>
Link Here
|
| 725 |
[% FOREACH header_ro IN header_row %] |
722 |
[% FOREACH header_ro IN header_row %] |
| 726 |
[% IF header_ro.cell == 'itemnumber' %] |
723 |
[% IF header_ro.cell == 'itemnumber' %] |
| 727 |
<th> |
724 |
<th> |
| 728 |
[% header_ro.cell %] <button type="submit" data-toggle="tooltip" title="Send visible items to batch modification" class="btn btn-xs btn-default send_to_item_mod"><i class="fa fa-pencil"></i> Batch modify</button> |
725 |
[% header_ro.cell %] <button type="submit" data-toggle="tooltip" title="[% t('Send visible items to batch modification') %]" class="btn btn-xs btn-default send_to_item_mod"><i class="fa fa-pencil"></i> [% t('Batch modify') %]</button> |
| 729 |
</th> |
726 |
</th> |
| 730 |
[% ELSE %] |
727 |
[% ELSE %] |
| 731 |
<th>[% header_ro.cell %]</th> |
728 |
<th>[% header_ro.cell %]</th> |
|
Lines 756-801
$(document).ready(function() {
Link Here
|
| 756 |
</script> |
753 |
</script> |
| 757 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated"> |
754 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated"> |
| 758 |
<fieldset class="rows"> |
755 |
<fieldset class="rows"> |
| 759 |
<legend>Create report from SQL</legend> |
756 |
<legend>[% t('Create report from SQL') %]</legend> |
| 760 |
<ol> |
757 |
<ol> |
| 761 |
<li><label for="reportname" class="required">Report name:</label> |
758 |
<li><label for="reportname" class="required">[% t('Report name:') %]</label> |
| 762 |
[% IF ( reportname ) %]<input type="text" class="required" required="required" id="reportname" name="reportname" value="[% reportname | html %]" size="50"/> |
759 |
[% IF ( reportname ) %]<input type="text" class="required" required="required" id="reportname" name="reportname" value="[% reportname | html %]" size="50" /> |
| 763 |
[% ELSE %]<input type="text" class="required" required="required" id="reportname" name="reportname" size="50" />[% END %] <span class="required">Required</span> |
760 |
[% ELSE %]<input type="text" class="required" required="required" id="reportname" name="reportname" size="50" />[% END %] <span class="required">[% t('Required') %]</span> |
| 764 |
</li> |
761 |
</li> |
| 765 |
[% PROCESS group_and_subgroup_selection %] |
762 |
[% PROCESS group_and_subgroup_selection %] |
| 766 |
|
763 |
|
| 767 |
[% IF (public) %] |
764 |
[% IF (public) %] |
| 768 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">No (default)</option> <option value="1" selected="selected">Yes</option> </select></li> |
765 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li> |
| 769 |
[% ELSE %] |
766 |
[% ELSE %] |
| 770 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selected">No (default)</option> <option value="1">Yes</option> </select></li> |
767 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li> |
| 771 |
[% END %] |
768 |
[% END %] |
| 772 |
[% IF (usecache) %] <li> |
769 |
[% IF (usecache) %] <li> |
| 773 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
770 |
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
| 774 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
771 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
| 775 |
<option value="seconds" selected="selected">Seconds (default)</option> |
772 |
<option value="seconds" selected="selected">[% t('Seconds (default)') %]</option> |
| 776 |
<option value="minutes">Minutes</option> |
773 |
<option value="minutes">[% t('Minutes') %]</option> |
| 777 |
<option value="hours">Hours</option> |
774 |
<option value="hours">[% t('Hours') %]</option> |
| 778 |
<option value="days">Days</option> |
775 |
<option value="days">[% t('Days') %]</option> |
| 779 |
</select> |
776 |
</select> |
| 780 |
</li>[% END %] |
777 |
</li>[% END %] |
| 781 |
<li><label for="notes">Notes:</label> <textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
778 |
<li><label for="notes">[% t('Notes:') %]</label> <textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
| 782 |
</ol> |
779 |
</ol> |
| 783 |
</fieldset> |
780 |
</fieldset> |
| 784 |
<fieldset class="rows"> |
781 |
<fieldset class="rows"> |
| 785 |
<legend>SQL:</legend> |
782 |
<legend>[% t('SQL:') %]</legend> |
| 786 |
<div style="margin:1em;"> |
783 |
<div style="margin:1em;"> |
| 787 |
<textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">Required</span> |
784 |
<textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">[% t('Required') %]</span> |
| 788 |
</div> |
785 |
</div> |
| 789 |
</fieldset> |
786 |
</fieldset> |
| 790 |
|
787 |
|
| 791 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
788 |
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" /> |
| 792 |
<input type="submit" name="submit" value="Save report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> |
789 |
<input type="submit" name="submit" value="Save report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">[% t('Cancel') %]</a> |
| 793 |
</fieldset> |
790 |
</fieldset> |
| 794 |
</form> |
791 |
</form> |
| 795 |
[% END %] |
792 |
[% END %] |
| 796 |
|
793 |
|
| 797 |
[% IF saved_results %] |
794 |
[% IF saved_results %] |
| 798 |
<h1>Saved report results</h1> |
795 |
<h1>[% t('Saved report results') %]</h1> |
| 799 |
<h2>[% name %]</h2> |
796 |
<h2>[% name %]</h2> |
| 800 |
<p>[% notes %]</p> |
797 |
<p>[% notes %]</p> |
| 801 |
<table> |
798 |
<table> |
|
Lines 813-819
$(document).ready(function() {
Link Here
|
| 813 |
<fieldset class="rows"> |
810 |
<fieldset class="rows"> |
| 814 |
<legend>[% reportname %]</legend> |
811 |
<legend>[% reportname %]</legend> |
| 815 |
<ol> |
812 |
<ol> |
| 816 |
[% IF ( notes ) %]<li><span class="label">Notes:</span> [% notes %]</li>[% ELSE %][% END %] |
813 |
[% IF ( notes ) %]<li><span class="label">[% t('Notes:') %]</span> [% notes %]</li>[% ELSE %][% END %] |
| 817 |
<li><textarea id="sql">[% sql %]</textarea></li> |
814 |
<li><textarea id="sql">[% sql %]</textarea></li> |
| 818 |
</ol> |
815 |
</ol> |
| 819 |
</fieldset> |
816 |
</fieldset> |
|
Lines 824-830
$(document).ready(function() {
Link Here
|
| 824 |
</br> |
821 |
</br> |
| 825 |
<div id="report_updated"> |
822 |
<div id="report_updated"> |
| 826 |
<div class="dialog message"> |
823 |
<div class="dialog message"> |
| 827 |
<p>Your report "[% reportname %]" has been saved</p> |
824 |
<p>[% t('Your report "') %][% reportname %][% t('" has been saved') %]</p> |
| 828 |
</div> |
825 |
</div> |
| 829 |
</div> |
826 |
</div> |
| 830 |
[% END %] |
827 |
[% END %] |
|
Lines 833-871
$(document).ready(function() {
Link Here
|
| 833 |
[% IF ( editsql ) %] |
830 |
[% IF ( editsql ) %] |
| 834 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated"> |
831 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated"> |
| 835 |
<input type="hidden" name="phase" value="Update SQL" /> |
832 |
<input type="hidden" name="phase" value="Update SQL" /> |
| 836 |
<input type="hidden" name="id" value="[% id %]"/> |
833 |
<input type="hidden" name="id" value="[% id %]" /> |
| 837 |
<fieldset class="rows"> |
834 |
<fieldset class="rows"> |
| 838 |
<legend>Edit SQL report</legend> |
835 |
<legend>[% t('Edit SQL report') %]</legend> |
| 839 |
<ol> |
836 |
<ol> |
| 840 |
<li><label for="reportname" class="required">Report name: </label><input type="text" id="reportname" name="reportname" value="[% reportname | html %]" size="50" class="required" required="required" /> <span class="required">Required</span></li> |
837 |
<li><label for="reportname" class="required">[% t('Report name:') %] </label><input type="text" id="reportname" name="reportname" value="[% reportname | html %]" size="50" class="required" required="required" /> <span class="required">[% t('Required') %]</span></li> |
| 841 |
[% PROCESS group_and_subgroup_selection %] |
838 |
[% PROCESS group_and_subgroup_selection %] |
| 842 |
[% IF (public) %] |
839 |
[% IF (public) %] |
| 843 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0">No (default)</option> <option value="1" selected="selected">Yes</option> </select></li> |
840 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li> |
| 844 |
[% ELSE %] |
841 |
[% ELSE %] |
| 845 |
<li><label for="public">Report is public:</label><select id="public" name="public"> <option value="0" selected="selected">No (default)</option> <option value="1">Yes</option> </select></li> |
842 |
<li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li> |
| 846 |
[% END %] |
843 |
[% END %] |
| 847 |
[% IF (usecache) %] <li> |
844 |
[% IF (usecache) %] <li> |
| 848 |
<label for="cache_expiry">Cache expiry:</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
845 |
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input> |
| 849 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
846 |
<select id="cache_expiry_units" name="cache_expiry_units"> |
| 850 |
<option value="seconds">Seconds (default)</option> |
847 |
<option value="seconds">[% t('Seconds (default)') %]</option> |
| 851 |
<option value="minutes">Minutes</option> |
848 |
<option value="minutes">[% t('Minutes') %]</option> |
| 852 |
<option value="hours">Hours</option> |
849 |
<option value="hours">[% t('Hours') %]</option> |
| 853 |
<option value="days">Days</option> |
850 |
<option value="days">[% t('Days') %]</option> |
| 854 |
</select> |
851 |
</select> |
| 855 |
</li>[% END %] |
852 |
</li>[% END %] |
| 856 |
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
853 |
<li><label for="notes">[% t('Notes:') %]</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li> |
| 857 |
</ol> |
854 |
</ol> |
| 858 |
</fieldset> |
855 |
</fieldset> |
| 859 |
|
856 |
|
| 860 |
<fieldset class="rows"> |
857 |
<fieldset class="rows"> |
| 861 |
<legend>SQL:</legend> |
858 |
<legend>[% t('SQL:') %]</legend> |
| 862 |
<div style="margin:1em;"> |
859 |
<div style="margin:1em;"> |
| 863 |
<textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">Required</span> |
860 |
<textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">[% t('Required') %]</span> |
| 864 |
</div> |
861 |
</div> |
| 865 |
</fieldset> |
862 |
</fieldset> |
| 866 |
|
863 |
|
| 867 |
<fieldset class="action"> |
864 |
<fieldset class="action"> |
| 868 |
<input type="submit" name="submit" value="Update SQL" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a> |
865 |
<input type="submit" name="submit" value="Update SQL" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">[% t('Cancel') %]</a> |
| 869 |
</fieldset> |
866 |
</fieldset> |
| 870 |
</form> |
867 |
</form> |
| 871 |
|
868 |
|
|
Lines 875-891
$(document).ready(function() {
Link Here
|
| 875 |
[% IF ( errors ) %] |
872 |
[% IF ( errors ) %] |
| 876 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
873 |
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post"> |
| 877 |
<div class="dialog alert"> |
874 |
<div class="dialog alert"> |
| 878 |
<b>The following error was encountered:</b><br /> |
875 |
<b>[% t('The following error was encountered:') %]</b><br /> |
| 879 |
[% FOREACH error IN errors %] |
876 |
[% FOREACH error IN errors %] |
| 880 |
[% IF ( error.sqlerr ) %]This report contains the SQL keyword <b>[% error.sqlerr %]</b>. |
877 |
[% IF ( error.sqlerr ) %][% t('This report contains the SQL keyword') %] <b>[% error.sqlerr %]</b>. |
| 881 |
<br />Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed. |
878 |
<br />[% t('Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed.') %] |
| 882 |
<br />Please return to the "Saved Reports" screen and delete this report or retry creating a new one. |
879 |
<br />[% t('Please return to the "Saved Reports" screen and delete this report or retry creating a new one.') %] |
| 883 |
[% ELSIF ( error.queryerr ) %]The database returned the following error: <br />[% error.queryerr %]<br />Please check the log for further details. |
880 |
[% ELSIF ( error.queryerr ) %][% t('The database returned the following error:') %] <br />[% error.queryerr %]<br />[% t('Please check the log for further details.') %] |
| 884 |
[% ELSIF ( error.cache_expiry ) %]Please select a cache expiry less than 30 days. |
881 |
[% ELSIF ( error.cache_expiry ) %][% t('Please select a cache expiry less than 30 days.') %] |
| 885 |
[% ELSE %] |
882 |
[% ELSE %] |
| 886 |
[% END %] |
883 |
[% END %] |
| 887 |
<div id="onerror_actions"> |
884 |
<div id="onerror_actions"> |
| 888 |
<a href="#" class="button goback">Return to previous page</a> |
885 |
<a href="#" class="button goback">[% t('Return to previous page') %]</a> |
| 889 |
</div> |
886 |
</div> |
| 890 |
[% END %] |
887 |
[% END %] |
| 891 |
</div> |
888 |
</div> |
|
Lines 904-922
$(document).ready(function() {
Link Here
|
| 904 |
<input type="hidden" name="phase" value="Use saved" /> |
901 |
<input type="hidden" name="phase" value="Use saved" /> |
| 905 |
<input type="hidden" name="filter_set" value="1" /> |
902 |
<input type="hidden" name="filter_set" value="1" /> |
| 906 |
<fieldset class="brief"> |
903 |
<fieldset class="brief"> |
| 907 |
<h3>Filter</h3> |
904 |
<h3>[% t('Filter') %]</h3> |
| 908 |
<ol> |
905 |
<ol> |
| 909 |
<li><label for="filter_date">Date:</label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filters.date %]" class="datepicker" /> |
906 |
<li><label for="filter_date">[% t('Date:') %]</label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filters.date %]" class="datepicker" /> |
| 910 |
<div class="hint">[% INCLUDE 'date-format.inc' %]</div> |
907 |
<div class="hint">[% INCLUDE 'date-format.inc' %]</div> |
| 911 |
|
908 |
|
| 912 |
</li> |
909 |
</li> |
| 913 |
<li><label for="filter_author">Author:</label> <input type="text" id="filter_author" name="filter_author" value="[% filters.author %]" size="16" /></li> |
910 |
<li><label for="filter_author">[% t('Author:') %]</label> <input type="text" id="filter_author" name="filter_author" value="[% filters.author %]" size="16" /></li> |
| 914 |
<li><label for="filter_keyword">Keyword:</label> <input type="text" id="filter_keyword" name="filter_keyword" value="[% filters.keyword %]" size="16" /></li> |
911 |
<li><label for="filter_keyword">[% t('Keyword:') %]</label> <input type="text" id="filter_keyword" name="filter_keyword" value="[% filters.keyword %]" size="16" /></li> |
| 915 |
</ol> |
912 |
</ol> |
| 916 |
</fieldset> |
913 |
</fieldset> |
| 917 |
<fieldset class="action"> |
914 |
<fieldset class="action"> |
| 918 |
<input type="submit" value="Apply filter" /> |
915 |
<input type="submit" value="Apply filter" /> |
| 919 |
<a id="resetReportsFilter" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved&clear_filters=1">Clear</a> |
916 |
<a id="resetReportsFilter" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved&clear_filters=1">[% t('Clear') %]</a> |
| 920 |
</fieldset> |
917 |
</fieldset> |
| 921 |
</form> |
918 |
</form> |
| 922 |
</div> |
919 |
</div> |
|
Lines 1185-1196
$(document).ready(function() {
Link Here
|
| 1185 |
|
1182 |
|
| 1186 |
[% BLOCK group_and_subgroup_selection %] |
1183 |
[% BLOCK group_and_subgroup_selection %] |
| 1187 |
<li id="group"> |
1184 |
<li id="group"> |
| 1188 |
<label>Report group:</label> |
1185 |
<label>[% t('Report group:') %]</label> |
| 1189 |
<input type="radio" name="select_or_create_group" |
1186 |
<input type="radio" name="select_or_create_group" id="select_group" checked="checked" /> |
| 1190 |
id="select_group" checked="checked" /> |
1187 |
<label for="select_group" style="float:none">[% t('Select') %]</label> |
| 1191 |
<label for="select_group" style="float:none">Select</label> |
|
|
| 1192 |
<select name="group" id="group_select"> |
1188 |
<select name="group" id="group_select"> |
| 1193 |
<option value="">(None)</option> |
1189 |
<option value="">[% t('(None)') %]</option> |
| 1194 |
[% FOREACH group IN groups_with_subgroups %] |
1190 |
[% FOREACH group IN groups_with_subgroups %] |
| 1195 |
[% IF (group.selected) %] |
1191 |
[% IF (group.selected) %] |
| 1196 |
<option value="[% group.id %]" selected="selected"> |
1192 |
<option value="[% group.id %]" selected="selected"> |
|
Lines 1202-1218
$(document).ready(function() {
Link Here
|
| 1202 |
[% END %] |
1198 |
[% END %] |
| 1203 |
</select> |
1199 |
</select> |
| 1204 |
<input type="radio" name="select_or_create_group" id="create_group" /> |
1200 |
<input type="radio" name="select_or_create_group" id="create_group" /> |
| 1205 |
<label for="create_group" style="float:none">or create:</label> |
1201 |
<label for="create_group" style="float:none">[% t('or create:') %]</label> |
| 1206 |
<input type="text" name="group" id="group_input" title="Group code" placeholder="Code" /> |
1202 |
<input type="text" name="group" id="group_input" title="[% t('Group code') %]" placeholder="[% t('Code') %]" /> |
| 1207 |
<input type="text" name="groupdesc" id="groupdesc_input" title="Group name" placeholder="Name" /> |
1203 |
<input type="text" name="groupdesc" id="groupdesc_input" title="[% t('Group name') %]" placeholder="[% t('Name') %]" /> |
| 1208 |
</li> |
1204 |
</li> |
| 1209 |
<li id="subgroup"> |
1205 |
<li id="subgroup"> |
| 1210 |
<label>Report subgroup:</label> |
1206 |
<label>[% t('Report subgroup:') %]</label> |
| 1211 |
<input type="radio" name="select_or_create_subgroup" |
1207 |
<input type="radio" name="select_or_create_subgroup" id="select_subgroup" checked="checked" /> |
| 1212 |
id="select_subgroup" checked="checked" /> |
1208 |
<label for="select_subgroup" style="float:none">[% t('Select') %]</label> |
| 1213 |
<label for="select_subgroup" style="float:none">Select</label> |
|
|
| 1214 |
<select name="subgroup" id="subgroup_select"> |
1209 |
<select name="subgroup" id="subgroup_select"> |
| 1215 |
<option value="">(None)</option> |
1210 |
<option value="">[% t('(None)') %]</option> |
| 1216 |
[% FOREACH group IN groups_with_subgroups %] |
1211 |
[% FOREACH group IN groups_with_subgroups %] |
| 1217 |
[% IF (group.selected) %] |
1212 |
[% IF (group.selected) %] |
| 1218 |
[% FOREACH subgroup IN group.subgroups %] |
1213 |
[% FOREACH subgroup IN group.subgroups %] |
|
Lines 1227-1236
$(document).ready(function() {
Link Here
|
| 1227 |
[% END %] |
1222 |
[% END %] |
| 1228 |
[% END %] |
1223 |
[% END %] |
| 1229 |
</select> |
1224 |
</select> |
| 1230 |
<input type="radio" name="select_or_create_subgroup" |
1225 |
<input type="radio" name="select_or_create_subgroup" id="create_subgroup" /> |
| 1231 |
id="create_subgroup" /> |
1226 |
<label for="create_subgroup" style="float:none">[% t('or create') %]</label> |
| 1232 |
<label for="create_subgroup" style="float:none">or create</label> |
1227 |
<input type="text" name="subgroup" id="subgroup_input" title="[% t('Subgroup code') %]" placeholder="[% t('Code') %]" /> |
| 1233 |
<input type="text" name="subgroup" id="subgroup_input" title="Subgroup code" placeholder="Code" /> |
1228 |
<input type="text" name="subgroupdesc" id="subgroupdesc_input" title="[% t('Subgroup name') %]" placeholder="[% t('Name') %]" /> |
| 1234 |
<input type="text" name="subgroupdesc" id="subgroupdesc_input" title="Subgroup name" placeholder="Name" /> |
|
|
| 1235 |
</li> |
1229 |
</li> |
| 1236 |
[% END %] |
1230 |
[% END %] |