View | Details | Raw Unified | Return to bug 2780
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/acquisitions_stats.tt (-5 / +5 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Acquisitions Statistics &rsaquo; Results[% ELSE %]&rsaquo; Acquisitions Statistics[% END %]</title>
2
<title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Acquisitions statistics &rsaquo; Results[% ELSE %]&rsaquo; Acquisitions statistics[% END %]</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
</head>
5
</head>
Lines 7-13 Link Here
7
[% INCLUDE 'header.inc' %]
7
[% INCLUDE 'header.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
9
9
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]&rsaquo; <a href="/cgi-bin/koha/reports/acquisitions_stats.pl">Acquisitions Statistics</a> &rsaquo; Results[% ELSE %] &rsaquo; Acquisitions Statistics [% END %]</div>
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]&rsaquo; <a href="/cgi-bin/koha/reports/acquisitions_stats.pl">Acquisitions statistics</a> &rsaquo; Results[% ELSE %] &rsaquo; Acquisitions statistics [% END %]</div>
11
11
12
<div id="doc3" class="yui-t2">
12
<div id="doc3" class="yui-t2">
13
13
Lines 75-85 Link Here
75
		</thead>
75
		</thead>
76
		<tbody>
76
		<tbody>
77
			<tr class="hilighted">
77
			<tr class="hilighted">
78
				<td>Placed On</td>
78
				<td>Placed on</td>
79
				<td><input type="radio" name="Line" value="aqbasket.closedate" /></td>
79
				<td><input type="radio" name="Line" value="aqbasket.closedate" /></td>
80
				<td><input type="radio" checked="checked" name="Column" value="aqbasket.closedate" /> </td>
80
				<td><input type="radio" checked="checked" name="Column" value="aqbasket.closedate" /> </td>
81
				<td> From <input type="text" size="10" id="from" name="Filter" value="" />
81
				<td> From <input type="text" size="10" id="from" name="Filter" value="" />
82
							<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
82
							<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
83
									<script type="text/javascript">
83
									<script type="text/javascript">
84
									//<![CDATA[
84
									//<![CDATA[
85
									function validate1(date) {
85
									function validate1(date) {
Lines 157-163 Link Here
157
				<td>&nbsp;</td>
157
				<td>&nbsp;</td>
158
			</tr>
158
			</tr>
159
			<tr>
159
			<tr>
160
				<td>Received On</td>
160
				<td>Received on</td>
161
				<td><input type="radio" name="Line" value="aqorders.datereceived" /></td>
161
				<td><input type="radio" name="Line" value="aqorders.datereceived" /></td>
162
				<td><input type="radio" name="Column" value="aqorders.datereceived" /></td>
162
				<td><input type="radio" name="Column" value="aqorders.datereceived" /></td>
163
				<td> From <input type="text" size="10" id="fromRO" name="Filter" value="" />
163
				<td> From <input type="text" size="10" id="fromRO" name="Filter" value="" />
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/bor_issues_top.tt (-9 / +9 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Patrons with the most Checkouts</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Patrons with the most checkouts</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
</head>
5
</head>
Lines 24-30 function Dopop(link) { Link Here
24
24
25
25
26
	[% FOREACH mainloo IN mainloop %]
26
	[% FOREACH mainloo IN mainloop %]
27
		<h1>Top [% mainloo.limit %] List patrons for Checkouts</h1>
27
		<h1>Top [% mainloo.limit %] List patrons for checkouts</h1>
28
		[% IF ( mainloo.loopfilter ) %]
28
		[% IF ( mainloo.loopfilter ) %]
29
			<p>Filtered on</p>
29
			<p>Filtered on</p>
30
			[% FOREACH loopfilte IN mainloo.loopfilter %]
30
			[% FOREACH loopfilte IN mainloo.loopfilter %]
Lines 64-70 function Dopop(link) { Link Here
64
		</table>
64
		</table>
65
	[% END %]
65
	[% END %]
66
[% ELSE %]
66
[% ELSE %]
67
	<h1>Patrons with the most Checkouts</h1>
67
	<h1>Patrons with the most checkouts</h1>
68
	<form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">
68
	<form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">
69
	<fieldset class="rows">
69
	<fieldset class="rows">
70
	<ol><li><label for="from">Checkout date from:</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
70
	<ol><li><label for="from">Checkout date from:</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
Lines 185-204 function Dopop(link) { Link Here
185
							</script><span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
185
							</script><span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
186
			<li> 
186
			<li> 
187
				<label for="branch">Library: </label>
187
				<label for="branch">Library: </label>
188
<select name="Filter" id="branch"><option value="" > Any Library</option>
188
<select name="Filter" id="branch"><option value="" > Any library</option>
189
    [% FOREACH branchloo IN branchloop %]
189
    [% FOREACH branchloo IN branchloop %]
190
        <option value="[% branchloo.value %]" >[% branchloo.branchname %] </option>  
190
        <option value="[% branchloo.value %]" >[% branchloo.branchname %] </option>  
191
     [% END %] 
191
     [% END %] 
192
    </select>			</li>
192
    </select>			</li>
193
			<li> 
193
			<li> 
194
				<label for="documenttype">Item Type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>
194
				<label for="documenttype">Item type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>
195
    [% FOREACH itemtypeloo IN itemtypeloop %]
195
    [% FOREACH itemtypeloo IN itemtypeloop %]
196
        <option value="[% itemtypeloo.value %]" >[% itemtypeloo.description %] </option>  
196
        <option value="[% itemtypeloo.value %]" >[% itemtypeloo.description %] </option>  
197
     [% END %] 
197
     [% END %] 
198
    </select>
198
    </select>
199
			</li>
199
			</li>
200
			<li> 
200
			<li> 
201
				<label for="patroncategory">Patron Category: </label><select name="Filter" id="patroncategory"><option value="" > Any Category code</option>
201
				<label for="patroncategory">Patron category: </label><select name="Filter" id="patroncategory"><option value="" > Any category code</option>
202
    [% FOREACH borcatloo IN borcatloop %]
202
    [% FOREACH borcatloo IN borcatloop %]
203
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
203
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
204
     [% END %] 
204
     [% END %] 
Lines 214-220 function Dopop(link) { Link Here
214
						<option value ="10">10</option>
214
						<option value ="10">10</option>
215
						<option value ="15">15</option>
215
						<option value ="15">15</option>
216
						<option value ="20">20</option>
216
						<option value ="20">20</option>
217
                        <option value ="">No Limit</option>
217
                        <option value ="">No limit</option>
218
	<!--					<option value ="25">25</option>
218
	<!--					<option value ="25">25</option>
219
						<option value ="40">40</option>
219
						<option value ="40">40</option>
220
						<option value ="50">50</option>
220
						<option value ="50">50</option>
Lines 223-230 function Dopop(link) { Link Here
223
		<li><label for="criteria">By: </label> <select name="Criteria" id="criteria">
223
		<li><label for="criteria">By: </label> <select name="Criteria" id="criteria">
224
						<option value ="" selected="selected">None</option>
224
						<option value ="" selected="selected">None</option>
225
						<option value ="branchcode">Library</option>
225
						<option value ="branchcode">Library</option>
226
						<option value ="categorycode">Categorycode</option>
226
						<option value ="categorycode">Category code</option>
227
						<option value ="itemtype">Itemtype</option>
227
						<option value ="itemtype">Item type</option>
228
						<option value ="Day">Day</option>
228
						<option value ="Day">Day</option>
229
						<option value ="Week">Week</option>
229
						<option value ="Week">Week</option>
230
						<option value ="Month">Month</option>
230
						<option value ="Month">Month</option>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_out.tt (-6 / +6 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Patrons with No Checkouts</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Patrons with no checkouts</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
</head>
5
</head>
Lines 7-13 Link Here
7
[% INCLUDE 'header.inc' %]
7
[% INCLUDE 'header.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
9
9
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Patrons with No Checkouts</div>
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Patrons with no checkouts</div>
11
11
12
<div id="doc3" class="yui-t2">
12
<div id="doc3" class="yui-t2">
13
   
13
   
Lines 17-23 Link Here
17
17
18
[% IF ( do_it ) %]
18
[% IF ( do_it ) %]
19
    [% FOREACH mainloo IN mainloop %]
19
    [% FOREACH mainloo IN mainloop %]
20
        <h1>Patrons with no Checkouts</h1>
20
        <h1>Patrons with no checkouts</h1>
21
        [% IF ( mainloo.loopfilter ) %]
21
        [% IF ( mainloo.loopfilter ) %]
22
            <p>Filtered on</p>
22
            <p>Filtered on</p>
23
            [% FOREACH loopfilte IN mainloo.loopfilter %]
23
            [% FOREACH loopfilte IN mainloo.loopfilter %]
Lines 48-58 Link Here
48
        </table>
48
        </table>
49
    [% END %]
49
    [% END %]
50
[% ELSE %]
50
[% ELSE %]
51
    <h1>Patrons with no Checkouts</h1>
51
    <h1>Patrons with no checkouts</h1>
52
    <form method="post" action="/cgi-bin/koha/reports/borrowers_out.pl">
52
    <form method="post" action="/cgi-bin/koha/reports/borrowers_out.pl">
53
    <fieldset class="rows">
53
    <fieldset class="rows">
54
		<ol>
54
		<ol>
55
			<li><label for="patroncategory">Patron category: </label> <select name="Filter" id="patroncategory"><option value="" > Any Category code</option>
55
			<li><label for="patroncategory">Patron category: </label> <select name="Filter" id="patroncategory"><option value="" > Any category code</option>
56
    [% FOREACH borcatloo IN borcatloop %]
56
    [% FOREACH borcatloo IN borcatloop %]
57
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
57
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
58
     [% END %] 
58
     [% END %] 
Lines 88-94 Link Here
88
                    </select></li>
88
                    </select></li>
89
			<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
89
			<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
90
                        <option value ="" selected="selected">None</option>
90
                        <option value ="" selected="selected">None</option>
91
                        <option value ="categorycode">Patron Category</option>
91
                        <option value ="categorycode">Patron category</option>
92
                        <option value ="branchcode">Library</option>
92
                        <option value ="branchcode">Library</option>
93
                    </select></li>
93
                    </select></li>
94
		</ol>
94
		</ol>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_stats.tt (-3 / +3 lines)
Lines 104-110 Link Here
104
			</tr>
104
			</tr>
105
105
106
			<tr>
106
			<tr>
107
			<td rowspan="2">Zip Code</td>
107
			<td rowspan="2">Zip code</td>
108
			<td><input type="radio" name="Line" value="zipcode" /></td>
108
			<td><input type="radio" name="Line" value="zipcode" /></td>
109
			<td><input type="radio" name="Column" value="zipcode" /></td>
109
			<td><input type="radio" name="Column" value="zipcode" /></td>
110
			<td><select name="Filter"  size="1" id="zipcode">
110
			<td><select name="Filter"  size="1" id="zipcode">
Lines 148-154 Link Here
148
			</td>
148
			</td>
149
			</tr>
149
			</tr>
150
		    <tr>
150
		    <tr>
151
            <td>Date of Birth</td>
151
            <td>Date of birth</td>
152
            <td colspan="2"></td>
152
            <td colspan="2"></td>
153
                <td><label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />
153
                <td><label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />
154
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
154
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
Lines 179-185 Link Here
179
					//]]>
179
					//]]>
180
                    </script>
180
                    </script>
181
                    <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
181
                    <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
182
                        <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
182
                        <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
183
                          <script type="text/javascript">
183
                          <script type="text/javascript">
184
						  //<![CDATA[ 
184
						  //<![CDATA[ 
185
						   function validate2(date) {
185
						   function validate2(date) {
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt (-8 / +8 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Most-Circulated Items[% IF ( do_it ) %] &rsaquo; Results[% END %]</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Most-circulated items[% IF ( do_it ) %] &rsaquo; Results[% END %]</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
[% IF ( do_it ) %]
5
[% IF ( do_it ) %]
Lines 14-20 function Dopop(link) { Link Here
14
[% INCLUDE 'header.inc' %]
14
[% INCLUDE 'header.inc' %]
15
[% INCLUDE 'cat-search.inc' %]
15
[% INCLUDE 'cat-search.inc' %]
16
16
17
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; [% IF ( do_it ) %]<a href="/cgi-bin/koha/reports/cat_issues_top.pl">Most-Circulated Items</a> &rsaquo; Results[% ELSE %]Most-Circulated Items[% END %]</div>
17
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; [% IF ( do_it ) %]<a href="/cgi-bin/koha/reports/cat_issues_top.pl">Most-circulated items</a> &rsaquo; Results[% ELSE %]Most-Circulated Items[% END %]</div>
18
18
19
<div id="doc3" class="yui-t2">
19
<div id="doc3" class="yui-t2">
20
   
20
   
Lines 25-31 function Dopop(link) { Link Here
25
[% IF ( do_it ) %]
25
[% IF ( do_it ) %]
26
26
27
	[% FOREACH mainloo IN mainloop %]
27
	[% FOREACH mainloo IN mainloop %]
28
		<h1>Top [% mainloo.limit %] Most-Circulated Items</h1>
28
		<h1>Top [% mainloo.limit %] Most-circulated items</h1>
29
		[% IF ( mainloo.loopfilter ) %]
29
		[% IF ( mainloo.loopfilter ) %]
30
			<p>Filtered on</p>
30
			<p>Filtered on</p>
31
			[% FOREACH loopfilte IN mainloo.loopfilter %]
31
			[% FOREACH loopfilte IN mainloo.loopfilter %]
Lines 42-48 function Dopop(link) { Link Here
42
				<th>&nbsp;</th>
42
				<th>&nbsp;</th>
43
				[% FOREACH loopco IN mainloo.loopcol %]
43
				[% FOREACH loopco IN mainloo.loopcol %]
44
					<th>Item</th>
44
					<th>Item</th>
45
					<th>Count of Checkouts</th>
45
                    <th>Count of checkouts</th>
46
				[% END %]
46
				[% END %]
47
			  </tr>
47
			  </tr>
48
				[% FOREACH loopro IN mainloo.looprow %]
48
				[% FOREACH loopro IN mainloo.looprow %]
Lines 72-78 function Dopop(link) { Link Here
72
		</table>
72
		</table>
73
	[% END %]
73
	[% END %]
74
[% ELSE %]
74
[% ELSE %]
75
	<h1>Most-Circulated Items</h1>
75
    <h1>Most-circulated items</h1>
76
	<form method="post" action="/cgi-bin/koha/reports/cat_issues_top.pl">
76
	<form method="post" action="/cgi-bin/koha/reports/cat_issues_top.pl">
77
	<fieldset class="rows">
77
	<fieldset class="rows">
78
	<ol>
78
	<ol>
Lines 193-212 function Dopop(link) { Link Here
193
								);
193
								);
194
							</script> <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
194
							</script> <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
195
				<li><label for="branch">Library: </label>
195
				<li><label for="branch">Library: </label>
196
<select name="Filter" id="branch"><option value="" > Any Library</option>
196
<select name="Filter" id="branch"><option value="" > Any library</option>
197
    [% FOREACH branchloo IN branchloop %]
197
    [% FOREACH branchloo IN branchloop %]
198
        <option value="[% branchloo.value %]" >[% branchloo.branchname %] </option>  
198
        <option value="[% branchloo.value %]" >[% branchloo.branchname %] </option>  
199
     [% END %] 
199
     [% END %] 
200
    </select>     </li>
200
    </select>     </li>
201
      <li> 
201
      <li> 
202
        <label for="documenttype">Item Type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>
202
        <label for="documenttype">Item type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>
203
    [% FOREACH itemtypeloo IN itemtypeloop %]
203
    [% FOREACH itemtypeloo IN itemtypeloop %]
204
        <option value="[% itemtypeloo.value %]" >[% itemtypeloo.description %] </option>  
204
        <option value="[% itemtypeloo.value %]" >[% itemtypeloo.description %] </option>  
205
     [% END %] 
205
     [% END %] 
206
    </select>
206
    </select>
207
      </li>
207
      </li>
208
      <li> 
208
      <li> 
209
        <label for="patroncategory">Patron Category: </label><select name="Filter" id="patroncategory"><option value="" > Any Category code</option>
209
        <label for="patroncategory">Patron category: </label><select name="Filter" id="patroncategory"><option value="" > Any Category code</option>
210
    [% FOREACH borcatloo IN borcatloop %]
210
    [% FOREACH borcatloo IN borcatloop %]
211
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
211
        <option value="[% borcatloo.value %]" >[% borcatloo.description %] </option>  
212
     [% END %] 
212
     [% END %] 
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_out.tt (-10 / +10 lines)
Lines 35-41 Link Here
35
		[% IF ( mainloo.looptables ) %]
35
		[% IF ( mainloo.looptables ) %]
36
			<h3><a name="summary" id="summary"></a>Summary</h3>
36
			<h3><a name="summary" id="summary"></a>Summary</h3>
37
			<table id="summary_table">
37
			<table id="summary_table">
38
				<tr><th>Group</th><th>Call Number Range</th><th>Number of Items Displayed</th><th>Total Items in Group</th>
38
                <tr><th>Group</th><th>Call number range</th><th>Number of items displayed</th><th>Total items in group</th>
39
				</tr>
39
				</tr>
40
			[% FOREACH looptable IN mainloo.looptables %]
40
			[% FOREACH looptable IN mainloo.looptables %]
41
				<tr><td><a href="#table[% looptable.coltitle %]">[% looptable.coltitle %]</a></td>
41
				<tr><td><a href="#table[% looptable.coltitle %]">[% looptable.coltitle %]</a></td>
Lines 59-73 Link Here
59
		<table>
59
		<table>
60
			<tr>
60
			<tr>
61
				<th>#</th>
61
				<th>#</th>
62
				<th>Call Number</th>
62
				<th>Call number</th>
63
				<th>Barcode</th>
63
				<th>Barcode</th>
64
				<th>Item Details</th>
64
				<th>Item details</th>
65
			</tr>
65
			</tr>
66
				[% IF ( looptable.looprow ) %]
66
				[% IF ( looptable.looprow ) %]
67
				[% FOREACH loopro IN looptable.looprow %]
67
				[% FOREACH loopro IN looptable.looprow %]
68
				[% DEFAULT
68
				[% DEFAULT
69
				    loopro.itemcallnumber="No Call Number"
69
				    loopro.itemcallnumber="No call number"
70
				    loopro.barcode="No Barcode"
70
				    loopro.barcode="No barcode"
71
				    loopro.title="NO TITLE"
71
				    loopro.title="NO TITLE"
72
				    loopro.author=""
72
				    loopro.author=""
73
				%]
73
				%]
Lines 91-111 Link Here
91
		[% END %]
91
		[% END %]
92
	[% END %]
92
	[% END %]
93
[% ELSE %]
93
[% ELSE %]
94
	<h1>Items with no checkouts</h1>
94
    <h1>Items with no checkouts</h1>
95
	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
95
	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
96
	
96
	
97
	<fieldset class="rows">
97
	<fieldset class="rows">
98
		<ol>
98
		<ol>
99
			<li><label for="branch">Library: </label>
99
			<li><label for="branch">Library: </label>
100
	<select name="Filter" id="branch">
100
	<select name="Filter" id="branch">
101
		<option value="">Any Library</option>
101
        <option value="">Any library</option>
102
    [% FOREACH branchloo IN branchloop %]
102
    [% FOREACH branchloo IN branchloop %]
103
        <option value="[% branchloo.value %]">[% branchloo.branchname %]</option>  
103
        <option value="[% branchloo.value %]">[% branchloo.branchname %]</option>  
104
     [% END %] 
104
     [% END %] 
105
    </select></li>
105
    </select></li>
106
      <li> 
106
      <li> 
107
        <label for="documenttype">Item Type: </label><select name="Filter" id="documenttype">
107
        <label for="documenttype">Item type: </label><select name="Filter" id="documenttype">
108
		<option value="">Any Item Type</option>
108
        <option value="">Any item type</option>
109
    [% FOREACH itemtypeloo IN itemtypeloop %]
109
    [% FOREACH itemtypeloo IN itemtypeloop %]
110
        <option value="[% itemtypeloo.value %]">[% itemtypeloo.description %]</option>  
110
        <option value="[% itemtypeloo.value %]">[% itemtypeloo.description %]</option>  
111
     [% END %] 
111
     [% END %] 
Lines 135-141 Link Here
135
		<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
135
		<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
136
						<option value ="" selected="selected">None</option>
136
						<option value ="" selected="selected">None</option>
137
						<option value ="homebranch">Library</option>
137
						<option value ="homebranch">Library</option>
138
						<option value ="itype">Itemtype</option>
138
						<option value ="itype">Item type</option>
139
					</select></li>
139
					</select></li>
140
		</ol>
140
		</ol>
141
	</fieldset>
141
	</fieldset>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_stats.tt (-6 / +6 lines)
Lines 80-86 Link Here
80
		<tbody>
80
		<tbody>
81
			[% IF ( haslccn ) %]
81
			[% IF ( haslccn ) %]
82
					<tr>
82
					<tr>
83
					<td>LoC Classification</td>
83
                    <td>LoC classification</td>
84
					<td><input type="radio" name="Line" value="lccn" /></td>
84
					<td><input type="radio" name="Line" value="lccn" /></td>
85
					<td><input type="radio" name="Column" value="lccn" /></td>
85
					<td><input type="radio" name="Column" value="lccn" /></td>
86
					<td> <label for="locFrom">From</label> <input type="text" name="Filter" id="locFrom" /> <label for="locTo">To</label> <input type="text" name="Filter" id="locTo" /></td>
86
					<td> <label for="locFrom">From</label> <input type="text" name="Filter" id="locFrom" /> <label for="locTo">To</label> <input type="text" name="Filter" id="locTo" /></td>
Lines 102-108 Link Here
102
			[% END %]
102
			[% END %]
103
			[% IF ( hascote ) %]
103
			[% IF ( hascote ) %]
104
			  <tr>
104
			  <tr>
105
					<td>Koha Full Call Number</td>
105
					<td>Koha full call number</td>
106
					<td><input type="radio" name="Line" value="items.itemcallnumber" /></td>
106
					<td><input type="radio" name="Line" value="items.itemcallnumber" /></td>
107
					<td><input type="radio" name="Column" value="items.itemcallnumber" /></td>
107
					<td><input type="radio" name="Column" value="items.itemcallnumber" /></td>
108
					<td><label for="callnoFrom">From</label> <input type="text" name="Filter" id="callnoFrom" /> <label for="callnoTo">To</label> <input type="text" name="Filter" id="callnoTo" /></td>
108
					<td><label for="callnoFrom">From</label> <input type="text" name="Filter" id="callnoFrom" /> <label for="callnoTo">To</label> <input type="text" name="Filter" id="callnoTo" /></td>
Lines 125-131 Link Here
125
				<tr><td colspan="4"><input type="hidden" name="Filter" /> <input type="hidden" name="Filter" /></td></tr>
125
				<tr><td colspan="4"><input type="hidden" name="Filter" /> <input type="hidden" name="Filter" /></td></tr>
126
			[% END %]
126
			[% END %]
127
			 <tr>
127
			 <tr>
128
				<td>Item Type</td>
128
                <td>Item type</td>
129
				<td><input type="radio" name="Line" value="[% item_itype %]" /></td>
129
				<td><input type="radio" name="Line" value="[% item_itype %]" /></td>
130
				<td><input type="radio" name="Column" value="[% item_itype %]" /></td>
130
				<td><input type="radio" name="Column" value="[% item_itype %]" /></td>
131
				<td><select name="Filter" id="[% item_itype %]">
131
				<td><select name="Filter" id="[% item_itype %]">
Lines 145-157 Link Here
145
				<td><input type="text" name="Filter" /></td>
145
				<td><input type="text" name="Filter" /></td>
146
			</tr>
146
			</tr>
147
			<tr>
147
			<tr>
148
				<td>Publication Year</td>
148
				<td>Publication year</td>
149
				<td><input type="radio" name="Line" value="publicationyear" /></td>
149
				<td><input type="radio" name="Line" value="publicationyear" /></td>
150
				<td><input type="radio" name="Column" value="publicationyear" /></td>
150
				<td><input type="radio" name="Column" value="publicationyear" /></td>
151
				<td><label for="pubyearFrom">From</label> <input type="text" name="Filter" id="pubyearFrom" /> <label for="pubyearTo">To</label> <input type="text" name="Filter" id="pubyearTo" /></td>
151
				<td><label for="pubyearFrom">From</label> <input type="text" name="Filter" id="pubyearFrom" /> <label for="pubyearTo">To</label> <input type="text" name="Filter" id="pubyearTo" /></td>
152
			</tr>
152
			</tr>
153
			<tr>
153
			<tr>
154
				<td>Home Library</td>
154
                <td>Home library</td>
155
				<td><input type="radio" name="Line" value="items.homebranch" /></td>
155
				<td><input type="radio" name="Line" value="items.homebranch" /></td>
156
				<td><input type="radio" name="Column" value="items.homebranch" /></td>
156
				<td><input type="radio" name="Column" value="items.homebranch" /></td>
157
				<td><select name="Filter" id="branch">
157
				<td><select name="Filter" id="branch">
Lines 163-169 Link Here
163
				</td>
163
				</td>
164
			</tr>
164
			</tr>
165
			<tr>
165
			<tr>
166
				<td>Shelving Location</td>
166
                <td>Shelving location</td>
167
				<td><input type="radio" name="Line" value="items.location" /></td>
167
				<td><input type="radio" name="Line" value="items.location" /></td>
168
				<td><input type="radio" name="Column" value="items.location" /></td>
168
				<td><input type="radio" name="Column" value="items.location" /></td>
169
				<td><select name="Filter" id="location">
169
				<td><select name="Filter" id="location">
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/dictionary.tt (-15 / +15 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Guided Reports &rsaquo; Dictionary</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Guided reports &rsaquo; Dictionary</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %]
4
[% INCLUDE 'calendar.inc' %]
5
<style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
5
<style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
Lines 8-14 Link Here
8
[% INCLUDE 'header.inc' %]
8
[% INCLUDE 'header.inc' %]
9
[% INCLUDE 'circ-search.inc' %]
9
[% INCLUDE 'circ-search.inc' %]
10
10
11
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided Reports Wizard</a> 
11
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a> 
12
[% IF ( new_dictionary ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Name the new definition</strong>
12
[% IF ( new_dictionary ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Name the new definition</strong>
13
[% ELSIF ( step_2 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 2: Choose the area </strong> 
13
[% ELSIF ( step_2 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 2: Choose the area </strong> 
14
[% ELSIF ( step_3 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 3: Choose columns </strong> 
14
[% ELSIF ( step_3 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 3: Choose columns </strong> 
Lines 29-37 Link Here
29
	<p>Use the dictionary to define custom criteria for reporting.</p>
29
	<p>Use the dictionary to define custom criteria for reporting.</p>
30
30
31
		[% IF ( definitions ) %]
31
		[% IF ( definitions ) %]
32
		<h2>Current Terms</h2>
32
		<h2>Current terms</h2>
33
		<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
33
		<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
34
		<input type="hidden" name="phase" value="View Dictionary" />
34
		<input type="hidden" name="phase" value="View dictionary" />
35
		[% IF ( areas ) %]
35
		[% IF ( areas ) %]
36
			Filter by area <select name="areas">
36
			Filter by area <select name="areas">
37
			<option value="">All</option>
37
			<option value="">All</option>
Lines 77-106 Link Here
77
[% END %]
77
[% END %]
78
78
79
[% IF ( new_dictionary ) %]
79
[% IF ( new_dictionary ) %]
80
<h3>Add New Definition</h3>
80
<h3>Add new definition</h3>
81
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
81
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
82
<fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>
82
<fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>
83
<li>
83
<li>
84
<label for="definition_name">Definition Name:</label>
84
<label for="definition_name">Definition name:</label>
85
<input type="text" id="definition_name" name="definition_name" />
85
<input type="text" id="definition_name" name="definition_name" />
86
</li>
86
</li>
87
<li>
87
<li>
88
<label for="definition_description">Definition Description:</label>
88
<label for="definition_description">Definition description:</label>
89
<textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
89
<textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
90
</li>
90
</li>
91
</ol></fieldset>
91
</ol></fieldset>
92
																													  
92
93
<fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
93
<fieldset class="action"><input type="hidden" name="phase" value="New Term step 2" />
94
<input name="submit" value="Next" type="submit" /></fieldset>
94
<input name="submit" value="Next" type="submit" /></fieldset>
95
</form>
95
</form>
96
[% END %]
96
[% END %]
97
97
98
[% IF ( step_2 ) %]
98
[% IF ( step_2 ) %]
99
<h3>Add New Definition</h3>
99
<h3>Add new definition</h3>
100
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
100
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
101
<fieldset class="rows">
101
<fieldset class="rows">
102
<legend>Step 2 of 5: Choose the area</legend>
102
<legend>Step 2 of 5: Choose the area</legend>
103
<ol><li><input type="hidden" name="phase" value="New Term step 3" />
103
<ol><li><input type="hidden" name="phase" value="New term step 3" />
104
<input type="hidden" name="definition_name" value="[% definition_name %]" />
104
<input type="hidden" name="definition_name" value="[% definition_name %]" />
105
<input type="hidden" name="definition_description" value="[% definition_description %]" />
105
<input type="hidden" name="definition_description" value="[% definition_description %]" />
106
<label for="areas">Select table </label><select name="areas" id="areas">
106
<label for="areas">Select table </label><select name="areas" id="areas">
Lines 115-121 Link Here
115
[% END %]
115
[% END %]
116
116
117
[% IF ( step_3 ) %]
117
[% IF ( step_3 ) %]
118
<h3>Add New Definition</h3>
118
<h3>Add new definition</h3>
119
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">      
119
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">      
120
<fieldset class="rows">
120
<fieldset class="rows">
121
<legend>Step 3 of 5: Choose columns</legend>
121
<legend>Step 3 of 5: Choose columns</legend>
Lines 149-162 Link Here
149
149
150
<td style="border: 0;"><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select>     </td>   </tr></table>     
150
<td style="border: 0;"><select id="selectedColumns" name="columns" size="25" style="width:200px;height:300px;"></select>     </td>   </tr></table>     
151
151
152
<input type="hidden" name="phase" value="New Term step 4" />
152
<input type="hidden" name="phase" value="New term step 4" />
153
</fieldset>
153
</fieldset>
154
<fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
154
<fieldset class="action"><input type="submit" name="submit" value="Next" /></fieldset>
155
</form>
155
</form>
156
[% END %]
156
[% END %]
157
157
158
[% IF ( step_4 ) %]
158
[% IF ( step_4 ) %]
159
<h3>Add New Definition</h3>
159
<h3>Add new definition</h3>
160
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
160
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
161
<fieldset class="rows">
161
<fieldset class="rows">
162
<legend>Step 4 of 5: Specify a value</legend>
162
<legend>Step 4 of 5: Specify a value</legend>
Lines 223-229 Link Here
223
223
224
[% END %]
224
[% END %]
225
</ol>
225
</ol>
226
<input type="hidden" name="phase" value="New Term step 5" />
226
<input type="hidden" name="phase" value="New term step 5" />
227
</fieldset>
227
</fieldset>
228
<fieldset class="action">
228
<fieldset class="action">
229
<input type="submit" name="submit" value="Next" />
229
<input type="submit" name="submit" value="Next" />
Lines 238-244 Link Here
238
<input type="hidden" name="definition_description" value="[% definition_description %]" />
238
<input type="hidden" name="definition_description" value="[% definition_description %]" />
239
<input type="hidden" name="columnstring" value="[% columnstring %]" />
239
<input type="hidden" name="columnstring" value="[% columnstring %]" />
240
240
241
<h3>Add New Definition</h3>
241
<h3>Add new definition</h3>
242
242
243
<fieldset class="rows">
243
<fieldset class="rows">
244
<legend>Step 5 of 5: Confirm details</legend>
244
<legend>Step 5 of 5: Confirm details</legend>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt (-56 / +56 lines)
Lines 1-14 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Guided Reports Wizard 
2
<title>Koha &rsaquo; Reports &rsaquo; Guided reports wizard 
3
[% IF ( saved1 ) %]&rsaquo; Saved Reports
3
[% IF ( saved1 ) %]&rsaquo; Saved Reports
4
[% ELSIF ( create ) %]&rsaquo; Create from SQL
4
[% ELSIF ( create ) %]&rsaquo; Create from SQL
5
[% ELSIF ( showsql ) %]&rsaquo; Saved Reports &rsaquo; SQL View
5
[% ELSIF ( showsql ) %]&rsaquo; Saved reports &rsaquo; SQL view
6
[% ELSIF ( execute ) %]&rsaquo; Saved Reports &rsaquo; [% name %] Report
6
[% ELSIF ( execute ) %]&rsaquo; Saved reports &rsaquo; [% name %] Report
7
[% ELSIF ( buildx ) %]&rsaquo; Build A Report, Step [% buildx %] of 6:
7
[% ELSIF ( buildx ) %]&rsaquo; Build a report, step [% buildx %] of 6:
8
[% IF ( build1 ) %]Choose a Module
8
[% IF ( build1 ) %]Choose a module
9
[% ELSIF ( build2 ) %]Pick a Report Type
9
[% ELSIF ( build2 ) %]Pick a report type
10
[% ELSIF ( build3 ) %]Select Columns for Display
10
[% ELSIF ( build3 ) %]Select columns for display
11
[% ELSIF ( build4 ) %]Select Criteria to Limit on
11
[% ELSIF ( build4 ) %]Select criteria to limit on
12
[% ELSIF ( build5 ) %]Pick which columns to total
12
[% ELSIF ( build5 ) %]Pick which columns to total
13
[% ELSIF ( build6 ) %]Select how you want the report ordered
13
[% ELSIF ( build6 ) %]Select how you want the report ordered
14
[% END %]
14
[% END %]
Lines 66-82 $(document).ready(function(){ Link Here
66
66
67
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a>
67
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a>
68
&rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>
68
&rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>
69
&rsaquo; <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided Reports Wizard</a>
69
&rsaquo; <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a>
70
&rsaquo; 
70
&rsaquo; 
71
[% IF ( saved1 ) %]Saved Reports
71
[% IF ( saved1 ) %]Saved reports
72
[% ELSIF ( create ) %]Create from SQL
72
[% ELSIF ( create ) %]Create from SQL
73
[% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> &rsaquo; SQL View
73
[% ELSIF ( showsql ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> &rsaquo; SQL view
74
[% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports</a> &rsaquo; <em>[% name %]</em> Report
74
[% ELSIF ( execute ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports</a> &rsaquo; <em>[% name %]</em> Report
75
[% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build A Report</a> &rsaquo; Step [% buildx %] of 6:
75
[% ELSIF ( buildx ) %]<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build a report</a> &rsaquo; Step [% buildx %] of 6:
76
    [% IF ( build1 ) %]Choose a Module
76
    [% IF ( build1 ) %]Choose a module
77
    [% ELSIF ( build2 ) %]Pick a Report Type
77
    [% ELSIF ( build2 ) %]Pick a report type
78
    [% ELSIF ( build3 ) %]Select Columns for Display
78
    [% ELSIF ( build3 ) %]Select columns for display
79
    [% ELSIF ( build4 ) %]Select Criteria to Limit on
79
    [% ELSIF ( build4 ) %]Select criteria to limit on
80
    [% ELSIF ( build5 ) %]Pick which columns to total
80
    [% ELSIF ( build5 ) %]Pick which columns to total
81
    [% ELSIF ( build6 ) %]Select how you want the report ordered
81
    [% ELSIF ( build6 ) %]Select how you want the report ordered
82
    [% END %]
82
    [% END %]
Lines 90-101 $(document).ready(function(){ Link Here
90
    [% INCLUDE "reports-toolbar.inc" %]
90
    [% INCLUDE "reports-toolbar.inc" %]
91
91
92
[% IF ( start ) %]
92
[% IF ( start ) %]
93
    <h2>Guided Reports</h2>
93
    <h2>Guided reports</h2>
94
    <p>Use the guided reports engine to create non standard reports.
94
    <p>Use the guided reports engine to create non standard reports.
95
This feature aims to provide some middle ground between the built in
95
This feature aims to provide some middle ground between the built in
96
canned reports and writing custom SQL reports.</p>
96
canned reports and writing custom SQL reports.</p>
97
97
98
    <h3>Build And Run Reports</h3>
98
    <h3>Build and run reports</h3>
99
        [% IF ( CAN_user_reports_create_reports ) %]
99
        [% IF ( CAN_user_reports_create_reports ) %]
100
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
100
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
101
            <input type="hidden" name="phase" value="Build new" />
101
            <input type="hidden" name="phase" value="Build new" />
Lines 117-129 canned reports and writing custom SQL reports.</p> Link Here
117
<h3>Reports Dictionary</h3>
117
<h3>Reports Dictionary</h3>
118
<p>Use the reports dictionary to define custom criteria to use in your reports</p>
118
<p>Use the reports dictionary to define custom criteria to use in your reports</p>
119
<form action="/cgi-bin/koha/reports/dictionary.pl">
119
<form action="/cgi-bin/koha/reports/dictionary.pl">
120
<input type="hidden" name="phase" value="View Dictionary"/>
120
<input type="hidden" name="phase" value="View dictionary"/>
121
<input type="submit" name="submit" value="View Dictionary"/>
121
<input type="submit" name="submit" value="View dictionary"/>
122
</form>
122
</form>
123
[% END %]
123
[% END %]
124
124
125
[% IF ( saved1 ) %]
125
[% IF ( saved1 ) %]
126
[% IF ( savedreports ) %]<h1>Saved Reports</h1>
126
[% IF ( savedreports ) %]<h1>Saved reports</h1>
127
127
128
<div id="pagertable_reports">
128
<div id="pagertable_reports">
129
[% INCLUDE 'table-pager.inc' perpage='20' %]
129
[% INCLUDE 'table-pager.inc' perpage='20' %]
Lines 133-144 canned reports and writing custom SQL reports.</p> Link Here
133
<thead>
133
<thead>
134
 <tr>
134
 <tr>
135
  <th>ID</th>
135
  <th>ID</th>
136
  <th>Report Name</th>
136
  <th>Report name</th>
137
  <th>Type</th>
137
  <th>Type</th>
138
  <th>Notes</th>
138
  <th>Notes</th>
139
  <th>Author</th>
139
  <th>Author</th>
140
  <th>Creation Date</th>
140
  <th>Creation date</th>
141
  <th>Saved Results</th>
141
  <th>Saved results</th>
142
  <th>Saved SQL</th>
142
  <th>Saved SQL</th>
143
  <th>&nbsp;</th>
143
  <th>&nbsp;</th>
144
  <th>&nbsp;</th>
144
  <th>&nbsp;</th>
Lines 199-208 canned reports and writing custom SQL reports.</p> Link Here
199
199
200
200
201
[% IF ( build1 ) %]
201
[% IF ( build1 ) %]
202
<h1>Build A Report</h1>
202
<h1>Build a report</h1>
203
<form action="/cgi-bin/koha/reports/guided_reports.pl">
203
<form action="/cgi-bin/koha/reports/guided_reports.pl">
204
<fieldset class="rows">
204
<fieldset class="rows">
205
<legend>Step 1 of 6: Choose a Module to Report on</legend>
205
<legend>Step 1 of 6: Choose a module to report on</legend>
206
<ol><li><label for="areas">Choose: </label><select name="areas" id="areas">
206
<ol><li><label for="areas">Choose: </label><select name="areas" id="areas">
207
[% FOREACH area IN areas %]
207
[% FOREACH area IN areas %]
208
<option value="[% area.id %]">[% area.name %]</option>
208
<option value="[% area.id %]">[% area.name %]</option>
Lines 222-228 canned reports and writing custom SQL reports.</p> Link Here
222
<h1>Build A Report</h1>
222
<h1>Build A Report</h1>
223
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
223
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
224
<input type="hidden" name="area" value="[% area %]" />
224
<input type="hidden" name="area" value="[% area %]" />
225
<fieldset class="rows"><legend>Step 2 of 6: Pick a Report Type</legend>
225
<fieldset class="rows"><legend>Step 2 of 6: Pick a report type</legend>
226
<ol><li><label for="types">Choose: </label>
226
<ol><li><label for="types">Choose: </label>
227
    <select id="types" name="types">
227
    <select id="types" name="types">
228
        <option value="1">Tabular</option>
228
        <option value="1">Tabular</option>
Lines 249-255 canned reports and writing custom SQL reports.</p> Link Here
249
[% END %]
249
[% END %]
250
250
251
[% IF ( build3 ) %]
251
[% IF ( build3 ) %]
252
<h3>Step 3 of 6: Select Columns for Display</h3>
252
<h3>Step 3 of 6: Select columns for display</h3>
253
<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>
253
<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>
254
254
255
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
255
<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
Lines 303-309 canned reports and writing custom SQL reports.</p> Link Here
303
    <input type="hidden" name="area" value="[% area %]" />
303
    <input type="hidden" name="area" value="[% area %]" />
304
    <input type="hidden" name="type" value="[% type %]" />
304
    <input type="hidden" name="type" value="[% type %]" />
305
    <input type="hidden" name="column" value="[% column %]" />
305
    <input type="hidden" name="column" value="[% column %]" />
306
    <fieldset><legend>Step 4 of 6: Select Criteria to Limit on</legend>
306
    <fieldset><legend>Step 4 of 6: Select criteria to limit on</legend>
307
    <table>
307
    <table>
308
        [% FOREACH criteri IN criteria %]
308
        [% FOREACH criteri IN criteria %]
309
        <tr>
309
        <tr>
Lines 314-320 canned reports and writing custom SQL reports.</p> Link Here
314
        [% IF ( criteri.date ) %]
314
        [% IF ( criteri.date ) %]
315
        <td>
315
        <td>
316
            <input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" />
316
            <input type="text" size="10" id="[% criteri.name %]_value" name="[% criteri.name %]_value" value="" />
317
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                 
317
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" />
318
            <script type="text/javascript">   
318
            <script type="text/javascript">   
319
            Calendar.setup({  
319
            Calendar.setup({  
320
            inputField     : "[% criteri.name %]_value",
320
            inputField     : "[% criteri.name %]_value",
Lines 337-343 canned reports and writing custom SQL reports.</p> Link Here
337
            [% IF ( criteri.daterange ) %]
337
            [% IF ( criteri.daterange ) %]
338
            <td>from 
338
            <td>from 
339
            <input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" />
339
            <input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" />
340
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                 
340
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromfrom_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" />
341
            <script type="text/javascript">   
341
            <script type="text/javascript">   
342
                Calendar.setup({  
342
                Calendar.setup({  
343
                inputField     : "from_[% criteri.name %]_value",
343
                inputField     : "from_[% criteri.name %]_value",
Lines 348-354 canned reports and writing custom SQL reports.</p> Link Here
348
            </script>         
348
            </script>         
349
            to
349
            to
350
            <input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" />
350
            <input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" />
351
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show Calendar" title="Show Calendar" />                 
351
            <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfromto_[% criteri.name %]" style="cursor: pointer;" alt="Show calendar" title="Show calendar" />
352
            <script type="text/javascript">   
352
            <script type="text/javascript">   
353
                Calendar.setup({  
353
                Calendar.setup({  
354
                inputField     : "to_[% criteri.name %]_value",
354
                inputField     : "to_[% criteri.name %]_value",
Lines 377-383 canned reports and writing custom SQL reports.</p> Link Here
377
    </fieldset>
377
    </fieldset>
378
378
379
[% IF ( definitions ) %]
379
[% IF ( definitions ) %]
380
<fieldset><legend>Dictionary Definitions</legend><table>
380
<fieldset><legend>Dictionary definitions</legend><table>
381
[% FOREACH definition IN definitions %]
381
[% FOREACH definition IN definitions %]
382
    <tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr>
382
    <tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr>
383
[% END %]
383
[% END %]
Lines 413-419 canned reports and writing custom SQL reports.</p> Link Here
413
[% END %]
413
[% END %]
414
</table></fieldset>
414
</table></fieldset>
415
415
416
<fieldset class="action"><input type="hidden" name="phase" value="Choose These Operations" />
416
<fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" />
417
    <input type="button" name="back" value="&lt;&lt; Back" onclick="javascript:history.back()" />
417
    <input type="button" name="back" value="&lt;&lt; Back" onclick="javascript:history.back()" />
418
    <input type="submit" name="submit" value="Next &gt;&gt;" /></fieldset>
418
    <input type="submit" name="submit" value="Next &gt;&gt;" /></fieldset>
419
</form>
419
</form>
Lines 443-456 canned reports and writing custom SQL reports.</p> Link Here
443
</table></fieldset>
443
</table></fieldset>
444
444
445
<fieldset class="action">
445
<fieldset class="action">
446
<input type="hidden" name="phase" value="Build Report" />
446
<input type="hidden" name="phase" value="Build report" />
447
<input type="submit" name="submit" value="Finish" /></fieldset>
447
<input type="submit" name="submit" value="Finish" /></fieldset>
448
</form>
448
</form>
449
[% END %]
449
[% END %]
450
450
451
451
452
[% IF ( showreport ) %]
452
[% IF ( showreport ) %]
453
<h1>Confirm Custom Report</h1>
453
<h1>Confirm custom report</h1>
454
<p>Your report will be generated with the following SQL statement.</p>
454
<p>Your report will be generated with the following SQL statement.</p>
455
<p> 
455
<p> 
456
[% sql |html %]
456
[% sql |html %]
Lines 470-482 canned reports and writing custom SQL reports.</p> Link Here
470
<input type="hidden" name="sql" value="[% sql |html %]" />
470
<input type="hidden" name="sql" value="[% sql |html %]" />
471
<input type="hidden" name="type" value="[% type %]" />
471
<input type="hidden" name="type" value="[% type %]" />
472
<fieldset class="rows">
472
<fieldset class="rows">
473
<legend>Save Your Custom Report</legend>
473
<legend>Save your custom report</legend>
474
<ol>
474
<ol>
475
    <li><label for="reportname">Report Name: </label><input type="text" id="reportname" name="reportname" /></li>
475
    <li><label for="reportname">Report name: </label><input type="text" id="reportname" name="reportname" /></li>
476
    <li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li>
476
    <li><label for="notes">Notes:</label> <textarea name="notes" id="notes"></textarea></li>
477
</ol></fieldset>
477
</ol></fieldset>
478
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" />
478
<fieldset class="action"><input type="hidden" name="phase" value="Save report" />
479
<input type="submit" name="submit" value="Save Report" /></fieldset>
479
<input type="submit" name="submit" value="Save report" /></fieldset>
480
</form>
480
</form>
481
[% END %]
481
[% END %]
482
482
Lines 490-496 canned reports and writing custom SQL reports.</p> Link Here
490
            [% IF sql_param.input == 'date' %]
490
            [% IF sql_param.input == 'date' %]
491
                <p>
491
                <p>
492
                [% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params">
492
                [% sql_param.entry %]: <input id="date_[% sql_param_entry %]" type="text" value="" size="10" name="sql_params">
493
                <img id="date_picker_[% sql_param_entry %]" alt="Show Calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif">
493
                <img id="date_picker_[% sql_param_entry %]" alt="Show calendar" src="/intranet-tmpl/prog/en/lib/calendar/cal.gif">
494
                <script type="text/javascript">
494
                <script type="text/javascript">
495
                      Calendar.setup( {
495
                      Calendar.setup( {
496
                         inputField : "date_[% sql_param_entry %]",
496
                         inputField : "date_[% sql_param_entry %]",
Lines 526-533 canned reports and writing custom SQL reports.</p> Link Here
526
<fieldset class="action">
526
<fieldset class="action">
527
<label for="format">Download the report: </label>
527
<label for="format">Download the report: </label>
528
<select name="format" id="format">
528
<select name="format" id="format">
529
<option value="csv">Comma Separated Text</option>
529
<option value="csv">Comma separated text</option>
530
<option value="tab">Tab Separated Text</option>
530
<option value="tab">Tab separated text</option>
531
</select>
531
</select>
532
<input type="hidden" name="sql" value="[% sql |html %]" />
532
<input type="hidden" name="sql" value="[% sql |html %]" />
533
<input type="hidden" name="phase" value="Export" />
533
<input type="hidden" name="phase" value="Export" />
Lines 539-547 canned reports and writing custom SQL reports.</p> Link Here
539
[% IF ( create ) %]
539
[% IF ( create ) %]
540
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
540
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
541
<fieldset class="rows">
541
<fieldset class="rows">
542
<legend>Create Report From SQL</legend>
542
<legend>Create report from SQL</legend>
543
<ol>
543
<ol>
544
    <li><label for="reportname">Report Name:</label> 
544
    <li><label for="reportname">Report name:</label> 
545
        [% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" />
545
        [% IF ( reportname ) %]<input type="text" id="reportname" name="reportname" value="[% reportname %]" />
546
        [% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] 
546
        [% ELSE %]<input type="text" id="reportname" name="reportname" />[% END %] 
547
    </li>
547
    </li>
Lines 562-568 canned reports and writing custom SQL reports.</p> Link Here
562
</div>
562
</div>
563
</fieldset>
563
</fieldset>
564
564
565
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" />
565
<fieldset class="action"><input type="hidden" name="phase" value="Save report" />
566
<input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a>
566
<input type="submit" name="submit" value="Save Report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">Cancel</a>
567
</fieldset>
567
</fieldset>
568
</form>
568
</form>
Lines 582-589 Sub report:<select name="subreport"> Link Here
582
[% END %]
582
[% END %]
583
</select>
583
</select>
584
<br />
584
<br />
585
<input type="hidden" name="phase" value="Save Compound" />
585
<input type="hidden" name="phase" value="Save compound" />
586
<input type="submit" name="submit" value="Save Compound" />
586
<input type="submit" name="submit" value="Save compound" />
587
</form>
587
</form>
588
[% END %]
588
[% END %]
589
589
Lines 594-600 Sub report:<select name="subreport"> Link Here
594
594
595
595
596
[% IF ( retresults ) %]
596
[% IF ( retresults ) %]
597
<h1>Saved Report Results</h1>
597
<h1>Saved report results</h1>
598
<h2>[% name %]</h2>
598
<h2>[% name %]</h2>
599
<p>[% notes %]</p>
599
<p>[% notes %]</p>
600
<table>
600
<table>
Lines 621-627 Sub report:<select name="subreport"> Link Here
621
<fieldset class="rows">
621
<fieldset class="rows">
622
<legend>Edit SQL report</legend>
622
<legend>Edit SQL report</legend>
623
<ol>
623
<ol>
624
<li><label for="reportname">Report Name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li>
624
<li><label for="reportname">Report name:</label><input type="text" id="reportname" name="reportname" value="[% reportname %]" size="50" /></li>
625
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li>
625
<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li>
626
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li>
626
<li><textarea id="sql" name="sql" rows="10" cols="60">[% sql %]</textarea></li>
627
</ol>
627
</ol>
Lines 643-651 Sub report:<select name="subreport"> Link Here
643
    [% IF ( id ) %]
643
    [% IF ( id ) %]
644
    <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&amp;phase=Run%20this%20report">Run this report</a></li>
644
    <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% id %]&amp;phase=Run%20this%20report">Run this report</a></li>
645
    [% END %]
645
    [% END %]
646
    <li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved Reports Page</a></li>
646
    <li>Access this report from the: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Saved reports page</a></li>
647
    <li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler Tool</a></li>
647
    <li>Schedule this report to run using the: <a href="/cgi-bin/koha/tools/scheduler.pl">Scheduler tool</a></li>
648
    <li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided Reports</a></li>
648
    <li>Return to: <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Guided reports</a></li>
649
</ul>
649
</ul>
650
[% END %]
650
[% END %]
651
[% END %]
651
[% END %]
Lines 664-670 Sub report:<select name="subreport"> Link Here
664
[% END %]
664
[% END %]
665
</div>
665
</div>
666
<fieldset class="action"><input type="hidden" name="phase" value="Use saved" />
666
<fieldset class="action"><input type="hidden" name="phase" value="Use saved" />
667
<input type="submit" name="submit" value="Saved Reports" /></fieldset>
667
<input type="submit" name="submit" value="Saved reports" /></fieldset>
668
</form>
668
</form>
669
[% END %]
669
[% END %]
670
670
Lines 681-687 Sub report:<select name="subreport"> Link Here
681
  <h3>Filter</h3>
681
  <h3>Filter</h3>
682
  <ol>
682
  <ol>
683
    <li><label for="filter_date">Date:
683
    <li><label for="filter_date">Date:
684
  <img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show Calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" />
684
  <img src="[% themelang %]/lib/calendar/cal.gif" id="datedueto_button" alt="Show calendar" /></label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filter_date %]" />
685
    <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
685
    <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
686
    <script type="text/javascript">
686
    <script type="text/javascript">
687
        Calendar.setup(
687
        Calendar.setup(
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt (-6 / +6 lines)
Lines 7-13 Link Here
7
[% INCLUDE 'header.inc' %]
7
[% INCLUDE 'header.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
8
[% INCLUDE 'cat-search.inc' %]
9
9
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]&rsaquo; <a href="/cgi-bin/koha/reports/issues_avg_stats.pl">Average Checkout Period</a> &rsaquo; Results [% ELSE %]&rsaquo; Average Checkout Period[% END %]</div>
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> [% IF ( do_it ) %]&rsaquo; <a href="/cgi-bin/koha/reports/issues_avg_stats.pl">Average checkout period</a> &rsaquo; Results [% ELSE %]&rsaquo; Average checkout period[% END %]</div>
11
11
12
<div id="doc3" class="yui-t2">
12
<div id="doc3" class="yui-t2">
13
   
13
   
Lines 17-23 Link Here
17
17
18
[% IF ( do_it ) %]
18
[% IF ( do_it ) %]
19
	[% FOREACH mainloo IN mainloop %]
19
	[% FOREACH mainloo IN mainloop %]
20
		<h1>Average Checkout Period</h1>
20
		<h1>Average checkout period</h1>
21
		[% IF ( mainloo.loopfilter ) %]
21
		[% IF ( mainloo.loopfilter ) %]
22
			<p>Filtered on</p>
22
			<p>Filtered on</p>
23
			[% FOREACH loopfilte IN mainloo.loopfilter %]
23
			[% FOREACH loopfilte IN mainloo.loopfilter %]
Lines 107-113 Link Here
107
									);
107
									);
108
								</script>
108
								</script>
109
					<label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
109
					<label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
110
						<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
110
						<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
111
							<script type="text/javascript">
111
							<script type="text/javascript">
112
								function validate2(date) {
112
								function validate2(date) {
113
									var day = date.getDate();
113
									var day = date.getDate();
Lines 154-160 Link Here
154
				<td><input type="radio" name="Line" value="returndate" /></td>
154
				<td><input type="radio" name="Line" value="returndate" /></td>
155
				<td><input type="radio" name="Column" value="returndate" /></td>
155
				<td><input type="radio" name="Column" value="returndate" /></td>
156
				<td > <label for="fromRO">From</label> <input type="text" size="10" id="fromRO" name="Filter" />
156
				<td > <label for="fromRO">From</label> <input type="text" size="10" id="fromRO" name="Filter" />
157
							<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFromRO" style="cursor: pointer;" />
157
							<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openCalendarFromRO" style="cursor: pointer;" />
158
								<script language="JavaScript" type="text/javascript">
158
								<script language="JavaScript" type="text/javascript">
159
									function validate1(date) {
159
									function validate1(date) {
160
										var day = date.getDate();
160
										var day = date.getDate();
Lines 183-189 Link Here
183
									);
183
									);
184
								</script>
184
								</script>
185
					<label for="toRO">To</label> <input type="text" size="10" id="toRO" name="Filter" value="" />
185
					<label for="toRO">To</label> <input type="text" size="10" id="toRO" name="Filter" value="" />
186
						<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarToRO" style="cursor: pointer;" border="0" />
186
						<img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openCalendarToRO" style="cursor: pointer;" border="0" />
187
							<script type="text/javascript">
187
							<script type="text/javascript">
188
								function validate2(date) {
188
								function validate2(date) {
189
									var day = date.getDate();
189
									var day = date.getDate();
Lines 245-251 Link Here
245
			</tr>
245
			</tr>
246
<!-- Modified according to statistics table
246
<!-- Modified according to statistics table
247
			<tr>
247
			<tr>
248
				<td>Issuing Library</td>
248
                <td>Issuing library</td>
249
				<td><input type="radio" name="Line" value="issuingbranch"></td>
249
				<td><input type="radio" name="Line" value="issuingbranch"></td>
250
				<td><input type="radio" name="Column" value="issuingbranch"></td>
250
				<td><input type="radio" name="Column" value="issuingbranch"></td>
251
				<td >[% CGIBranch %]</td>
251
				<td >[% CGIBranch %]</td>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_stats.tt (-10 / +10 lines)
Lines 84-90 Link Here
84
                <td><input type="radio" name="Line" value="datetime" /></td>
84
                <td><input type="radio" name="Line" value="datetime" /></td>
85
                <td><input type="radio" name="Column" value="datetime" /></td>
85
                <td><input type="radio" name="Column" value="datetime" /></td>
86
                <td><label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />
86
                <td><label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />
87
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
87
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
88
                   <script type="text/javascript">
88
                   <script type="text/javascript">
89
				   //<![CDATA[ 
89
				   //<![CDATA[ 
90
				   function validate1(date) {
90
				   function validate1(date) {
Lines 112-118 Link Here
112
					//]]>
112
					//]]>
113
					</script>
113
					</script>
114
                    <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
114
                    <label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />
115
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
115
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
116
                    <script type="text/javascript">
116
                    <script type="text/javascript">
117
					//<![CDATA[  
117
					//<![CDATA[  
118
					function validate2(date) {
118
					function validate2(date) {
Lines 156-162 Link Here
156
                    </select>
156
                    </select>
157
                </td>
157
                </td>
158
                <td>
158
                <td>
159
                    <label for="PeriodDaySel">Select Day: </label><select name="PeriodDaySel" id="PeriodDaySel">
159
                    <label for="PeriodDaySel">Select day: </label><select name="PeriodDaySel" id="PeriodDaySel">
160
                    <option value =""></option>
160
                    <option value =""></option>
161
                    <option value ="Monday">Monday</option>
161
                    <option value ="Monday">Monday</option>
162
                    <option value ="Tuesday">Tuesday</option>
162
                    <option value ="Tuesday">Tuesday</option>
Lines 166-172 Link Here
166
                    <option value ="Saturday">Saturday</option>
166
                    <option value ="Saturday">Saturday</option>
167
                    <option value ="Sunday">Sunday</option>
167
                    <option value ="Sunday">Sunday</option>
168
                    </select>
168
                    </select>
169
                    <label for="PeriodMonthSel">Select Month:</label> <select name="PeriodMonthSel" id="PeriodMonthSel">
169
                    <label for="PeriodMonthSel">Select month:</label> <select name="PeriodMonthSel" id="PeriodMonthSel">
170
                    <option value =""></option>
170
                    <option value =""></option>
171
                    <option value ="January">January</option>
171
                    <option value ="January">January</option>
172
                    <option value ="February">February</option>
172
                    <option value ="February">February</option>
Lines 184-190 Link Here
184
                </td>
184
                </td>
185
        </tr>
185
        </tr>
186
        <tr>
186
        <tr>
187
            <td>Patron Category</td>
187
            <td>Patron category</td>
188
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
188
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
189
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
189
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
190
           <td><select name="Filter" id="borcat">
190
           <td><select name="Filter" id="borcat">
Lines 196-202 Link Here
196
             </td> 
196
             </td> 
197
        </tr>
197
        </tr>
198
        <tr class="highlight">
198
        <tr class="highlight">
199
            <td>Item Type</td>
199
            <td>Item type</td>
200
            <td><input type="radio" name="Line" value="itemtype" /></td>
200
            <td><input type="radio" name="Line" value="itemtype" /></td>
201
            <td><input type="radio" name="Column" value="itemtype" /></td>
201
            <td><input type="radio" name="Column" value="itemtype" /></td>
202
           <td><select name="Filter" id="itemtype">
202
           <td><select name="Filter" id="itemtype">
Lines 232-238 Link Here
232
            </td>
232
            </td>
233
        </tr>
233
        </tr>
234
        <tr>
234
        <tr>
235
            <td>Shelving Location</td>
235
            <td>Shelving location</td>
236
            <td><input type="radio" name="Line" value="items.location" /></td>
236
            <td><input type="radio" name="Line" value="items.location" /></td>
237
            <td><input type="radio" name="Column" value="items.location" /></td>
237
            <td><input type="radio" name="Column" value="items.location" /></td>
238
            <td><select name="Filter" id="location">
238
            <td><select name="Filter" id="location">
Lines 244-256 Link Here
244
            </td> 
244
            </td> 
245
        </tr>
245
        </tr>
246
        <tr class="highlight">
246
        <tr class="highlight">
247
            <td>Item Call Number</td>
247
            <td>Item call number</td>
248
            <td></td>
248
            <td></td>
249
            <td></td>
249
            <td></td>
250
            <td>From <input type="text" name="Filter" size="10" /> (inclusive) to <input type="text" name="Filter" size="10" /> (exclusive) </td>
250
            <td>From <input type="text" name="Filter" size="10" /> (inclusive) to <input type="text" name="Filter" size="10" /> (exclusive) </td>
251
        </tr>
251
        </tr>
252
        [% IF ( hassort1 ) %]
252
        [% IF ( hassort1 ) %]
253
        <tr><td>Patron sort1</td>
253
        <tr><td>Patron sort 1</td>
254
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
254
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
255
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
255
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
256
			<td><select name="Filter" id="sort1">
256
			<td><select name="Filter" id="sort1">
Lines 263-269 Link Here
263
        </tr>
263
        </tr>
264
        [% END %]
264
        [% END %]
265
        [% IF ( hassort2 ) %]
265
        [% IF ( hassort2 ) %]
266
        <tr class="highlight"><td>Patron sort2</td>
266
        <tr class="highlight"><td>Patron sort 2</td>
267
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
267
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
268
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
268
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
269
           	<td><select name="Filter" id="sort2">
269
           	<td><select name="Filter" id="sort2">
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/itemslost.tt (-12 / +12 lines)
Lines 1-12 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Lost Items</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Lost items</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
</head>
4
</head>
5
<body id="rep_itemslost" class="rep">
5
<body id="rep_itemslost" class="rep">
6
[% INCLUDE 'header.inc' %]
6
[% INCLUDE 'header.inc' %]
7
[% INCLUDE 'cat-search.inc' %]
7
[% INCLUDE 'cat-search.inc' %]
8
8
9
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>[% IF ( get_items ) %] &rsaquo; <a href="/cgi-bin/koha/reports/itemslost.pl">Lost Items</a> &rsaquo; Results[% ELSE %] &rsaquo; Lost Items[% END %]</div>
9
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>[% IF ( get_items ) %] &rsaquo; <a href="/cgi-bin/koha/reports/itemslost.pl">Lost Items</a> &rsaquo; Results[% ELSE %] &rsaquo; Lost items[% END %]</div>
10
10
11
<div id="doc3" class="yui-t2">
11
<div id="doc3" class="yui-t2">
12
   
12
   
Lines 14-20 Link Here
14
	<div id="yui-main">
14
	<div id="yui-main">
15
	<div class="yui-b">
15
	<div class="yui-b">
16
16
17
<h1>Lost Items</h1>
17
<h1>Lost items</h1>
18
18
19
[% IF ( get_items ) %]
19
[% IF ( get_items ) %]
20
20
Lines 30-42 Link Here
30
    <tr>
30
    <tr>
31
        <th>Title</th>
31
        <th>Title</th>
32
        <th>Author</th>
32
        <th>Author</th>
33
        <th>Lost Code</th>
33
        <th>Lost code</th>
34
        <th>Barcode</th>
34
        <th>Barcode</th>
35
        <th>Date last seen</th>
35
        <th>Date last seen</th>
36
        <th>Price</th>
36
        <th>Price</th>
37
        <th>Rep.Price</th>
37
        <th>Rep.price</th>
38
        <th>Library</th>
38
        <th>Library</th>
39
        <th>Itemtype</th>
39
        <th>Item type</th>
40
        <th>Current location</th>
40
        <th>Current location</th>
41
        <th>Location</th>
41
        <th>Location</th>
42
        <th>Notes</th>
42
        <th>Notes</th>
Lines 76-87 Link Here
76
        <option value="title">Title</option>
76
        <option value="title">Title</option>
77
        <option value="author">Author</option>
77
        <option value="author">Author</option>
78
        <option value="homebranch">Home library</option>
78
        <option value="homebranch">Home library</option>
79
        <option value="itype">Itemtypes</option>
79
        <option value="itype">Item types</option>
80
        <option value="barcode">Barcode</option>
80
        <option value="barcode">Barcode</option>
81
        <option value="price">Price</option>
81
        <option value="price">Price</option>
82
        <option value="replacementprice">Replacement Price</option>
82
        <option value="replacementprice">Replacement price</option>
83
        <option value="lib">Lost Code</option>
83
        <option value="lib">Lost code</option>
84
        <option value="datelastseen">Date Last Seen</option>
84
        <option value="datelastseen">Date last seen</option>
85
        <option value="location">Location</option>
85
        <option value="location">Location</option>
86
    </select></li>
86
    </select></li>
87
	
87
	
Lines 95-101 Link Here
95
				[% END %]
95
				[% END %]
96
            [% END %]
96
            [% END %]
97
            </select></li>
97
            </select></li>
98
	<li><label for="itemtypesfilter">Item Type: </label><select name="itemtypesfilter" id="itemtypesfilter">
98
	<li><label for="itemtypesfilter">Item type: </label><select name="itemtypesfilter" id="itemtypesfilter">
99
                <option value="">All</option>
99
                <option value="">All</option>
100
                [% FOREACH itemtypeloo IN itemtypeloop %]
100
                [% FOREACH itemtypeloo IN itemtypeloop %]
101
                [% IF ( itemtypeloo.selected ) %]<option value="[% itemtypeloo.value %]" selected="selected">[% itemtypeloo.description %]</option>
101
                [% IF ( itemtypeloo.selected ) %]<option value="[% itemtypeloo.value %]" selected="selected">[% itemtypeloo.description %]</option>
Lines 105-111 Link Here
105
                [% END %]
105
                [% END %]
106
            </select></li>
106
            </select></li>
107
107
108
	<li><label for="loststatusfilter">Lost Status: </label><select name="loststatusfilter" id="loststatusfilter">
108
	<li><label for="loststatusfilter">Lost status: </label><select name="loststatusfilter" id="loststatusfilter">
109
                <option value="">All</option>
109
                <option value="">All</option>
110
                [% FOREACH loststatusloo IN loststatusloop %]
110
                [% FOREACH loststatusloo IN loststatusloop %]
111
                [% IF ( loststatusloo.selected ) %]<option value="[% loststatusloo.authorised_value %]" selected="selected">[% loststatusloo.lib %]</option>
111
                [% IF ( loststatusloo.selected ) %]<option value="[% loststatusloo.authorised_value %]" selected="selected">[% loststatusloo.lib %]</option>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/itemtypes.tt (-2 / +2 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; Catalog by Item Types</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Catalog by item types</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.tablesorter.min.js"></script>
4
<script type="text/javascript" src="[% themelang %]/lib/jquery/plugins/jquery.tablesorter.min.js"></script>
5
<script type="text/javascript">
5
<script type="text/javascript">
Lines 14-20 $(document).ready(function() { Link Here
14
[% INCLUDE 'header.inc' %]
14
[% INCLUDE 'header.inc' %]
15
[% INCLUDE 'cat-search.inc' %]
15
[% INCLUDE 'cat-search.inc' %]
16
16
17
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>[% IF ( do_it ) %] &rsaquo; <a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">Catalog by Item Type</a> &rsaquo; Results[% ELSE %] &rsaquo; Catalog by Item Type[% END %]</div>
17
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>[% IF ( do_it ) %] &rsaquo; <a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">Catalog by Item Type</a> &rsaquo; Results[% ELSE %] &rsaquo; Catalog by item type[% END %]</div>
18
18
19
<div id="doc3" class="yui-t2">
19
<div id="doc3" class="yui-t2">
20
   
20
   
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/reports-home.tt (-12 / +12 lines)
Lines 14-30 Link Here
14
14
15
	<div class="yui-g">
15
	<div class="yui-g">
16
	<h1>Reports</h1>
16
	<h1>Reports</h1>
17
	<div class="yui-u first"><h2>Guided Reports</h2>
17
	<div class="yui-u first"><h2>Guided reports</h2>
18
	<ul>
18
	<ul>
19
		<li><a href="/cgi-bin/koha/reports/guided_reports.pl">Guided Reports Wizard</a></li>
19
		<li><a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a></li>
20
		[% IF ( CAN_user_reports_create_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build New</a></li>[% END %]
20
		[% IF ( CAN_user_reports_create_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">Build new</a></li>[% END %]
21
		[% IF ( CAN_user_reports_execute_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Use Saved</a></li>[% END %]
21
		[% IF ( CAN_user_reports_execute_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">Use saved</a></li>[% END %]
22
		[% IF ( CAN_user_reports_create_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL">Create from SQL</a></li>[% END %]
22
		[% IF ( CAN_user_reports_create_reports ) %]<li><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL">Create from SQL</a></li>[% END %]
23
	</ul>
23
	</ul>
24
	
24
	
25
	<h5>Reports Dictionary</h5>
25
	<h5>Reports dictionary</h5>
26
	<ul>
26
	<ul>
27
		<li><a href="/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary">View Dictionary</a></li>
27
		<li><a href="/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary">View dictionary</a></li>
28
	</ul>
28
	</ul>
29
29
30
	<h2>Statistics wizards</h2>
30
	<h2>Statistics wizards</h2>
Lines 37-46 Link Here
37
		<li><a href="/cgi-bin/koha/reports/reserves_stats.pl">Holds</a></li>
37
		<li><a href="/cgi-bin/koha/reports/reserves_stats.pl">Holds</a></li>
38
	</ul></div>
38
	</ul></div>
39
39
40
	<div class="yui-u"><h2>Top Lists</h2>
40
	<div class="yui-u"><h2>Top lists</h2>
41
	<ul>
41
	<ul>
42
		<li><a href="/cgi-bin/koha/reports/bor_issues_top.pl">Patrons checking out the most</a></li>
42
		<li><a href="/cgi-bin/koha/reports/bor_issues_top.pl">Patrons checking out the most</a></li>
43
		<li><a href="/cgi-bin/koha/reports/cat_issues_top.pl">Most-Circulated Items</a></li>
43
		<li><a href="/cgi-bin/koha/reports/cat_issues_top.pl">Most-circulated items</a></li>
44
	</ul>	
44
	</ul>	
45
	
45
	
46
	<h2>Inactive</h2>
46
	<h2>Inactive</h2>
Lines 52-62 Link Here
52
	<h2>Other</h2>
52
	<h2>Other</h2>
53
	<ul>
53
	<ul>
54
		<li><a href="/cgi-bin/koha/reports/itemslost.pl">Items lost</a></li>
54
		<li><a href="/cgi-bin/koha/reports/itemslost.pl">Items lost</a></li>
55
		<li><a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">Catalog by itemtype</a></li>
55
		<li><a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">Catalog by item type</a></li>
56
		<li><a href="/cgi-bin/koha/reports/issues_avg_stats.pl">Average loan time</a></li>
56
		<li><a href="/cgi-bin/koha/reports/issues_avg_stats.pl">Average loan time</a></li>
57
		<li><a href="http://schema.koha-community.org/" target="blank">Koha Database Schema</a></li>
57
		<li><a href="http://schema.koha-community.org/" target="blank">Koha database schema</a></li>
58
		<li><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="blank">Koha Reports Library</a></li>
58
		<li><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="blank">Koha reports library</a></li>
59
		<!--<li><a href="/cgi-bin/koha/reports/stats.screen.pl">Till Reconciliation</a></li> -->
59
		<!--<li><a href="/cgi-bin/koha/reports/stats.screen.pl">Till reconciliation</a></li> -->
60
	</ul></div>
60
	</ul></div>
61
</div>
61
</div>
62
62
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/reservereport.tt (-3 / +3 lines)
Lines 1-12 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Hold Report &rsaquo; All Holds</title>
2
<title>Koha &rsaquo; Hold Report &rsaquo; All holds</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
</head>
4
</head>
5
<body id="rep_reservereport" class="rep">
5
<body id="rep_reservereport" class="rep">
6
[% INCLUDE 'header.inc' %]
6
[% INCLUDE 'header.inc' %]
7
[% INCLUDE 'cat-search.inc' %]
7
[% INCLUDE 'cat-search.inc' %]
8
8
9
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; All Holds</div>
9
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; All holds</div>
10
10
11
<div id="doc3" class="yui-t2">
11
<div id="doc3" class="yui-t2">
12
   
12
   
Lines 15-21 Link Here
15
	<div class="yui-b">
15
	<div class="yui-b">
16
16
17
<table>
17
<table>
18
	<tr><th>Name</th><th>Hold Date</th><th>Title</th><th>Class</th></tr>
18
	<tr><th>Name</th><th>Hold date</th><th>Title</th><th>Class</th></tr>
19
	[% FOREACH dataloo IN dataloop %]
19
	[% FOREACH dataloo IN dataloop %]
20
		<tr>
20
		<tr>
21
			<td>
21
			<td>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/reserves_stats.tt (-20 / +20 lines)
Lines 85-91 Link Here
85
        </thead>
85
        </thead>
86
        <tbody>
86
        <tbody>
87
        	<tr >
87
        	<tr >
88
                <td>Hold Status </td>
88
                <td>Hold status </td>
89
                <td><input type="radio" name="Line" value="reservestatus" /></td>
89
                <td><input type="radio" name="Line" value="reservestatus" /></td>
90
                <td><input type="radio" name="Column" value="reservestatus" checked="checked" /></td>
90
                <td><input type="radio" name="Column" value="reservestatus" checked="checked" /></td>
91
                <td>
91
                <td>
Lines 101-107 Link Here
101
                <td><input type="radio" name="Line" value="reservedate" /></td>
101
                <td><input type="radio" name="Line" value="reservedate" /></td>
102
                <td><input type="radio" name="Column" value="reservedate" /></td>
102
                <td><input type="radio" name="Column" value="reservedate" /></td>
103
                <td><label for="filter_reservedate_begin">From</label> <input type="text"  size="10" id="filter_reservedate_begin" name="filter_reservedate_begin" />
103
                <td><label for="filter_reservedate_begin">From</label> <input type="text"  size="10" id="filter_reservedate_begin" name="filter_reservedate_begin" />
104
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openreservedateFrom" style="cursor: pointer;" />
104
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openreservedateFrom" style="cursor: pointer;" />
105
                   <script type="text/javascript">
105
                   <script type="text/javascript">
106
				   //<![CDATA[ 
106
				   //<![CDATA[ 
107
				   function validate1(date) {
107
				   function validate1(date) {
Lines 129-135 Link Here
129
					//]]>
129
					//]]>
130
					</script>
130
					</script>
131
                    <label for="filter_reservedate_end">To</label> <input size="10" id="filter_reservedate_end" name="filter_reservedate_end" value="" type="text" />
131
                    <label for="filter_reservedate_end">To</label> <input size="10" id="filter_reservedate_end" name="filter_reservedate_end" value="" type="text" />
132
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openreservedateTo" style="cursor: pointer;" border="0" />
132
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openreservedateTo" style="cursor: pointer;" border="0" />
133
                    <script type="text/javascript">
133
                    <script type="text/javascript">
134
					//<![CDATA[  
134
					//<![CDATA[  
135
					function validate2(date) {
135
					function validate2(date) {
Lines 163-169 Link Here
163
                <td><input type="radio" name="Line" value="notificationdate" /></td>
163
                <td><input type="radio" name="Line" value="notificationdate" /></td>
164
                <td><input type="radio" name="Column" value="notificationdate" /></td>
164
                <td><input type="radio" name="Column" value="notificationdate" /></td>
165
                <td><label for="filter_notificationdate_begin">From</label> <input type="text"  size="10" id="filter_notificationdate_begin" name="filter_notificationdate_begin" />
165
                <td><label for="filter_notificationdate_begin">From</label> <input type="text"  size="10" id="filter_notificationdate_begin" name="filter_notificationdate_begin" />
166
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="opennotificationdateFrom" style="cursor: pointer;" />
166
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="opennotificationdateFrom" style="cursor: pointer;" />
167
                   <script type="text/javascript">
167
                   <script type="text/javascript">
168
				   //<![CDATA[ 
168
				   //<![CDATA[ 
169
				   function validate1(date) {
169
				   function validate1(date) {
Lines 191-197 Link Here
191
					//]]>
191
					//]]>
192
					</script>
192
					</script>
193
                    <label for="filter_notificationdate_end">To</label> <input  size="10" id="filter_notificationdate_end" name="filter_notificationdate_end" value="" type="text" />
193
                    <label for="filter_notificationdate_end">To</label> <input  size="10" id="filter_notificationdate_end" name="filter_notificationdate_end" value="" type="text" />
194
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="opennotificationdateTo" style="cursor: pointer;" border="0" />
194
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="opennotificationdateTo" style="cursor: pointer;" border="0" />
195
                    <script type="text/javascript">
195
                    <script type="text/javascript">
196
					//<![CDATA[  
196
					//<![CDATA[  
197
					function validate2(date) {
197
					function validate2(date) {
Lines 225-231 Link Here
225
                <td><input type="radio" name="Line" value="reminderdate" /></td>
225
                <td><input type="radio" name="Line" value="reminderdate" /></td>
226
                <td><input type="radio" name="Column" value="reminderdate" /></td>
226
                <td><input type="radio" name="Column" value="reminderdate" /></td>
227
                <td><label for="filter_reminderdate_begin">From</label> <input type="text"  size="10" id="filter_reminderdate_begin" name="Filter" />
227
                <td><label for="filter_reminderdate_begin">From</label> <input type="text"  size="10" id="filter_reminderdate_begin" name="Filter" />
228
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openreminderdateFrom" style="cursor: pointer;" />
228
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openreminderdateFrom" style="cursor: pointer;" />
229
                   <script type="text/javascript">
229
                   <script type="text/javascript">
230
				   //<![CDATA[ 
230
				   //<![CDATA[ 
231
				   function validate1(date) {
231
				   function validate1(date) {
Lines 253-259 Link Here
253
					//]]>
253
					//]]>
254
					</script>
254
					</script>
255
                    <label for="filter_reminderdate_end">To</label> <input size="10" id="filter_reminderdate_end" name="filter_reminderdate_end" value="" type="text" />
255
                    <label for="filter_reminderdate_end">To</label> <input size="10" id="filter_reminderdate_end" name="filter_reminderdate_end" value="" type="text" />
256
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openreminderdateTo" style="cursor: pointer;" border="0" />
256
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openreminderdateTo" style="cursor: pointer;" border="0" />
257
                    <script type="text/javascript">
257
                    <script type="text/javascript">
258
					//<![CDATA[  
258
					//<![CDATA[  
259
					function validate2(date) {
259
					function validate2(date) {
Lines 287-293 Link Here
287
                <td><input type="radio" name="Line" value="waitingdate" /></td>
287
                <td><input type="radio" name="Line" value="waitingdate" /></td>
288
                <td><input type="radio" name="Column" value="waitingdate" /></td>
288
                <td><input type="radio" name="Column" value="waitingdate" /></td>
289
                <td><label for="filter_waitingdate_begin">From</label> <input type="text"  size="10" id="filter_waitingdate_begin" name="filter_waitingdate_begin" />
289
                <td><label for="filter_waitingdate_begin">From</label> <input type="text"  size="10" id="filter_waitingdate_begin" name="filter_waitingdate_begin" />
290
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openwaitingdateFrom" style="cursor: pointer;" />
290
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="openwaitingdateFrom" style="cursor: pointer;" />
291
                   <script type="text/javascript">
291
                   <script type="text/javascript">
292
				   //<![CDATA[ 
292
				   //<![CDATA[ 
293
				   function validate1(date) {
293
				   function validate1(date) {
Lines 315-321 Link Here
315
					//]]>
315
					//]]>
316
					</script>
316
					</script>
317
                    <label for="filter_waitingdate_end">To</label> <input  size="10" id="filter_waitingdate_end" name="filter_waitingdate_end" value="" type="text" />
317
                    <label for="filter_waitingdate_end">To</label> <input  size="10" id="filter_waitingdate_end" name="filter_waitingdate_end" value="" type="text" />
318
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="openwaitingdateTo" style="cursor: pointer;" border="0" />
318
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="openwaitingdateTo" style="cursor: pointer;" border="0" />
319
                    <script type="text/javascript">
319
                    <script type="text/javascript">
320
					//<![CDATA[  
320
					//<![CDATA[  
321
					function validate2(date) {
321
					function validate2(date) {
Lines 349-355 Link Here
349
                <td><input type="radio" name="Line" value="cancellationdate" /></td>
349
                <td><input type="radio" name="Line" value="cancellationdate" /></td>
350
                <td><input type="radio" name="Column" value="cancellationdate" /></td>
350
                <td><input type="radio" name="Column" value="cancellationdate" /></td>
351
                <td><label for="filter_cancellationdate_begin">From</label> <input type="text"  size="10" id="filter_cancellationdate_begin" name="filter_cancellationdate_begin" />
351
                <td><label for="filter_cancellationdate_begin">From</label> <input type="text"  size="10" id="filter_cancellationdate_begin" name="filter_cancellationdate_begin" />
352
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="opencancellationdateFrom" style="cursor: pointer;" />
352
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" border="0" id="opencancellationdateFrom" style="cursor: pointer;" />
353
                   <script type="text/javascript">
353
                   <script type="text/javascript">
354
				   //<![CDATA[ 
354
				   //<![CDATA[ 
355
				   function validate1(date) {
355
				   function validate1(date) {
Lines 377-383 Link Here
377
					//]]>
377
					//]]>
378
					</script>
378
					</script>
379
                    <label for="filter_cancellationdate_end">To</label> <input  size="10" id="filter_cancellationdate_end" name="filter_cancellationdate_end" value="" type="text" />
379
                    <label for="filter_cancellationdate_end">To</label> <input  size="10" id="filter_cancellationdate_end" name="filter_cancellationdate_end" value="" type="text" />
380
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show Calendar" id="opencancellationdateTo" style="cursor: pointer;" border="0" />
380
                    <img src="[% themelang %]/lib/calendar/cal.gif" alt="Show calendar" id="opencancellationdateTo" style="cursor: pointer;" border="0" />
381
                    <script type="text/javascript">
381
                    <script type="text/javascript">
382
					//<![CDATA[  
382
					//<![CDATA[  
383
					function validate2(date) {
383
					function validate2(date) {
Lines 407-413 Link Here
407
                    </td>
407
                    </td>
408
             </tr>
408
             </tr>
409
        <tr>
409
        <tr>
410
            <td>Patron Category</td>
410
            <td>Patron category</td>
411
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
411
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
412
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
412
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
413
           <td><select name="filter_categorycode" id="borcat">
413
           <td><select name="filter_categorycode" id="borcat">
Lines 419-425 Link Here
419
             </td> 
419
             </td> 
420
        </tr>
420
        </tr>
421
        <tr class="highlight">
421
        <tr class="highlight">
422
            <td>Item Type</td>
422
            <td>Item type</td>
423
            <td><input type="radio" name="Line" value="items.itype" /></td>
423
            <td><input type="radio" name="Line" value="items.itype" /></td>
424
            <td><input type="radio" name="Column" value="items.itype" /></td>
424
            <td><input type="radio" name="Column" value="items.itype" /></td>
425
           <td><select name="filter_items.itype" id="itype">
425
           <td><select name="filter_items.itype" id="itype">
Lines 431-437 Link Here
431
             </td> 
431
             </td> 
432
        </tr>
432
        </tr>
433
        <tr>
433
        <tr>
434
            <td>Pickup Library</td>
434
            <td>Pickup library</td>
435
            <td><input type="radio" name="Line" value="reserves.branchcode" checked="checked" /></td>
435
            <td><input type="radio" name="Line" value="reserves.branchcode" checked="checked" /></td>
436
            <td><input type="radio" name="Column" value="reserves.branchcode" /></td>
436
            <td><input type="radio" name="Column" value="reserves.branchcode" /></td>
437
            <td><select name="filter_reserves.branchcode" id="resbranchcode">
437
            <td><select name="filter_reserves.branchcode" id="resbranchcode">
Lines 443-449 Link Here
443
             </td> 
443
             </td> 
444
        </tr>
444
        </tr>
445
        <tr class="highlight">
445
        <tr class="highlight">
446
            <td>Holding Library</td>
446
            <td>Holding library</td>
447
            <td><input type="radio" name="Line" value="items.holdingbranch" /></td>
447
            <td><input type="radio" name="Line" value="items.holdingbranch" /></td>
448
            <td><input type="radio" name="Column" value="items.holdingbranch" /></td>
448
            <td><input type="radio" name="Column" value="items.holdingbranch" /></td>
449
            <td><select name="filter_items.holdingbranch" id="holdingbranch">
449
            <td><select name="filter_items.holdingbranch" id="holdingbranch">
Lines 455-461 Link Here
455
             </td> 
455
             </td> 
456
        </tr>
456
        </tr>
457
        <tr>
457
        <tr>
458
            <td>Home Library</td>
458
            <td>Home library</td>
459
            <td><input type="radio" name="Line" value="items.homebranch" /></td>
459
            <td><input type="radio" name="Line" value="items.homebranch" /></td>
460
            <td><input type="radio" name="Column" value="items.homebranch" /></td>
460
            <td><input type="radio" name="Column" value="items.homebranch" /></td>
461
            <td><select name="filter_items.homebranch" id="homebranch">
461
            <td><select name="filter_items.homebranch" id="homebranch">
Lines 479-485 Link Here
479
            </td>
479
            </td>
480
        </tr>
480
        </tr>
481
        <tr>
481
        <tr>
482
            <td>Shelving Location</td>
482
            <td>Shelving location</td>
483
            <td><input type="radio" name="Line" value="items.location" /></td>
483
            <td><input type="radio" name="Line" value="items.location" /></td>
484
            <td><input type="radio" name="Column" value="items.location" /></td>
484
            <td><input type="radio" name="Column" value="items.location" /></td>
485
            <td><select name="filter_items.location" id="location">
485
            <td><select name="filter_items.location" id="location">
Lines 491-503 Link Here
491
            </td> 
491
            </td> 
492
        </tr>
492
        </tr>
493
        <tr class="highlight">
493
        <tr class="highlight">
494
            <td>Item Call Number</td>
494
            <td>Item call number</td>
495
            <td></td>
495
            <td></td>
496
            <td></td>
496
            <td></td>
497
            <td>From <input type="text" name="filter_items.itemcallnumber_begin" size="10" /> (inclusive) to <input type="text" name="filter_items.itemcallnumber_endex" size="10" /> (exclusive) </td>
497
            <td>From <input type="text" name="filter_items.itemcallnumber_begin" size="10" /> (inclusive) to <input type="text" name="filter_items.itemcallnumber_endex" size="10" /> (exclusive) </td>
498
        </tr>
498
        </tr>
499
        [% IF ( hassort1 ) %]
499
        [% IF ( hassort1 ) %]
500
        <tr><td>Patron sort1</td>
500
        <tr><td>Patron sort 1</td>
501
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
501
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
502
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
502
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
503
			<td><select name="filter_borrowers.sort1" id="sort1">
503
			<td><select name="filter_borrowers.sort1" id="sort1">
Lines 510-516 Link Here
510
        </tr>
510
        </tr>
511
        [% END %]
511
        [% END %]
512
        [% IF ( hassort2 ) %]
512
        [% IF ( hassort2 ) %]
513
        <tr class="highlight"><td>Patron sort2</td>
513
        <tr class="highlight"><td>Patron sort 2</td>
514
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
514
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
515
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
515
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
516
           	<td><select name="filter_borrowers.sort2" id="sort2">
516
           	<td><select name="filter_borrowers.sort2" id="sort2">
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/serials_stats.tt (-5 / +5 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %]
1
[% INCLUDE 'doc-head-open.inc' %]
2
<title>Koha &rsaquo; Reports &rsaquo; serials subscriptions stats</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Serials subscriptions stats</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
<style type="text/css">
4
<style type="text/css">
5
	.sql {display: none;}
5
	.sql {display: none;}
Lines 19-25 Link Here
19
[% INCLUDE 'header.inc' %]
19
[% INCLUDE 'header.inc' %]
20
[% INCLUDE 'cat-search.inc' %]
20
[% INCLUDE 'cat-search.inc' %]
21
21
22
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Items with no checkouts</div>
22
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Serials subscriptions stats</div>
23
23
24
<div id="doc3" class="yui-t2">
24
<div id="doc3" class="yui-t2">
25
   <div id="bd">
25
   <div id="bd">
Lines 35-43 Link Here
35
				<th>Title</th>
35
				<th>Title</th>
36
				<th>Subscription id</th>
36
				<th>Subscription id</th>
37
				<th>Branch</th>
37
				<th>Branch</th>
38
				<th>Call Number</th>
38
				<th>Call number</th>
39
				<th>Subscription Begin</th>
39
				<th>Subscription begin</th>
40
				<th>Subscription End</th>
40
				<th>Subscription end</th>
41
			</tr>
41
			</tr>
42
		</thead>
42
		</thead>
43
		<tbody>
43
		<tbody>
(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/stats_screen.tt (-18 / +17 lines)
Lines 1-5 Link Here
1
[% INCLUDE 'doc-head-open.inc' %] 
1
[% INCLUDE 'doc-head-open.inc' %] 
2
<title>Koha &rsaquo; Reports &rsaquo; Till Reconciliation</title>
2
<title>Koha &rsaquo; Reports &rsaquo; Till reconciliation</title>
3
[% INCLUDE 'doc-head-close.inc' %]
3
[% INCLUDE 'doc-head-close.inc' %]
4
[% INCLUDE 'calendar.inc' %] 
4
[% INCLUDE 'calendar.inc' %] 
5
5
Lines 7-13 Link Here
7
<body id="rep_stats_screen" class="rep">
7
<body id="rep_stats_screen" class="rep">
8
[% INCLUDE 'header.inc' %]
8
[% INCLUDE 'header.inc' %]
9
[% INCLUDE 'circ-search.inc' %]
9
[% INCLUDE 'circ-search.inc' %]
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Till Reconciliation
10
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> &rsaquo; Till reconciliation
11
</div>
11
</div>
12
12
13
<div id="doc3" class="yui-t2">
13
<div id="doc3" class="yui-t2">
Lines 16-28 Link Here
16
	<div id="yui-main">
16
	<div id="yui-main">
17
	<div class="yui-b">
17
	<div class="yui-b">
18
18
19
<h1>Till Reconciliation</h1>
19
<h1>Till reconciliation</h1>
20
20
21
<fieldset><legend>Search between two dates</legend>
21
<fieldset><legend>Search between two dates</legend>
22
<form action="stats.screen.pl" method="post">
22
<form action="stats.screen.pl" method="post">
23
  <label for="from">Start Date: </label>
23
  <label for="from">Start Date: </label>
24
  <input type="text" name="time" size="10" value="[% IF ( date ) %][% date %][% ELSE %]today[% END %]" id="from" /> 
24
  <input type="text" name="time" size="10" value="[% IF ( date ) %][% date %][% ELSE %]today[% END %]" id="from" /> 
25
  <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom1" alt="Show Calendar" style="cursor: pointer;" />
25
  <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonfrom1" alt="Show calendar" style="cursor: pointer;" />
26
     <script type="text/javascript">
26
     <script type="text/javascript">
27
     Calendar.setup({
27
     Calendar.setup({
28
     inputField     :    "from",
28
     inputField     :    "from",
Lines 33-39 Link Here
33
     </script>
33
     </script>
34
  <label for="to">End Date: </label>
34
  <label for="to">End Date: </label>
35
  <input type="text" name="time2" size="10" value="[% IF ( date2 ) %][% date2 %][% ELSE %]tomorrow[% END %]" id="to" />
35
  <input type="text" name="time2" size="10" value="[% IF ( date2 ) %][% date2 %][% ELSE %]tomorrow[% END %]" id="to" />
36
  <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonto1" alt="Show Calendar" style="cursor: pointer;" />
36
  <img src="[% themelang %]/lib/calendar/cal.gif" id="buttonto1" alt="Show calendar" style="cursor: pointer;" />
37
     <script type="text/javascript">
37
     <script type="text/javascript">
38
     Calendar.setup({
38
     Calendar.setup({
39
     inputField     :    "to",
39
     inputField     :    "to",
Lines 42-48 Link Here
42
     align          :    "Tl"
42
     align          :    "Tl"
43
     });
43
     });
44
     </script>
44
     </script>
45
  <input type="submit" value="To Screen" name="submit" class="submit" />
45
  <input type="submit" value="To screen" name="submit" class="submit" />
46
<!--  <input type="submit" value="To Excel" name="submit" class="button"> --></fieldset>
46
<!--  <input type="submit" value="To Excel" name="submit" class="button"> --></fieldset>
47
</form>
47
</form>
48
48
Lines 53-64 Link Here
53
                        <th>Library</th>
53
                        <th>Library</th>
54
                        <th>Date/time</th>
54
                        <th>Date/time</th>
55
                        <th>Surname</th>
55
                        <th>Surname</th>
56
                        <th>Firstname</th>
56
                        <th>First name</th>
57
                        <th>Description</th>
57
                        <th>Description</th>
58
                        <th>Charge Type</th>
58
                        <th>Charge type</th>
59
                        <th>Invoice Amount</th>
59
                        <th>Invoice amount</th>
60
                        <th>Payment Type</th>
60
                        <th>Payment type</th>
61
                        <th>Payment Amount</th>
61
                        <th>Payment amount</th>
62
                </tr>
62
                </tr>
63
63
64
                [% FOREACH loop IN loop1 %]
64
                [% FOREACH loop IN loop1 %]
Lines 88-97 Link Here
88
                        <th>Library</th>
88
                        <th>Library</th>
89
                        <th>Date/time</th>
89
                        <th>Date/time</th>
90
                        <th>Surname</th>
90
                        <th>Surname</th>
91
                        <th>Firstname</th>
91
                        <th>First name</th>
92
                        <th>Description</th>
92
                        <th>Description</th>
93
                        <th>Charge Type</th>
93
                        <th>Charge type</th>
94
                        <th>Invoice Amount</th>
94
                        <th>Invoice amount</th>
95
                </tr>
95
                </tr>
96
96
97
                [% FOREACH loop IN loop2 %]
97
                [% FOREACH loop IN loop2 %]
Lines 119-128 Link Here
119
                        <th>Library</th>
119
                        <th>Library</th>
120
                        <th>Date/time</th>
120
                        <th>Date/time</th>
121
                        <th>Surname</th>
121
                        <th>Surname</th>
122
                        <th>Firstname</th>
122
                        <th>First name</th>
123
                        <th>Description</th>
123
                        <th>Description</th>
124
                        <th>Charge Type</th>
124
                        <th>Charge type</th>
125
                        <th>Invoice Amount</th>
125
                        <th>Invoice amount</th>
126
                </tr>
126
                </tr>
127
127
128
                [% FOREACH loop IN loop3 %]
128
                [% FOREACH loop IN loop3 %]
129
- 

Return to bug 2780