1 [% INCLUDE 'doc-head-open.inc' %]
2 <title>Koha › Reports › Guided reports › Dictionary</title>
3 [% INCLUDE 'doc-head-close.inc' %]
4 [% INCLUDE 'calendar.inc' %]
5 <style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
7 <body id="rep_dictionary" class="rep">
8 [% INCLUDE 'header.inc' %]
9 [% INCLUDE 'circ-search.inc' %]
11 [%- BLOCK area_name -%]
13 [%- CASE 'CIRC' -%]Circulation
14 [%- CASE 'CAT' -%]Catalog
15 [%- CASE 'PAT' -%]Patrons
16 [%- CASE 'ACQ' -%]Acquisitions
17 [%- CASE 'ACC' -%]Accounts
21 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> › <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a>
22 [% IF ( new_dictionary ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Name the new definition</strong>
23 [% ELSIF ( step_2 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 2: Choose the area </strong>
24 [% ELSIF ( step_3 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 3: Choose a column </strong>
25 [% ELSIF ( step_4 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 4: Specify a value </strong>
26 [% ELSIF ( step_5 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> › <strong>Step 5: Confirm definition</strong>
27 [% ELSE %] › <strong> Dictionary </strong>[% END %]</div>
29 <div id="doc3" class="yui-t2">
34 [% IF ( start_dictionary ) %]
37 <li><a id="newdictionary" class="btn btn-small" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition"><i class="fa fa-plus"></i> New definition</a></li>
42 [% IF ( start_dictionary ) %]
43 <p>Use the dictionary to define custom criteria for reporting.</p>
45 [% IF ( definitions ) %]
46 <h2>Current terms</h2>
47 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
48 <input type="hidden" name="phase" value="View Dictionary" />
52 <option value="">All</option>
53 [% FOREACH area IN areas %]
54 [%- IF ( area.selected ) -%]
55 <option value="[% area.id %]" selected="selected">[%- PROCESS area_name area=area.id -%]</option>
57 <option value="[% area.id %]">[%- PROCESS area_name area=area.id -%]</option>
61 <input name="submit" value="Go" type="submit" />
65 <table border="1" cellspacing="0" cellpadding="5">
73 [% FOREACH definition IN definitions %]
75 <td>[% definition.name %]</td>
76 <td>[% definition.description %]</td>
77 <td>[% definition.areaname %]</td>
78 <td>[% definition.saved_sql %]</td>
79 <td><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
80 <input type="hidden" name="id" value="[% definition.id %]" />
81 <input type="hidden" name="phase" value="Delete Definition" />
82 <input type="submit" name="submit" value="Delete Definition" />
90 [% IF ( new_dictionary ) %]
91 <h3>Add new definition</h3>
92 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
93 <fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>
95 <label for="definition_name">Definition name:</label>
96 <input type="text" id="definition_name" name="definition_name" />
99 <label for="definition_description">Definition description:</label>
100 <textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
104 <fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
105 <input name="submit" value="Next" type="submit" /></fieldset>
109 [%- IF ( step_2 ) -%]
110 <h3>Add new definition</h3>
111 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
112 <fieldset class="rows">
113 <legend>Step 2 of 5: Choose the area</legend>
116 <input type="hidden" name="phase" value="New Term step 3" />
117 <input type="hidden" name="definition_name" value="[% definition_name %]" />
118 <input type="hidden" name="definition_description" value="[% definition_description %]" />
119 <label for="area">Select table:</label><select name="area" id="area">
120 [%- FOREACH area IN areas -%]
121 <option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>
127 <fieldset class="action"><input name="submit" value="Next" type="submit" /></fieldset>
132 <h3>Add new definition</h3>
133 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
134 <fieldset class="rows">
135 <legend>Step 3 of 5: Choose a column</legend>
136 <input type="hidden" name="area" value="[% area %]" />
137 <input type="hidden" name="definition_name" value="[% definition_name %]" />
138 <input type="hidden" name="definition_description" value="[% definition_description %]" />
140 <select id="availableColumns" name="columns" size="25" style="width:200px;height:300px;margin:1em;">
141 [% FOREACH column IN columns %]
142 [% IF ( column.table ) %]
143 [% IF ( loop.first ) %]
148 <optgroup label="[% column.table %]">
150 <option value="[% column.name %]">
151 [% IF ( column.description ) %][% column.description %]
161 <input type="hidden" name="phase" value="New Term step 4" />
163 <fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
168 <h3>Add new definition</h3>
169 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
170 <fieldset class="rows">
171 <legend>Step 4 of 5: Specify a value</legend>
172 <input type="hidden" name="area" value="[% area %]" />
173 <input type="hidden" name="definition_name" value="[% definition_name %]" />
174 <input type="hidden" name="definition_description" value="[% definition_description %]" />
175 <input type="hidden" name="columnstring" value="[% columnstring %]" />
177 [% FOREACH column IN columns %]
178 <input type="hidden" name="criteria_column" value="[% column.name %]" />
179 <ol><li><span class="label">Column: </span> [% column.name %]</li>
180 [% IF ( column.distinct ) %]
181 <li><label for="[% column.name %]_value">Choose: </label> <select id="[% column.name %]_value" name="[% column.name %]_value">
182 [% FOREACH value IN column.values %]
183 <option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
187 [% IF ( column.date ) %]
189 <label for="all_dates">All dates</label>
190 <input type="radio" id="all_dates" name="[% column.name %]_date_type_value" value="all" checked="checked" />
191 <label for="date_range">Date range</label>
192 <input type="radio" id="date_range" name="[% column.name %]_date_type_value" value="range" />
196 <input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />
197 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
199 <input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />
200 <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
203 [% IF ( column.text ) %]
204 <li><label for="[% column.name %]_value">Search string matches: </label> <input type="text" size="13" name="[% column.name %]_value" /></li>
209 <input type="hidden" name="phase" value="New Term step 5" />
211 <fieldset class="action">
212 <input type="submit" name="submit" value="Next" />
218 <form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
219 <input type="hidden" name="area" value="[% area %]" />
220 <input type="hidden" name="definition_name" value="[% definition_name %]" />
221 <input type="hidden" name="definition_description" value="[% definition_description %]" />
222 <input type="hidden" name="columnstring" value="[% columnstring %]" />
224 <h3>Add new definition</h3>
226 <fieldset class="rows">
227 <legend>Step 5 of 5: Confirm details</legend>
230 <span class="label">Name:</span>[%- definition_name -%]
233 <span class="label">Description:</span>[%- definition_description -%]
236 <span class="label">Area:</span>[%- PROCESS area_name area=area -%]
239 <span class="label">Data:</span>
245 [%- FOREACH criteria_loo IN criteria_loop -%]
247 <td>[%- criteria_loo.name -%]</td>
248 <td>[%- criteria_loo.value -%]</td>
256 <fieldset class="action"><input type="hidden" name="sql" value="[% query %]" />
257 <input type="hidden" name="phase" value="New Term step 6" />
258 <input type="submit" name="submit" value="Save" /> </fieldset>
265 [% INCLUDE 'guided-reports-view.inc' %]
268 [% INCLUDE 'intranet-bottom.inc' %]