Attachment #145858 for bug #32586

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




<title>Items with no checkouts &rsaquo; Reports &rsaquo; Koha</title>
[% INCLUDE 'doc-head-close.inc' %]
<style>
    .sql {display: none;}
</style>
</head>

<body id="rep_catalogue_out" class="rep">
[% WRAPPER 'header.inc' %]
    [% INCLUDE 'cat-search.inc' %]

    <div class="row">
        <div class="col-sm-10 col-sm-push-2">
            <main>
                [% IF ( do_it ) %]
                    <h1>Items with no checkouts</h1>
                    [% FOREACH mainloo IN mainloop %]
                        [% IF ( mainloo.loopfilter ) %]
                            <p>Filtered on:</p>
                            [% FOREACH loopfilte IN mainloo.loopfilter %]
                                [% IF ( loopfilte.err ) %]
                                    <p class="error">Error:
                                [% ELSE %]
                                    <p>
                                [% END %]
                                [% IF ( loopfilte.sql ) %]<span class="sql">[% END %]
                                [% loopfilte.crit | html %] = [% loopfilte.filter | html %]
                                [% IF ( loopfilte.sql ) %]</span>[% END %]
                                </p>
                            [% END %]
                        [% END %]

                        [% IF ( mainloo.looptables ) %]
                            <h3><a name="summary" id="summary"></a>Summary</h3>
                            <table id="summary_table">
                                <tr>
                                    <th>Group</th>
                                    <th>Call number range</th>
                                    <th>Number of items displayed</th>
                                    <th>Total items in group</th>
                                </tr>
                                [% FOREACH looptable IN mainloo.looptables %]
                                    <tr>
                                        <td>
                                            <a href="#table[% looptable.coltitle | uri %]">[% looptable.coltitle | html %]</a>
                                        </td>
                                        <td>
                                            [% IF ( looptable.looptable_count ) %]
                                                [% looptable.looptable_first | html %] to [% looptable.looptable_last | html %]
                                            [% END %]
                                        </td>
                                        <td>[% looptable.looptable_count | html %]</td>
                                        <td>[% looptable.coltitle_count | html %]</td>
                                    </tr>
                                [% END %]
                                <tr>
                                    <th>TOTAL</th>
                                    <th></th>
                                    <th>[% mainloo.total_looptable_count | html %]</th>
                                    <th>[% mainloo.total_coltitle_count | html %]</th>
                                </tr>
                            </table>
                        [% END %]
				<tr><th>TOTAL</th><th></th><th>[% mainloo.total_looptable_count | html %]</th><th>[% mainloo.total_coltitle_count | html %]</th>
				</tr>
			</table>

                        [% FOREACH looptable IN mainloo.looptables %]
                            <h3>
                                <a id="table[% looptable.coltitle | html %]"></a>
                                [% looptable.coltitle | html %]
                            </h3>
                            <table>
                                <tr>
                                    <th>#</th>
                                    <th>Call number</th>
                                    <th>Barcode</th>
                                    <th>Item details</th>
                                </tr>
                                [% IF ( looptable.looprow ) %]
                                    [% FOREACH loopro IN looptable.looprow %]
                                        <tr>
                                            <td>[% loop.count | html %]</td>
                                            <td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber | html %][% ELSE %]No call number[% END %]</td>
                                            <td>[% IF ( loopro.barcode ) %][% loopro.barcode | html %][% ELSE %]No barcode[% END %]</td>
                                            <td>
                                                <p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber | uri %]">[% IF ( loopro.title ) %][% loopro.title | html %][% ELSE %]NO TITLE[% END %]</a> [% IF ( loopro.author ) %] by [% loopro.author | html %][% END %]</p>
                                                [% IF ( loopro.branch ) %]at [% Branches.GetName( loopro.branch ) | html %][% END %]
                                            </td>
                                        </tr>
                                    [% END %]
                                    [% ELSE %]
                                        <tr>
                                            <td colspan="4">No items for [% looptable.coltitle | html %]</td>
                                        </tr>
                                    [% END %]
                            </table>
                        [% END %]
                    [% END %]
                [% ELSE %]
	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
	
	<fieldset class="rows">
		<ol>
			<li><label for="branch">Library: </label>
	<select name="Filter" id="branch">
        <option value="">Any library</option>
        [% PROCESS options_for_libraries libraries => Branches.all() %]
    </select></li>
      <li> 
        <label for="documenttype">Item type: </label><select name="Filter" id="documenttype">
        <option value="">Any item type</option>
    [% FOREACH itemtype IN itemtypes %]
        <option value="[% itemtype.itemtype | html %]">[% itemtype.translated_description | html %]</option>
     [% END %] 
    </select>
    </li>
		</ol>	
	</fieldset>
	
	<fieldset class="rows">
	<legend>Limits</legend>
		<ol>
        <li>
            <label for="numberlimit">Limit to: </label>
            <select name="Limit" id="numberlimit">
                <option value ="10">10</option>
                <option value ="20">20</option>
                <option value ="50">50</option>
                <option value ="100">100</option>
                <option value ="200">200</option>
                <option value ="300">300</option>
                <option value ="400">400</option>
                <option value ="500">500</option>
                <option value ="1000">1000</option>
            </select>
        </li>
		<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
						<option value ="" selected="selected">None</option>
						<option value ="homebranch">Library</option>
                        <option value ="itype">Item type</option>
					</select></li>
		</ol>
	</fieldset>

                    <h1>Items with no checkouts</h1>

                    <form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
                        <fieldset class="rows">
                            <ol>
                                <li>
                                    <label for="branch">Library: </label>
                                    <select name="Filter" id="branch">
                                        <option value="">Any library</option>
                                        [% PROCESS options_for_libraries libraries => Branches.all() %]
                                    </select>
                                </li>
                                <li>
                                    <label for="documenttype">Item type: </label>
                                    <select name="Filter" id="documenttype">
                                        <option value="">Any item type</option>
                                        [% FOREACH itemtype IN itemtypes %]
                                            <option value="[% itemtype.itemtype | html %]">[% itemtype.translated_description | html %]</option>
                                        [% END %]
                                    </select>
                                </li>
                            </ol>
                    </fieldset>

                    <fieldset class="rows">
                        <legend>Limits</legend>
                        <ol>
                            <li>
                                <label for="numberlimit">Limit to: </label>
                                <select name="Limit" id="numberlimit">
                                    <option value ="10">10</option>
                                    <option value ="20">20</option>
                                    <option value ="50">50</option>
                                    <option value ="100">100</option>
                                    <option value ="200">200</option>
                                    <option value ="300">300</option>
                                    <option value ="400">400</option>
                                    <option value ="500">500</option>
                                    <option value ="1000">1000</option>
                                </select>
                            </li>
                            <li>
                                <label for="criteria">By: </label>
                                <select name="Criteria" id="criteria">
                                    <option value ="" selected="selected">None</option>
                                    <option value ="homebranch">Library</option>
                                    <option value ="itype">Item type</option>
                                </select>
                            </li>
                        </ol>
                    </fieldset>

                    <fieldset class="action">
                        <input type="submit" class="btn btn-primary" value="Submit" />
                        <input type="hidden" name="report_name" value="[% report_name | html %]" />
                        <input type="hidden" name="do_it" value="1" />
                        <input type="hidden" name="output" value="screen" />
                    </fieldset>
                </form>
            [% END %]

            </main>
        </div> <!-- /.col-sm-10.col-sm-push-2 -->

        <div class="col-sm-2 col-sm-pull-10">
            <aside>
                [% INCLUDE 'reports-menu.inc' %]
            </aside>
    </div> <!-- /.col-sm-2.col-sm-pull-10 -->
</div> <!-- /.row -->

[% INCLUDE 'intranet-bottom.inc' %]
- 

Return to bug 32586

Lines 3-11 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_out.tt (-124 / +145 lines)
3	<title>Items with no checkouts &rsaquo; Reports &rsaquo; Koha</title>	3	<title>Items with no checkouts &rsaquo; Reports &rsaquo; Koha</title>
4	[% INCLUDE 'doc-head-close.inc' %]	4	[% INCLUDE 'doc-head-close.inc' %]
5	<style>	5	<style>
6	.sql {display: none;}	6	.sql {display: none;}
7	</style>	7	</style>
8	</head>	8	</head>
		9
9	<body id="rep_catalogue_out" class="rep">	10	<body id="rep_catalogue_out" class="rep">
10	[% WRAPPER 'header.inc' %]	11	[% WRAPPER 'header.inc' %]
11	[% INCLUDE 'cat-search.inc' %]	12	[% INCLUDE 'cat-search.inc' %]
Lines 33-169 Link Here
33	<div class="row">	34	<div class="row">
34	<div class="col-sm-10 col-sm-push-2">	35	<div class="col-sm-10 col-sm-push-2">
35	<main>	36	<main>
		37	[% IF ( do_it ) %]
		38	<h1>Items with no checkouts</h1>
		39	[% FOREACH mainloo IN mainloop %]
		40	[% IF ( mainloo.loopfilter ) %]
		41	<p>Filtered on:</p>
		42	[% FOREACH loopfilte IN mainloo.loopfilter %]
		43	[% IF ( loopfilte.err ) %]
		44	<p class="error">Error:
		45	[% ELSE %]
		46	<p>
		47	[% END %]
		48	[% IF ( loopfilte.sql ) %]<span class="sql">[% END %]
		49	[% loopfilte.crit \| html %] = [% loopfilte.filter \| html %]
		50	[% IF ( loopfilte.sql ) %]</span>[% END %]
		51	</p>
		52	[% END %]
		53	[% END %]
36		54
37	[% IF ( do_it ) %]	55	[% IF ( mainloo.looptables ) %]
38	<h1>Items with no checkouts</h1>	56	<h3><a name="summary" id="summary"></a>Summary</h3>
39	[% FOREACH mainloo IN mainloop %]	57	<table id="summary_table">
40	[% IF ( mainloo.loopfilter ) %]	58	<tr>
41	<p>Filtered on:</p>	59	<th>Group</th>
42	[% FOREACH loopfilte IN mainloo.loopfilter %]	60	<th>Call number range</th>
43	[% IF ( loopfilte.err ) %]<p class="error">Error:	61	<th>Number of items displayed</th>
44	[% ELSE %]<p>	62	<th>Total items in group</th>
45	[% END %]	63	</tr>
46	[% IF ( loopfilte.sql ) %]<span class="sql">[% END %]	64	[% FOREACH looptable IN mainloo.looptables %]
47	[% loopfilte.crit \| html %] = [% loopfilte.filter \| html %]	65	<tr>
48	[% IF ( loopfilte.sql ) %]</span>[% END %]	66	<td>
49	</p>	67	<a href="#table[% looptable.coltitle \| uri %]">[% looptable.coltitle \| html %]</a>
50	[% END %]	68	</td>
51	[% END %]	69	<td>
52		70	[% IF ( looptable.looptable_count ) %]
53	[% IF ( mainloo.looptables ) %]	71	[% looptable.looptable_first \| html %] to [% looptable.looptable_last \| html %]
54	<h3><a name="summary" id="summary"></a>Summary</h3>	72	[% END %]
55	<table id="summary_table">	73	</td>
56	<tr><th>Group</th><th>Call number range</th><th>Number of items displayed</th><th>Total items in group</th>	74	<td>[% looptable.looptable_count \| html %]</td>
57	</tr>	75	<td>[% looptable.coltitle_count \| html %]</td>
58	[% FOREACH looptable IN mainloo.looptables %]	76	</tr>
59	<tr><td><a href="#table[% looptable.coltitle \| uri %]">[% looptable.coltitle \| html %]</a></td>	77	[% END %]
60	<td>[% IF ( looptable.looptable_count ) %]	78	<tr>
61	[% looptable.looptable_first \| html %] to [% looptable.looptable_last \| html %]	79	<th>TOTAL</th>
62	[% END %]	80	<th></th>
63	</td>	81	<th>[% mainloo.total_looptable_count \| html %]</th>
64	<td>[% looptable.looptable_count \| html %]</td>	82	<th>[% mainloo.total_coltitle_count \| html %]</th>
65	<td>[% looptable.coltitle_count \| html %]</td>	83	</tr>
66	</tr>	84	</table>
67	[% END %]	85	[% END %]
68	<tr><th>TOTAL</th><th></th><th>[% mainloo.total_looptable_count \| html %]</th><th>[% mainloo.total_coltitle_count \| html %]</th>
69	</tr>
70	</table>
71		86
72	[% END %]	87	[% FOREACH looptable IN mainloo.looptables %]
73	[% FOREACH looptable IN mainloo.looptables %]	88	<h3>
74	<h3><a id="table[% looptable.coltitle \| html %]"></a>	89	<a id="table[% looptable.coltitle \| html %]"></a>
75	[% looptable.coltitle \| html %]	90	[% looptable.coltitle \| html %]
76	</h3>	91	</h3>
77	<table>	92	<table>
78	<tr>	93	<tr>
79	<th>#</th>	94	<th>#</th>
80	<th>Call number</th>	95	<th>Call number</th>
81	<th>Barcode</th>	96	<th>Barcode</th>
82	<th>Item details</th>	97	<th>Item details</th>
83	</tr>	98	</tr>
84	[% IF ( looptable.looprow ) %]	99	[% IF ( looptable.looprow ) %]
85	[% FOREACH loopro IN looptable.looprow %]	100	[% FOREACH loopro IN looptable.looprow %]
86	<tr>	101	<tr>
87		102	<td>[% loop.count \| html %]</td>
88	<td>[% loop.count \| html %]</td>	103	<td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber \| html %][% ELSE %]No call number[% END %]</td>
89	<td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber \| html %][% ELSE %]No call number[% END %]</td>	104	<td>[% IF ( loopro.barcode ) %][% loopro.barcode \| html %][% ELSE %]No barcode[% END %]</td>
90	<td>[% IF ( loopro.barcode ) %][% loopro.barcode \| html %][% ELSE %]No barcode[% END %]</td>	105	<td>
91	<td><p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber \| uri %]">[% IF ( loopro.title ) %][% loopro.title \| html %][% ELSE %]NO TITLE[% END %]</a> [% IF ( loopro.author ) %] by [% loopro.author \| html %][% END %]</p>	106	<p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber \| uri %]">[% IF ( loopro.title ) %][% loopro.title \| html %][% ELSE %]NO TITLE[% END %]</a> [% IF ( loopro.author ) %] by [% loopro.author \| html %][% END %]</p>
92	[% IF ( loopro.branch ) %]at [% Branches.GetName( loopro.branch ) \| html %][% END %]	107	[% IF ( loopro.branch ) %]at [% Branches.GetName( loopro.branch ) \| html %][% END %]
93	</td>	108	</td>
94	</tr>	109	</tr>
95	[% END %]	110	[% END %]
96	[% ELSE %]	111	[% ELSE %]
97	<tr><td colspan="4">No items for [% looptable.coltitle \| html %]</td>	112	<tr>
98	</tr>	113	<td colspan="4">No items for [% looptable.coltitle \| html %]</td>
99	[% END %]	114	</tr>
100	</table>	115	[% END %]
101	[% END %]	116	</table>
102	[% END %]	117	[% END %]
103	[% ELSE %]	118	[% END %]
104	<h1>Items with no checkouts</h1>	119	[% ELSE %]
105	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
106
107	<fieldset class="rows">
108	<ol>
109	<li><label for="branch">Library: </label>
110	<select name="Filter" id="branch">
111	<option value="">Any library</option>
112	[% PROCESS options_for_libraries libraries => Branches.all() %]
113	</select></li>
114	<li>
115	<label for="documenttype">Item type: </label><select name="Filter" id="documenttype">
116	<option value="">Any item type</option>
117	[% FOREACH itemtype IN itemtypes %]
118	<option value="[% itemtype.itemtype \| html %]">[% itemtype.translated_description \| html %]</option>
119	[% END %]
120	</select>
121	</li>
122	</ol>
123	</fieldset>
124
125	<fieldset class="rows">
126	<legend>Limits</legend>
127	<ol>
128	<li>
129	<label for="numberlimit">Limit to: </label>
130	<select name="Limit" id="numberlimit">
131	<option value ="10">10</option>
132	<option value ="20">20</option>
133	<option value ="50">50</option>
134	<option value ="100">100</option>
135	<option value ="200">200</option>
136	<option value ="300">300</option>
137	<option value ="400">400</option>
138	<option value ="500">500</option>
139	<option value ="1000">1000</option>
140	</select>
141	</li>
142	<li><label for="criteria">By: </label><select name="Criteria" id="criteria">
143	<option value ="" selected="selected">None</option>
144	<option value ="homebranch">Library</option>
145	<option value ="itype">Item type</option>
146	</select></li>
147	</ol>
148	</fieldset>
149		120
150	<fieldset class="action">	121	<h1>Items with no checkouts</h1>
151	<input type="submit" class="btn btn-primary" value="Submit" />	122
152	<input type="hidden" name="report_name" value="[% report_name \| html %]" />	123	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
153	<input type="hidden" name="do_it" value="1" />	124	<fieldset class="rows">
154	<input type="hidden" name="output" value="screen" />	125	<ol>
155	</fieldset>	126	<li>
156	</form>	127	<label for="branch">Library: </label>
157	[% END %]	128	<select name="Filter" id="branch">
		129	<option value="">Any library</option>
		130	[% PROCESS options_for_libraries libraries => Branches.all() %]
		131	</select>
		132	</li>
		133	<li>
		134	<label for="documenttype">Item type: </label>
		135	<select name="Filter" id="documenttype">
		136	<option value="">Any item type</option>
		137	[% FOREACH itemtype IN itemtypes %]
		138	<option value="[% itemtype.itemtype \| html %]">[% itemtype.translated_description \| html %]</option>
		139	[% END %]
		140	</select>
		141	</li>
		142	</ol>
		143	</fieldset>
		144
		145	<fieldset class="rows">
		146	<legend>Limits</legend>
		147	<ol>
		148	<li>
		149	<label for="numberlimit">Limit to: </label>
		150	<select name="Limit" id="numberlimit">
		151	<option value ="10">10</option>
		152	<option value ="20">20</option>
		153	<option value ="50">50</option>
		154	<option value ="100">100</option>
		155	<option value ="200">200</option>
		156	<option value ="300">300</option>
		157	<option value ="400">400</option>
		158	<option value ="500">500</option>
		159	<option value ="1000">1000</option>
		160	</select>
		161	</li>
		162	<li>
		163	<label for="criteria">By: </label>
		164	<select name="Criteria" id="criteria">
		165	<option value ="" selected="selected">None</option>
		166	<option value ="homebranch">Library</option>
		167	<option value ="itype">Item type</option>
		168	</select>
		169	</li>
		170	</ol>
		171	</fieldset>
		172
		173	<fieldset class="action">
		174	<input type="submit" class="btn btn-primary" value="Submit" />
		175	<input type="hidden" name="report_name" value="[% report_name \| html %]" />
		176	<input type="hidden" name="do_it" value="1" />
		177	<input type="hidden" name="output" value="screen" />
		178	</fieldset>
		179	</form>
		180	[% END %]
158		181
159	</main>	182	</main>
160	</div> <!-- /.col-sm-10.col-sm-push-2 -->	183	</div> <!-- /.col-sm-10.col-sm-push-2 -->
161
162	<div class="col-sm-2 col-sm-pull-10">	184	<div class="col-sm-2 col-sm-pull-10">
163	<aside>	185	<aside>
164	[% INCLUDE 'reports-menu.inc' %]	186	[% INCLUDE 'reports-menu.inc' %]
165	</aside>	187	</aside>
166	</div> <!-- /.col-sm-2.col-sm-pull-10 -->	188	</div> <!-- /.col-sm-2.col-sm-pull-10 -->
167	</div> <!-- /.row -->	189	</div> <!-- /.row -->
168		190
169	[% INCLUDE 'intranet-bottom.inc' %]	191	[% INCLUDE 'intranet-bottom.inc' %]
170	-