Attachment #76355 for bug #20988

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




[% PROCESS 'i18n.inc' %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Acquisitions statistics › Results') %][% ELSE %][% t('› Acquisitions statistics') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/acquisitions_stats.pl">[% t('Acquisitions statistics') %]</a> [% t('› Results') %][% ELSE %] [% t('› Acquisitions statistics') %] [% END %]</div>

<div id="doc3" class="yui-t2">



[% IF ( do_it ) %]
	[% FOREACH mainloo IN mainloop %]
		<h1>[% t('Acquisitions statistics') %] </h1>
        [% IF ( mainloo.loopfilter.size ) %]
            <p><b>[% t('Filtered on:') %]</b></p>
            [% FOREACH loopfilte IN mainloo.loopfilter %]
                <p>
                    [% SWITCH loopfilte.crit %]
                        [% CASE '0' %] [% t('Placed on (from)') %]
                        [% CASE '1' %] [% t('Placed on (to)') %]
                        [% CASE '2' %] [% t('Received on (from)') %]
                        [% CASE '3' %] [% t('Received on (to)') %]
                        [% CASE '4' %] [% t('Vendor') %]
                        [% CASE '5' %] [% t('Home library') %]
                        [% CASE '6' %] [% t('Collection') %]
                        [% CASE '7' %] [% t('Item type') %]
                        [% CASE '8' %] [% t('Fund') %]
                        [% CASE '9' %] [% t('Sort1') %]
                        [% CASE '10' %] [% t('Sort2') %]
                        [% CASE %] [% t('Unknown filter') %]
                    [% END %]
                    : [% loopfilte.filter %]
                </p>

		[% END %]

		<table>
			<tr>
				<th>[% mainloo.line %] / [% mainloo.column %]</th>
				[% FOREACH loopco IN mainloo.loopcol %]
					<th>[% loopco.coltitle %]</th>
				[% END %]
				<th>[% t('TOTAL') %]</th>
			</tr>
				[% FOREACH loopro IN mainloo.looprow %]
					<tr>

						[% FOREACH loopcel IN loopro.loopcell %]
							[% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
								[% IF ( loopcel.value ) %][% loopcel.value %]
								[% ELSE %]  
								[% END %]
							</td>
						[% END %]

						</td>
					</tr>
				[% END %]
				<tr>
					<th>[% t('TOTAL') %]</th>
					[% FOREACH loopfoote IN mainloo.loopfooter %]
						<th>
							[% loopfoote.totalcol %]

[% ELSE %]
	<form method="post" action="/cgi-bin/koha/reports/acquisitions_stats.pl">
	<fieldset class="rows">
	<legend>[% t('Acquisitions statistics') %]</legend>
	<table>
		<thead>
			<tr>
			<th>[% t('Title') %]</th>
			<th>[% t('Row') %]</th>
			<th>[% t('Column') %]</th>
			<th>[% t('Filter') %]</th>
			</tr>
		</thead>
		<tbody>
			<tr class="hilighted">
                <td>[% t('Placed on') %]</td>
				<td><input type="radio" name="Line" value="aqbasket.closedate" /></td>
				<td><input type="radio" checked="checked" name="Column" value="aqbasket.closedate" /> </td>
				<td> [% t('From') %] <input type="text" size="10" id="from" name="Filter" value="" />
				<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
					[% t('To') %] <input size="10" id="to" name="Filter" type="text" value="" />
				<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
				</td>
			</tr>
			<tr class="hilighted">
				<td> </td>
				<td colspan="2">[% t('group by') %] <select name="PlacedOnDisplay">
					<option value="">[% t('None') %]</option>
					<option value="1">[% t('Day of week') %]</option>
					<option value="2">[% t('Month') %]</option>
					<option value="3">[% t('Year') %]</option>
					</select>

				</td>
				<td> </td>
			</tr>
			<tr>
                <td>[% t('Received on') %]</td>
				<td><input type="radio" name="Line" value="aqorders.datereceived" /></td>
				<td><input type="radio" name="Column" value="aqorders.datereceived" /></td>
				<td> [% t('From') %] <input type="text" size="10" id="fromRO" name="Filter" value="" />
				<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
					[% t('To') %] <input type="text" size="10" id="toRO" name="Filter" value="" />
				<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
				</td>
			</tr>
			<tr>
				<td> </td>
				<td colspan="2">[% t('group by') %] <select name="ReceivedOnDisplay">
					<option value="">[% t('None') %]</option>
					<option value="1">[% t('Day of week') %]</option>
					<option value="2">[% t('Month') %]</option>
					<option value="3">[% t('Year') %]</option>
					</select>

				</td>
				<td> </td>
			</tr>
			<tr class="hilighted">
				<td>[% t('Vendor') %]</td>
				<td><input type="radio" checked="checked" name="Line" value="aqbooksellers.name" /></td>
				<td><input type="radio" name="Column" value="aqbooksellers.name" /></td>
                <td>
                    <select name="Filter">
                        <option value="">[% t('All vendors') %]</option>
                        [% FOREACH bookseller IN booksellers %]
                            <option value="[% bookseller.name %]">[% bookseller.name %]</option>
                        [% END %]

                </td>
            </tr>
            <tr>
                <td>[% t('Home library') %]</td>
                <td><input type="radio" name="Line" value="items.homebranch" /></td>
                <td><input type="radio" name="Column" value="items.homebranch" /></td>
                <td>
                    <select name="Filter">
                        <option value="" selected="selected">[% t('All libraries') %]</option>
                        [% FOREACH branch IN branches %]
                            <option value="[% branch.branchcode %]">[% branch.branchname %]</option>
                        [% END %]

                    [% IF ccode_label %]
                        [% ccode_label %]
                    [% ELSE %]
                        [% t('Collection') %]
                    [% END %]
                </td>
                <td><input type="radio" name="Line" value="items.ccode" /></td>

                <td>
                    [% IF ccode_avlist.size %]
                        <select name="Filter">
                            <option value="" selected="selected">[% t('All') %]</option>
                            [% FOREACH ccode_av IN ccode_avlist %]
                                <option value="[% ccode_av.value %]">[% ccode_av.lib %]</option>
                            [% END %]

                </td>
            </tr>
			<tr>
                <td>[% t('Item type') %]</td>
				<td><input type="radio" name="Line" value="biblioitems.itemtype" /></td>
				<td><input type="radio" name="Column" value="biblioitems.itemtype" /></td>
                <td>
                    <select name="Filter" size="1" id="itemtypes">
                        <option value="">[% t('All item types') %]</option>
                        [% FOREACH itemtype IN itemtypes %]
                        <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>
                        [% END %]

			</tr>

			<tr>
				<td>[% t('Fund') %]</td>
				<td><input type="radio" name="Line" value="aqbudgets.budget_code" /></td>
				<td><input type="radio" name="Column" value="aqbudgets.budget_code" /></td>
                <td>
                    <select name="Filter" size="1" id="budget">
                        <option value="">[% t('All funds') %]</option>
                        [% FOREACH value IN Budgets.values %]
                        <option value="[% value %]">[% Budgets.labels.$value %]</option>
                        [% END %]


			[% IF ( hassort1 ) %]
				<tr class="hilighted">
					<td>[% t('Sort1') %]</td>
					<td><input type="radio" name="Line" value="aqorders.sort1" /></td>
					<td><input type="radio" name="Column" value="aqorders.sort1" /></td>
                    <td>
                        <select name="Filter" size="1" id="sort1">
                            <option value="">[% t('All') %]</option>
                            [% FOREACH value IN Sort1.values %]
                            <option value="[% value %]">[% Sort1.labels.$value %]</option>
                            [% END %]

			[% END %]
			[% IF ( hassort2 ) %]
				[% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %]
					<td>[% t('Sort2') %]</td>
					<td><input type="radio" name="Line" value="aqorders.sort2" /></td>
					<td><input type="radio" name="Column" value="aqorders.sort2" /></td>
                    <td>
                        <select name="Filter" size="1" id="sort2">
                            <option value="">[% t('All') %]</option>
                            [% FOREACH value IN Sort2.values %]
                            <option value="[% value %]">[% Sort2.labels.$value %]</option>
                            [% END %]

	</fieldset>

<fieldset class="rows">
    <legend> [% t('Cell value') %] </legend>
    <ol>
        <li>
            <label for="cellvalue1">[% t('Count items:') %]</label><input type="radio" name="Cellvalue" id="cellvalue1" value="1" checked="checked" />
        </li>
        <li>
            <label for="cellvalue2">[% t('Count unique biblios:') %]</label><input type="radio" name="Cellvalue" id="cellvalue2" value="2" />
        </li>
        <li>
            <label for="cellvalue3">[% t('Amount:') %]</label><input type="radio" name="Cellvalue" id="cellvalue3" value="3" />
        </li>
        <li>
            <label for="cellvalue4">[% t('Ordered amount:') %]</label><input type="radio" name="Cellvalue" id="cellvalue4" value="4" />
        </li>
        <li>
            <label for="cellvalue5">[% t('Spent amount:') %]</label><input type="radio" name="Cellvalue" id="cellvalue5" value="5" />
        </li>
    </ol>
</fieldset>

	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label> <input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
                <option value="CSV">[% t('CSV') %]</option>
            </select>
            <select name="sep" id="sep" size="1">
            [% FOREACH value IN CGIsepChoice.values.sort() %]




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% USE KohaDates %]
[% USE ItemTypes %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Patrons with the most checkouts') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/bor_issues_top.pl">[% t('Patrons with the most checkouts') %]</a> [% t('› Results') %][% ELSE %][% t('› Patrons with the most checkouts') %][% END %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
	[% FOREACH mainloo IN mainloop %]
        <h1>[% t('Patrons with the most checkouts') %]</h1>
		[% IF ( mainloo.loopfilter ) %]
            [% IF mainloo.loopfilter.size %]
                <p>[% t('Filtered on:') %]</p>
                <ul>
                    [% FOREACH loopfilte IN mainloo.loopfilter %]
                        <li>
                            [% SWITCH loopfilte.crit -%]
                                [% CASE "Issue From" -%]
                                    [% t('Checked out after') %] [% loopfilte.filter | $KohaDates %]
                                [% CASE "Issue To" -%]
                                    [% t('Checked out before') %] [% loopfilte.filter | $KohaDates %]
                                [% CASE "Return From" -%]
                                    [% t('Checked in after') %] [% loopfilte.filter | $KohaDates %]
                                [% CASE "Return To" -%]
                                    [% t('Checked in before') %] [% loopfilte.filter | $KohaDates %]
                                [% CASE "Branch" -%]
                                    [% t('Library is') %] [% Branches.GetName( loopfilte.filter ) %]
                                [% CASE "Doc Type" -%]
                                    [% t('Item type is') %] [% ItemTypes.GetDescription( loopfilte.filter ) %]
                                [% CASE "Bor Cat" -%]
                                    [% t('Patron category code is') %] [% loopfilte.filter %]
                                [% CASE "Day" -%]
                                    [% t('Day is') %] [% loopfilte.filter %]
                                [% CASE "Month" -%]
                                    [% t('Month is') %] [% loopfilte.filter %]
                                [% CASE "Year" -%]
                                    [% t('Year is') %] [% loopfilte.filter %]
                                [% CASE # default case -%]
                                    [% loopfilte.crit %] = [% loopfilte.filter %]
                            [% END -%]

		
		<table>
			<tr>
				<th rowspan="2">[% t('Rank') %]</th>
				[% FOREACH loopco IN mainloo.loopcol %]
					<th colspan="2">[% loopco.coltitle %]</th>
				[% END %]
			</tr>
			<tr>
				[% FOREACH loopco IN mainloo.loopcol %]
					<th>[% t('Patron') %]</th>
					<th>[% t('Checkout count') %]</th>
				[% END %]
			</tr>
				[% FOREACH loopro IN mainloo.looprow %]

		</table>
	[% END %]
[% ELSE %]
    <h1>[% t('Patrons with the most checkouts') %]</h1>
	<form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">
	<fieldset class="rows">
	<ol><li><label for="from">[% t('Checkout date from:') %]</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
					<label class="inline" for="to">[% t('To:') %] </label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
				<li> <label for="fromRO">[% t('Check-in date from:') %]</label> <input type="text" readonly="readonly" size="10" id="fromRO" name="Filter" />
					<label class="inline" for="toRO">[% t('To:') %] </label> <input type="text" readonly="readonly" size="10" id="toRO" name="Filter" value="" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
			<li> 
				<label for="branch">[% t('Library:') %] </label>
<select name="Filter" id="branch"><option value=""> [% t('Any library') %]</option>
    [% FOREACH l IN Branches.all( unfiltered => 1 ) %]
        <option value="[% l.branchcode %]">[% l.branchname %] </option>
     [% END %] 
    </select>			</li>
			<li> 
                <label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype"><option value=""> [% t('Any item type') %]</option>
    [% FOREACH itemtype IN itemtypes %]
        <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %] </option>
     [% END %] 
    </select>
			</li>
			<li> 
                <label for="patroncategory">[% t('Patron category:') %] </label><select name="Filter" id="patroncategory"><option value=""> [% t('Any category code') %]</option>
    [% FOREACH patron_category IN patron_categories%]
        <option value="[% patron_category.categorycode %]">[% patron_category.description %] </option>
     [% END %]
    </select>
			</li>

	
	<fieldset class="rows">
	<ol>
		<li><label for="numlimit">[% t('Limit to:') %] </label> <select name="Limit" id="numlimit">
						<option value="5" selected="selected"> [% t('5') %]</option>
						<option value="10">[% t('10') %]</option>
						<option value="15">[% t('15') %]</option>
						<option value="20">[% t('20') %]</option>
                        <option value="">[% t('No limit') %]</option>
	<!--					<option value ="25">25</option>
						<option value ="40">40</option>
						<option value ="50">50</option>
						<option value ="100">100</option>-->
					</select></li>
		<li><label for="criteria">[% t('By:') %] </label> <select name="Criteria" id="criteria">
						<option value="" selected="selected">[% t('None') %]</option>
						<option value="branchcode">[% t('Library') %]</option>
                        <option value="categorycode">[% t('Category code') %]</option>
                        <option value="itemtype">[% t('Item type') %]</option>
						<option value="Day">[% t('Day') %]</option>
						<option value="Week">[% t('Week') %]</option>
						<option value="Month">[% t('Month') %]</option>
						<option value="Year">[% t('Year') %]</option>
					</select></li>
	</ol>
	</fieldset>

<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
	<ol><li><label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
		<li><label for="outputfile">[% t('To a file:') %] </label><input type="radio" name="output" value="file" id="outputfile" />
			<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
			<label class="inline" for="MIME">[% t('Into an application:') %] </label>
			<select name="MIME" id="MIME">
			[% FOREACH mimeloo IN mimeloop %]
				<option value="[% mimeloo.type %]">[% mimeloo.type %]</option>
			[% END %]
			</select>
			<label class="inline" for="sep">[% t('Delimiter:') %] </label>
            <select name="sep" id="sep" size="1">
            [% FOREACH value IN CGIseplist.values.sort() %]
              [% IF ( value == CGIseplist.default ) %]




[% PROCESS 'i18n.inc' %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Patrons with no checkouts') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% t('› Patrons with no checkouts') %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
    [% FOREACH mainloo IN mainloop %]
        <h1>[% t('Patrons with no checkouts') %]</h1>
        [% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
            [% FOREACH loopfilte IN mainloo.loopfilter %]
                    <p>[% IF ( loopfilte.err ) %]  [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %]  [% END %]</p>
            [% END %]

        
        <table>
            <tr>
                <th>[% t('Num/Patrons') %]</th>
                [% FOREACH loopco IN mainloo.loopcol %]
                    <th>[% loopco.coltitle %]</th>
                [% END %]

        </table>
    [% END %]
[% ELSE %]
    <h1>[% t('Patrons with no checkouts') %]</h1>
    <form method="post" action="/cgi-bin/koha/reports/borrowers_out.pl">
    <fieldset class="rows">
		<ol>
            <li><label for="patroncategory">[% t('Patron category:') %] </label> <select name="Filter" id="patroncategory"><option value=""> [% t('Any category code') %]</option>
    [% FOREACH patron_category IN patron_categories %]
        <option value="[% patron_category.categorycode %]">[% patron_category.description %] </option>
    [% END %]
    </select>
</li>
    <li><label for="to">[% t('Not checked out since:') %] </label> <input size="10" id="to" name="Filter" value="" type="text" />
</li>
		</ol>
	</fieldset>
	
    <fieldset class="rows">
	<legend>[% t('Limits') %]</legend>
		<ol>
			<li><label for="numberlimit">[% t('Limit to:') %] </label><select name="Limit" id="numberlimit">
                        <option value="" selected="selected">[% t('None') %]</option>
                        <option value="5"> [% t('5') %]</option>
                        <option value="10">[% t('10') %]</option>
                        <option value="15">[% t('15') %]</option>
                        <option value="20">[% t('20') %]</option>
                        <option value="25">[% t('25') %]</option>
                        <option value="40">[% t('40') %]</option>
                        <option value="50">[% t('50') %]</option>
                        <option value="100">[% t('100') %]</option>
                    </select></li>
			<li><label for="criteria">[% t('By:') %] </label><select name="Criteria" id="criteria">
                        <option value="" selected="selected">[% t('None') %]</option>
                        <option value="categorycode">[% t('Patron category') %]</option>
                        <option value="branchcode">[% t('Library') %]</option>
                    </select></li>
		</ol>
	</fieldset>
	
<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Patrons statistics › Results') %][% ELSE %][% t('› Patrons statistics') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">
	.sql {display:none;}

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> › <a href="/cgi-bin/koha/reports/borrowers_stats.pl">[% t('Patrons statistics') %]</a>[% IF ( do_it ) %] [% t('› Results') %][% END %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
	[% FOREACH mainloo IN mainloop %]
		<h1>[% t('Patrons statistics') %]</h1>
		[% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
			[% FOREACH loopfilte IN mainloo.loopfilter %]
				<p>
					[% loopfilte.crit %] = [% loopfilte.filter %]

					<th>[% IF ( loopco.coltitle_display ) %][% loopco.coltitle_display %][% ELSE %][% loopco.coltitle %][% END %]
					</th>
				[% END %]
				<th>[% t('TOTAL') %]</th>
			</tr>
				[% FOREACH loopro IN mainloo.looprow %]
                    <tr>
						<td>[% IF ( loopro.rowtitle_display ) %][% loopro.rowtitle_display %][% ELSE %][% loopro.rowtitle %][% END %]
						</td>
						[% FOREACH loopcel IN loopro.loopcell %]
						<td>[% IF ( loopcel.value ) %][% loopcel.value %][% ELSE %] [% END %]
						</td>
						[% END %]
						<td>[% loopro.totalrow %]</td>
					</tr>
				[% END %]
				<tr>
					<th>[% t('TOTAL') %]</th>
					[% FOREACH loopfoote IN mainloo.loopfooter %]
						<th>[% loopfoote.totalcol %]</th>
					[% END %]

[% ELSE %]

	<form method="post" action="/cgi-bin/koha/reports/borrowers_stats.pl">
	<fieldset class="rows"><legend>[% t('Patrons statistics') %]</legend>
	<table>
		<thead>
			<tr>
			<th>[% t('Title') %]</th>
			<th>[% t('Row') %]</th>
			<th>[% t('Column') %]</th>
			<th>[% t('Filter') %]</th>
			</tr>
		</thead>
		<tbody>
            <tr>
			<td>[% t('Patron category') %]</td>
			<td><input type="radio" name="Line" value="categorycode" /></td>
			<td><input type="radio" name="Column" value="categorycode" /></td>
            <td>
                <select name="Filter" size="1" id="catcode">
                    <option value=""></option>
                    [% FOREACH patron_category IN patron_categories %]
                        <option value="[% patron_category.categorycode %]">[% patron_category.description %]</option>

            </td>
			</tr>
			<tr>
			<td>[% t('Patron status') %]</td>
			<td colspan="2"></td>
			<td><select name="status"><option value=""> </option><option value="debarred">[% t('restricted') %]</option><option value="gonenoadress">[% t('gone no address') %]</option><option value="lost">[% t('lost') %]</option></select></td>
			</tr>
            <tr>
			<td>[% t('Patron activity') %]</td>
			<td colspan="2"><select name="period" id="period">
			<option value="1">[% t('1') %]</option>
			<option value="2">[% t('2') %]</option>
			<option value="3">[% t('3') %]</option>
			</select>
			<label for="period">[% t('years of activity') %]</label> 
			</td>
			<td><select name="activity"><option value=""> </option><option value="active">[% t('active') %]</option><option value="nonactive">[% t('no active') %]</option></select></td>
			</tr>

			<tr>
            <td rowspan="2">[% t('ZIP/Postal code') %]</td>
			<td><input type="radio" name="Line" value="zipcode" /></td>
			<td><input type="radio" name="Column" value="zipcode" /></td>
			<td><select name="Filter" size="1" id="zipcode">
				<option value=""> </option>
				[% FOREACH ZIP_LOO IN ZIP_LOOP %]
				<option value="[% ZIP_LOO.zipcode %]">[% ZIP_LOO.zipcode %]</option>

			<tr>
			<td colspan="2"><select name="digits" id="digits">
			<option value=""> </option>
			<option value="1">[% t('1') %]</option>
			<option value="2">[% t('2') %]</option>
			<option value="3">[% t('3') %]</option>
			<option value="4">[% t('4') %]</option>
			<option value="5">[% t('5') %]</option>
			<option value="6">[% t('6') %]</option>
			<option value="7">[% t('7') %]</option>
			<option value="8">[% t('8') %]</option>
			<option value="9">[% t('9') %]</option>
			<option value="10">[% t('10') %]</option>
			</select>
			<label for="digits">[% t('digits') %]</label> 
			</td>
			<td> </td>
			</tr>

            <tr>
			<td>[% t('Library') %]</td>
			<td><input type="radio" name="Line" value="branchcode" /></td>
			<td><input type="radio" name="Column" value="branchcode" /></td>
			<td>
                <select name="Filter" size="1" id="branch">
                <option value=""></option>
                [% FOREACH l IN Branches.all( unfiltered => 1 ) %]
                    <option value="[% l.branchcode %]">[% l.branchcode %] - [% l.branchname || 'UNKNOWN' %]</option>

			</td>
			</tr>
		    <tr>
            <td>[% t('Date of birth') %]</td>
            <td colspan="2"></td>
                <td><label for="from">[% t('From') %]</label> <input type="text" size="10" id="from" name="Filter" class="datepickerfrom" />
                    <label for="to">[% t('To') %]</label> <input size="10" id="to" name="Filter" value="" type="text" class="datepickerto" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
                    </td>
                </tr>
            <tr>
                <td>[% t('Gender') %]</td>
                <td><input type="radio" name="Line" value="sex" /></td>
                <td><input type="radio" name="Column" value="sex" /></td>
                <td>
                    <select id="sex" size="1" name="Filter">
                        <option value="" />
                        <option value="M">[% t('Men') %]</option>
                        <option value="F">[% t('Women') %]</option>
                    </select>
                </td>
            </tr>
			[% IF ( SORT1_LOOP ) %]
                <tr>
				<td>[% t('Sort1') %]</td>
				<td><input type="radio" name="Line" value="sort1" /></td>
				<td><input type="radio" name="Column" value="sort1" /></td>
				<td>
					<select id="sort1" size="1" name="Filter">
					<option value="" />
					[% FOREACH SORT1_LOO IN SORT1_LOOP %]
						<option value="[% SORT1_LOO.authorized_value %]">[% SORT1_LOO.lib %]</option>
					[% END %]

			[% END %]
			[% IF ( SORT2_LOOP ) %]
                <tr>
				<td>[% t('Sort2') %]</td>
				<td><input type="radio" name="Line" value="sort2" /></td>
				<td><input type="radio" name="Column" value="sort2" /></td>
				<td>
					<select id="sort2" size="1" name="Filter">
					<option value="" />
					[% FOREACH SORT2_LOO IN SORT2_LOOP %]
						<option value="[% SORT2_LOO.value %]">[% SORT2_LOO.value %]</option>
					[% END %]

			[% END %]
            [% IF ( ExtendedPatronAttributes ) %]
                <tr>
                    <th colspan="4">[% t('Patron attributes') %]</th>
                </tr>
            [% FOREACH pa_loo IN patron_attributes %]
                [% IF (pa_loo.class) %]

                        ([% patron_attribute.description %])
                    </td>
                    <td>
                        <input type="radio" name="Line" value="patron_attr.[% patron_attribute.code %]" />
                            value="patron_attr.[% patron_attribute.code %]" />
                    </td>
                    <td>
                        <input type="radio" name="Column" value="patron_attr.[% patron_attribute.code %]" />
                            value="patron_attr.[% patron_attribute.code %]" />
                    </td>
                    <td>
                        [% IF ( patron_attribute.use_dropdown ) %]
                            <select name="Filter_patron_attr.[% patron_attribute.code %]">
                                <option value="" />
                                [% FOREACH auth_val_loo IN patron_attribute.auth_val_loop %]
                                    <option value="[% auth_val_loo.authorised_value %]">
                                        [% auth_val_loo.lib %]
                                    </option>
                                [% END %]
                            </select>
                        [% ELSE %]
                            <input type="text" maxlength="64" name="Filter_patron_attr.[% patron_attribute.code %]" />
                                   name="Filter_patron_attr.[% patron_attribute.code %]" />
                        [% END %]
                    </td>
                </tr>


	
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE KohaDates %]
[% USE Price %]
[% USE ItemTypes %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Cash register statistics › Results') %][% ELSE %][% t('› Cash register statistics') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
[% Asset.css("css/datatables.css") %]
</head>

[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs">
    <a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>
    ›
    [% IF ( do_it ) %]
        <a href="/cgi-bin/koha/reports/cash_register_stats.pl">[% t('Cash register statistics') %]</a> [% t('› Results') %]
    [% ELSE %]
        [% t('Cash register statistics') %]
    [% END %]
</div>


    <div id="yui-main">
    <div class="yui-b">

    <h1>[% t('Cash register statistics') %]</h1>
    <form method="post" action="/cgi-bin/koha/reports/cash_register_stats.pl" id="frmCashRegister">
        <fieldset class="rows">
            <legend>[% t('Cash register statistics') %] [% beginDate | $KohaDates %] [% t('to') %] [% endDate | $KohaDates %]</legend>
            <ol>
                <br>
                <li>
                    <label for="from">[% t('From:') %] </label>
                    <input type="text" size="10" id="from" name="from" value="[% beginDate | $KohaDates %]" class="datepickerfrom" />
                    <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
                </li>
                <li>
                    <label for="to">[% t('To:') %] </label>
                    <input type="text" size="10" id="to" name="to" value="[% endDate | $KohaDates %]" class="datepickerto" />
                    <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
                </li>

                <li>
                    <label for="">[% t('Transaction type:') %]</label>
                    <select name="transaction_type" id="transaction_type">
                        [% IF transaction_type == "ALL" %]
                        <option value="ALL" selected="selected">[% t('All transactions') %]</option>
                        [% ELSE %]
                        <option value="ALL">[% t('All transactions') %]</option>
                        [% END %]

                        [% IF transaction_type == "ACT" %]
                        <option value="ACT" selected="selected">[% t('All payments to the library') %]</option>
                        [% ELSE %]
                        <option value="ACT">[% t('All payments to the library') %]</option>
                        [% END %]

                        [% IF transaction_type == "C" %]
                        <option value="C" selected="selected">[% t('Credit') %]</option>
                        [% ELSE %]
                        <option value="C">[% t('Credit') %]</option>
                        [% END %]

                        [% IF transaction_type == "CR" %]
                        <option value="CR" selected="selected">[% t('Credit (item returned)') %]</option>
                        [% ELSE %]
                        <option value="CR">[% t('Credit (item returned)') %]</option>
                        [% END %]

                        [% IF transaction_type == "FORW" %]
                        <option value="FORW" selected="selected">[% t('Write off') %]</option>
                        [% ELSE %]
                        <option value="FORW">[% t('Write off') %]</option>
                        [% END %]

                        [% IF transaction_type == "F" %]
                        <option value="F" selected="selected">[% t('Fine') %]</option>
                        [% ELSE %]
                        <option value="F">[% t('Fine') %]</option>
                        [% END %]

                        [% IF transaction_type == "FU" %]
                        <option value="FU" selected="selected">[% t('Accruing fine') %]</option>
                        [% ELSE %]
                        <option value="FU">[% t('Accruing fine') %]</option>
                        [% END %]

                        [% IF transaction_type == "PAY" %]
                        <option value="PAY" selected="selected">[% t('Payment') %]</option>
                        [% ELSE %]
                        <option value="PAY">[% t('Payment') %]</option>
                        [% END %]

                        [% IF transaction_type == "A" %]
                        <option value="A" selected="selected">[% t('Account management fee') %]</option>
                        [% ELSE %]
                        <option value="A">[% t('Account management fee') %]</option>
                        [% END %]

                        [% IF transaction_type == "M" %]
                        <option value="M" selected="selected">[% t('Sundry') %]</option>
                        [% ELSE %]
                        <option value="M">[% t('Sundry') %]</option>
                        [% END %]

                        [% IF transaction_type == "L" %]
                        <option value="L" selected="selected">[% t('Lost item') %]</option>
                        [% ELSE %]
                        <option value="L">[% t('Lost item') %]</option>
                        [% END %]

                        [% IF transaction_type == "N" %]
                        <option value="N" selected="selected">[% t('New card') %]</option>
                        [% ELSE %]
                        <option value="N">[% t('New card') %]</option>
                        [% END %]

                        [% FOREACH manualinv IN manualinv_types %]

                    </select>
                </li>
                <li>
                    <label>[% t('Transaction branch') %]</label>
                    <select name="branch" id="branch">
                        <option value="ALL">[% t('All') %]</option>
                        [% FOREACH branchloo IN branchloop %]
                            [% IF ( branchloo.selected ) %]
                            <option value="[% branchloo.branchcode %]" selected="selected">[% branchloo.branchname %]</option>

        </fieldset>

        <fieldset class="rows">
            <legend>[% t('Output') %]</legend>
            <ol>
                <li>
                    <label for="outputscreen">[% t('To screen into the browser:') %] </label>
                    <input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
                </li>
                <li>
                    <label for="outputfile">[% t('To a file:') %]</label>
                    <input type="radio" name="output" value="file" id="outputfile" />
                    <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />

                </li>
            </ol>

    </form>

    [% IF ( do_it ) %]
    <div> </div>
    <table id="tbl_cash_register_stats">
        <thead>
        <tr>
            <th>[% t('Manager name') %]</th>
            <th>[% t('Patron card number') %]</th>
            <th>[% t('Patron name') %]</th>
            <th>[% t('Transaction branch') %]</th>
            <th>[% t('Transaction date') %]</th>
            <th>[% t('Transaction type') %]</th>
            <th>[% t('Notes') %]</th>
            <th>[% t('Amount') %]</th>
            <th>[% t('Biblio title') %]</th>
            <th>[% t('Barcode') %]</th>
            <th>[% t('Item type') %]</th>
        </tr>
        </thead>
        [% FOREACH loopresul IN loopresult %]

                <td>[% loopresul.date | $KohaDates %]</td>
                <td>
                    [% IF loopresul.accounttype == "ACT" %]
                        <span>[% t('All payments to the library') %]</span>
                    [% ELSIF loopresul.accounttype == "C" || loopresul.accounttype == "CR" %]
                        <span>[% t('Credit') %]</span>
                    [% ELSIF loopresul.accounttype == "FORW" || loopresul.accounttype == "W" %]
                        <span>[% t('Write off') %]</span>
                    [% ELSIF loopresul.accounttype == "F" %]
                        <span>[% t('Fine') %]</span>
                    [% ELSIF loopresul.accounttype == "FU" %]
                        <span>[% t('Accruing fine') %]</span>
                    [% ELSIF loopresul.accounttype == "Pay" %]
                        <span>[% t('Payment') %]</span>
                    [% ELSIF loopresul.accounttype == "A" %]
                        <span>[% t('Account management fee') %]</span>
                    [% ELSIF loopresul.accounttype == "M" %]
                        <span>[% t('Sundry') %]</span>
                    [% ELSIF loopresul.accounttype == "L" || loopresul.accounttype == "LR" %]
                        <span>[% t('Lost item') %]</span>
                    [% ELSIF loopresul.accounttype == "N" %]
                        <span>[% t('New card') %]</span>
                    [% ELSE %]
                        [% FOREACH manualinv IN manualinv_types %]
                            [% value_manualinv = manualinv.authorised_value|truncate(5, '') %]

        <tfoot>
        <tr>
            [% IF transaction_type == "ACT" %]
            <th colspan="7" style="text-align:right;">[% t('TOTAL') %]</th>
            <th style="text-align:right;">[% total  | $Price %]</th>
            <th colspan="3"> </th>
            [% END %]
        </tr>
        </tfoot>




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Most-circulated items') %][% IF ( do_it ) %] [% t('› Results') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> › [% IF ( do_it ) %]<a href="/cgi-bin/koha/reports/cat_issues_top.pl">[% t('Most-circulated items') %]</a> [% t('› Results') %][% ELSE %][% t('Most-Circulated Items') %][% END %]</div>

<div id="doc3" class="yui-t2">
   

[% IF ( do_it ) %]

	[% FOREACH mainloo IN mainloop %]
        <h1>[% t('Top') %] [% mainloo.limit %] [% t('Most-circulated items') %]</h1>
		[% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
			[% FOREACH loopfilte IN mainloo.loopfilter %]
                    <p>[% IF ( loopfilte.err ) %]  [% END %] [% loopfilte.crit %] =[% loopfilte.filter |html %][% IF ( loopfilte.err ) %]  [% END %]</p>
			[% END %]
		[% END %]
		
		<table>
<tr>				<th>[% t('Rank/Biblioitemnumbers') %]</th>
				[% FOREACH loopco IN mainloo.loopcol %]
					<th colspan="2">[% loopco.coltitle %]</th>
				[% END %]</tr>
        <tr>
				<th> </th>
				[% FOREACH loopco IN mainloo.loopcol %]
					<th>[% t('Item') %]</th>
                    <th>[% t('Count of checkouts') %]</th>
				[% END %]
			  </tr>
				[% FOREACH loopro IN mainloo.looprow %]

		</table>
	[% END %]
[% ELSE %]
    <h1>[% t('Most-circulated items') %]</h1>
	<form method="post" action="/cgi-bin/koha/reports/cat_issues_top.pl">
	<fieldset class="rows">
	<ol>
        <li><label for="from">[% t('Checkout date from:') %] </label> <input type="text" size="10" id="from" name="Filter" />
        <label for="to" class="inline">[% t('To:') %]</label> <input size="10" id="to" name="Filter" value="" type="text" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
        <li><label for="fromRO">[% t('Check-in date from') %]</label> <input type="text" size="10" id="fromRO" name="Filter" />
        <label for="toRO" class="inline">[% t('To:') %] </label> <input type="text" size="10" id="toRO" name="Filter" value="" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
        <li>
            <label for="branch">[% t('Library:') %] </label>
            <select name="Filter" id="branch"><option value=""> [% t('Any library') %]</option>
                [% PROCESS options_for_libraries libraries => Branches.all() %]
            </select>
        </li>
      <li> 
        <label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype"><option value=""> [% t('Any item type') %]</option>
    [% FOREACH itemtype IN itemtypes %]
        <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %] </option>
     [% END %] 
    </select>
      </li>
      <li> 
        <label for="itemcallnumber">[% t('Call number:') %] </label><input type="text" name="Filter" id="itemcallnumber" value="" />
      </li>
      <li>
        <label for="ccode">[% t('Collection:') %] </label><select name="Filter" id="ccode"><option value=""> [% t('Any collection') %]</option>
    [% FOREACH ccodeloo IN ccodeloop %]
        <option value="[% ccodeloo.value %]">[% ccodeloo.description %] </option>
     [% END %]
    </select>
      </li>
      <li>
        <label for="shelvingloc">[% t('Shelving location:') %] </label><select name="Filter" id="shelvingloc"><option value=""> [% t('Any shelving location') %]</option>
    [% FOREACH shelvinglocloo IN shelvinglocloop %]
        <option value="[% shelvinglocloo.value %]">[% shelvinglocloo.description %] </option>
     [% END %]
    </select>
      </li>
      <li>
        <label for="patroncategory">[% t('Patron category:') %] </label><select name="Filter" id="patroncategory"><option value=""> [% t('Any category code') %]</option>
    [% FOREACH patron_category IN patron_categories %]
        <option value="[% patron_category.categorycode %]">[% patron_category.description %] </option>
     [% END %]
    </select>
        </li>
				<li><label for="day">[% t('Day:') %] </label> <input type="text" name="Filter" id="day" value="" /></li>
				<li><label for="month">[% t('Month:') %] </label> <input type="text" name="Filter" id="month" value="" /></li>
				<li><label for="year">[% t('Year:') %] </label> <input type="text" name="Filter" id="year" value="" /></li>
	</ol>
	</fieldset>
	
	<fieldset class="rows">
	<legend>[% t('Limits') %]</legend>
	<ol><li><label for="numberlimit">[% t('Limit to:') %]</label><select name="Limit" id="numberlimit">
                        <option value="" selected="selected">[% t('None') %]</option>
						<option value="5" selected="selected"> [% t('5') %]</option>
						<option value="10">[% t('10') %]</option>
						<option value="15">[% t('15') %]</option>
						<option value="20">[% t('20') %]</option>
						<option value="25">[% t('25') %]</option>
						<option value="40">[% t('40') %]</option>
						<option value="50">[% t('50') %]</option>
						<option value="100">[% t('100') %]</option>
					</select></li>
	<li><label for="criteria">[% t('By:') %] </label><select name="Criteria" id="criteria">
						<option value="" selected="selected">[% t('None') %]</option>
                        <option value="branch">[% t('Library') %]</option>
						<option value="categorycode">[% t('Categorycode') %]</option>
						<option value="itemtype">[% t('Itemtype') %]</option>
						<option value="Day">[% t('Day') %]</option>
						<option value="Week">[% t('Week') %]</option>
						<option value="Month">[% t('Month') %]</option>
						<option value="Year">[% t('Year') %]</option>
					</select></li></ol>
	</fieldset>
	
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Items with no checkouts') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">
	.sql {display: none;}

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% t('› Items with no checkouts') %]</div>

<div id="doc3" class="yui-t2">
   <div id="bd">

	<div class="yui-b">

[% IF ( do_it ) %]
	<h1>[% t('Items with no checkouts') %]</h1>
	[% FOREACH mainloo IN mainloop %]
		[% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
			[% FOREACH loopfilte IN mainloo.loopfilter %]
				[% IF ( loopfilte.err ) %]<p class="error">[% t('Error:') %] 
				[% ELSE %]<p>
				[% END %]
					[% IF ( loopfilte.sql ) %]<span class="sql">[% END %]

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


		<table>
			<tr>
				<th>#</th>
                <th>[% t('Call number') %]</th>
				<th>[% t('Barcode') %]</th>
                <th>[% t('Item details') %]</th>
			</tr>
				[% IF ( looptable.looprow ) %]
				[% FOREACH loopro IN looptable.looprow %]
                    <tr>
		    
						<td>[% loop.count %]</td>
                        <td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber %][% ELSE %][% t('No call number') %][% END %]</td>
                        <td>[% IF ( loopro.barcode ) %][% loopro.barcode %][% ELSE %][% t('No barcode') %][% END %]</td>
                        <td><p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber %]">[% IF ( loopro.title ) %][% loopro.title %][% ELSE %][% t('NO TITLE') %][% END %]</a> [% IF ( loopro.author ) %] [% t('by') %] [% loopro.author %][% END %]</p>
                            [% IF ( loopro.branch ) %][% t('at') %] [% Branches.GetName( loopro.branch ) %][% END %]
						</td>
					</tr>
				[% END %]
				[% ELSE %]
					<tr><td colspan="4">[% t('No items for') %] [% looptable.coltitle %]</td>
					</tr>
				[% END %]
		</table>
		[% END %]
	[% END %]
[% ELSE %]
    <h1>[% t('Items with no checkouts') %]</h1>
	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
	
	<fieldset class="rows">
		<ol>
			<li><label for="branch">[% t('Library:') %] </label>
	<select name="Filter" id="branch">
        <option value="">[% t('Any library') %]</option>
        [% PROCESS options_for_libraries libraries => Branches.all() %]
    </select></li>
      <li> 
        <label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype">
        <option value="">[% t('Any item type') %]</option>
    [% FOREACH itemtype IN itemtypes %]
        <option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>
     [% END %] 

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




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Catalog statistics › Results') %][% ELSE %][% t('› Catalog statistics') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/catalogue_stats.pl">[% t('Catalog statistics') %]</a> [% t('› Results') %][% ELSE %][% t('› Catalog statistics') %][% END %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
	[% FOREACH mainloo IN mainloop %]
		<h1>[% t('Catalog statistics') %]</h1>
		[% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
			[% FOREACH loopfilte IN mainloo.loopfilter %]
					<p>[% loopfilte.crit %] =[% loopfilte.filter %]</p>
			[% END %]

				[% FOREACH loopco IN mainloo.loopcol %]
					<th>[% loopco.coltitle %]</th>
				[% END %]
				<th>[% t('TOTAL') %]</th>
			</tr>
				[% FOREACH loopro IN mainloo.looprow %]
					<tr>

						[% FOREACH loopcel IN loopro.loopcell %]
							[% IF ( loopcel.hilighted ) %]<td>[% ELSE %]<td>[% END %]
								[% IF ( loopcel.value ) %][% loopcel.value %]
								[% ELSE %] 
								[% END %]
							</td>
						[% END %]

					</tr>
				[% END %]
				<tr>
					<th>[% t('TOTAL') %]</th>
					[% FOREACH loopfoote IN mainloo.loopfooter %]
						<th>
							[% loopfoote.totalcol %]


	<form method="post" action="/cgi-bin/koha/reports/catalogue_stats.pl">
	<fieldset class="rows">
	<legend>[% t('Catalog statistics') %]</legend>
	<table>
		<thead>
			<tr>
			<th>[% t('Title') %]</th>
			<th>[% t('Row') %]</th>
			<th>[% t('Column') %]</th>
			<th>[% t('Filter') %]</th>
			</tr>
		</thead>
		<tbody>
      <tr>
        <td>[% t('Koha full call number') %]</td>
        <td><input type="radio" name="Line" value="items.itemcallnumber" /></td>
        <td><input type="radio" name="Column" value="items.itemcallnumber" /></td>
        <td><label for="callnoFrom">[% t('From') %]</label> <input type="text" name="Filter" id="callnoFrom" /> <label for="callnoTo">[% t('To') %]</label> <input type="text" name="Filter" id="callnoTo" /></td>
      </tr>
     <tr>
        <td> </td>
        <td colspan="2"><select name="cotedigits" id="cotedigits">
          <option value=""> </option>
          <option value="1">[% t('1') %]</option>
          <option value="2">[% t('2') %]</option>
          <option value="3">[% t('3') %]</option>
          <option value="4">[% t('4') %]</option>
          <option value="5">[% t('5') %]</option>
          </select>
          <label for="cotedigits">[% t('characters') %]</label>
        </td>
        <td> </td>
      </tr>
			 <tr>
                <td>[% t('Item type') %]</td>
				<td><input type="radio" name="Line" value="[% item_itype %]" /></td>
				<td><input type="radio" name="Column" value="[% item_itype %]" /></td>
				<td><select name="Filter" id="[% item_itype %]">

				</td>
			</tr>
			 <tr>
				<td>[% t('Publisher') %]</td>
				<td><input type="radio" name="Line" value="publishercode" /></td>
				<td><input type="radio" name="Column" value="publishercode" /></td>
				<td><input type="text" name="Filter" /></td>
			</tr>
			<tr>
                <td>[% t('Publication year') %]</td>
				<td><input type="radio" name="Line" value="publicationyear" /></td>
				<td><input type="radio" name="Column" value="publicationyear" /></td>
                <td><label for="pubyearFrom">[% t('From') %]</label> <input type="text" name="Filter" id="pubYearFrom" /> <label for="pubyearTo">[% t('To') %]</label> <input type="text" name="Filter" id="pubyearTo" /></td>
			</tr>
			<tr>
                <td>[% t('Home library') %]</td>
				<td><input type="radio" name="Line" value="items.homebranch" /></td>
				<td><input type="radio" name="Column" value="items.homebranch" /></td>
				<td><select name="Filter" id="branch">

				</td>
			</tr>
			<tr>
                <td>[% t('Shelving location') %]</td>
				<td><input type="radio" name="Line" value="items.location" /></td>
				<td><input type="radio" name="Column" value="items.location" /></td>
				<td><select name="Filter" id="location">

				</td>
			</tr>
			<tr>
				<td>[% t('Collection') %]</td>
				<td><input type="radio" name="Line" value="items.ccode" /></td>
				<td><input type="radio" name="Column" value="items.ccode" /></td>
				<td><select name="Filter" id="ccode">
					<option value=""> </option>

            [% IF (notforloan) %]
                <tr>
                    <td>[% notforloan_label %]</td>
                    <td><input type="radio" name="Line" value="items.notforloan" /></td>
                    <td><input type="radio" name="Column" value="items.notforloan" /></td>
                    <td>
                        [% IF (notforloan_avlist) %]
                            <select name="Filter" id="notforloan">
                                <option value=""> </option>
                                [% FOREACH av IN notforloan_avlist %]
                                    <option value="[% av.authorised_value %]">
                                        [% av.lib %]

            [% IF (materials) %]
                <tr>
                    <td>[% materials_label %]</td>
                    <td><input type="radio" name="Line" value="items.materials" /></td>
                    <td><input type="radio" name="Column" value="items.materials" /></td>
                    <td>
                        [% IF (materials_avlist) %]
                            <select name="Filter" id="materials">
                                <option value=""> </option>
                                [% FOREACH av IN materials_avlist %]
                                    <option value="[% av.authorised_value %]">
                                        [% av.lib %]

                </tr>
            [% END %]
            <tr>
                <td colspan="3">[% t('Filter barcode') %]</td>
                <td>
                    <select name="Filter" id="like">
                        <option value="1">[% t('like') %]</option>
                        <option value="0">[% t('not like') %]</option>
                    </select>
                    <input type="text" name="Filter" id="barcode" />
                    [% t('(use * to do a fuzzy search)') %]
                </td>
            </tr>
            <tr>
                <td>[% t('Date acquired (item)') %]</td>
                <td><input type="radio" name="Line" value="items.dateaccessioned" /></td>
                <td><input type="radio" name="Column" value="items.dateaccessioned" /></td>
                <td>
                    <label for="acqdateFrom">[% t('From') %]</label>
                    <input type="text" name="Filter" id="acqdateFrom" class="datepicker" />
                    <label for="acqdateTo">[% t('To') %]</label>
                    <input type="text" name="Filter" id="acqdateTo" class="datepicker" />
                </td>
            </tr>
            <tr id="removeddatetr">
                <td>[% t('Date deleted (item)') %]</td>
                <td><input type="radio" name="Line" value="deleteditems.timestamp" /></td>
                <td><input type="radio" name="Column" value="deleteditems.timestamp" /></td>
                <td>
                    <label for="deldateFrom">[% t('From') %]</label>
                    <input type="text" name="Filter" id="deldateFrom" class="datepicker" />
                    <label for="deldateTo">[% t('To') %]</label>
                    <input type="text" name="Filter" id="deldateTo" class="datepicker" />
                </td>
            </tr>
		</tbody>
	</table><br /></fieldset>

    <fieldset class="rows">
        <legend>[% t('Cell value') %]</legend>
        <ol>
            <li>
                <label for="cellvalue_items">[% t('Count total items') %]</label>
                <input type="radio" name="Cellvalue" value="items" id="cellvalue_items" checked="checked" />
            </li>
            <li>
                <label for="cellvalue_biblios">[% t('Count unique biblios') %]</label>
                <input type="radio" name="Cellvalue" value="biblios" id="cellvalue_biblios" />
            </li>
            <li>
                <label for="cellvalue_deleteditems">[% t('Count deleted items') %]</label>
                <input type="radio" name="Cellvalue" value="deleteditems" id="cellvalue_deleteditems" />
            </li>
        </ol>
    </fieldset>
	
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
	<ol><li><label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
		<li><label for="outputfile">[% t('To a file:') %] </label><input type="radio" name="output" value="file" id="outputfile" />
			<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
			<label class="inline" for="MIME">[% t('Into an application:') %] </label>
			<select name="MIME" id="MIME">
			[% FOREACH CGIextChoic IN CGIextChoice %]
			<option value="[% CGIextChoic.type %]">[% CGIextChoic.type %]</option>




[% PROCESS 'i18n.inc' %]
[% INCLUDE 'doc-head-open.inc' %]
    <title>[% t('Koha › Reports › Convert report') %]</title>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    </head>
    <body id="rep_report_convert" class="rep">
        <div>
            [% IF msg == 'no_report' %]
                [% t('There is no valid report for this id.') %]
            [% ELSIF msg == 'can_be_updated' %]
                <div id="col1">
                    <h3>[% t('Existing SQL') %]</h3>
                    <span class="show_sql">[% current_sql | html_entity %]</span>
                </div>

                <div id="col2">
                    <h3>[% t('Updated SQL') %]</h3>
                    <span class="show_sql">[% updated_sql | html_entity %]</span>
                </div>
            [% ELSE %]
                [% t('Something went wrong.') %]
            [% END %]
        </div>
    </body>

Lines 1-3 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/csv/cash_register_stats.tt (-1 / +2 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[%- USE ItemTypes -%]	2	[%- USE ItemTypes -%]
2	[%- INCLUDE csv_headers/reports/cash_register_stats.tt -%]	3	[%- INCLUDE csv_headers/reports/cash_register_stats.tt -%]
3	[%- INCLUDE empty_line.inc -%]	4	[%- INCLUDE empty_line.inc -%]
Lines 5-9 Link Here
5	[%- FOREACH field IN row; field IF !loop.last; ItemTypes.GetDescription(field) IF loop.last; sep IF !loop.last; END -%]	6	[%- FOREACH field IN row; field IF !loop.last; ItemTypes.GetDescription(field) IF loop.last; sep IF !loop.last; END -%]
6	[%- INCLUDE empty_line.inc -%]	7	[%- INCLUDE empty_line.inc -%]
7	[%- END -%]	8	[%- END -%]
8	TOTAL[%- INCLUDE empty_line.inc -%]	9	[% t('TOTAL') %][%- INCLUDE empty_line.inc -%]
9	[%- FOREACH field IN total; field; sep IF !loop.last; END -%]	10	[%- FOREACH field IN total; field; sep IF !loop.last; END -%]

Lines 1-8 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/csv/orders_by_budget.tt (-1 / +2 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[%- INCLUDE csv_headers/reports/orders_by_budget.tt -%]	2	[%- INCLUDE csv_headers/reports/orders_by_budget.tt -%]
2	[%- INCLUDE empty_line.inc -%]	3	[%- INCLUDE empty_line.inc -%]
3	[%- FOREACH row IN rows -%]	4	[%- FOREACH row IN rows -%]
4	[%- FOREACH field IN row; field; sep IF !loop.last; END -%]	5	[%- FOREACH field IN row; field; sep IF !loop.last; END -%]
5	[%- INCLUDE empty_line.inc -%]	6	[%- INCLUDE empty_line.inc -%]
6	[%- END -%]	7	[%- END -%]
7	TOTAL[%- INCLUDE empty_line.inc -%]	8	[% t('TOTAL') %][%- INCLUDE empty_line.inc -%]
8	[%- FOREACH field IN totalrow; field; sep IF !loop.last; END -%]	9	[%- FOREACH field IN totalrow; field; sep IF !loop.last; END -%]




[% PROCESS 'i18n.inc' %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Guided reports › Dictionary') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
</head>


[%- BLOCK area_name -%]
    [%- SWITCH area -%]
        [%- CASE 'CIRC' -%][% t('Circulation') %]
        [%- CASE 'CAT'  -%][% t('Catalog') %]
        [%- CASE 'PAT'  -%][% t('Patrons') %]
        [%- CASE 'ACQ'  -%][% t('Acquisitions') %]
        [%- CASE 'ACC'  -%][% t('Accounts') %]
    [%- END -%]
[%- END -%]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> › <a href="/cgi-bin/koha/reports/guided_reports.pl">[% t('Guided reports wizard') %]</a>
[% IF ( new_dictionary ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Name the new definition') %]</strong>
[% ELSIF ( step_2 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 2: Choose the area') %] </strong> 
[% ELSIF ( step_3 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 3: Choose a column') %] </strong>
[% ELSIF ( step_4 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 4: Specify a value') %] </strong> 
[% ELSIF ( step_5 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 5: Confirm definition') %]</strong> 
[% ELSE %] › <strong> [% t('Dictionary') %] </strong>[% END %]</div>

<div id="doc3" class="yui-t2">


<div class="yui-b">
[% IF ( start_dictionary ) %]
    <div id="toolbar">
        <a id="newdictionary" class="btn btn-default btn-sm" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition"><i class="fa fa-plus"></i> [% t('New definition') %]</a>
    </div>
[% END %]
<h1>[% t('Dictionary') %]</h1>
[% IF ( start_dictionary ) %]
	<p>[% t('Use the dictionary to define custom criteria for reporting.') %]</p>

		[% IF ( definitions ) %]
        <h2>[% t('Current terms') %]</h2>
		<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
        <input type="hidden" name="phase" value="View Dictionary" />
  [% IF ( areas ) %]
        [% t('Filter by area') %]
        <select name="area">
          <option value="">[% t('All') %]</option>
        [% FOREACH area IN areas %]
          [%- IF ( area.selected ) -%]
          <option value="[% area.id %]" selected="selected">[%- PROCESS area_name area=area.id -%]</option>

      <br />
        <table>
            <tr>
                <th>[% t('Name') %]</th>
                <th>[% t('Description') %]</th>
                <th>[% t('Area') %]</th>
                <th>[% t('Definition') %]</th>
                <th>[% t('Action') %]</th>
            </tr>
            [% FOREACH definition IN definitions %]
            <tr>

                <td class="actions"><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
                    <input type="hidden" name="id" value="[% definition.id %]" />
                    <input type="hidden" name="phase" value="Delete Definition" />
                    <button type="submit" name="submit" class="btn btn-default btn-xs" id="delete"><i class="fa fa-trash"></i> [% t('Delete') %]</button>
                </form></td>
            </tr>
            [% END %]
        </table>
                [% ELSE %]
                <div class="dialog message">[% t('There are no saved definitions.') %] <a id="newdictionary" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition">[% t('Add a definition to the dictionary.') %]</a></div>
		[% END %]
[% END %]

[% IF ( new_dictionary ) %]
<h3>[% t('Add new definition') %]</h3>
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
<fieldset class="rows"><legend>[% t('Step 1 of 5: Name the new definition') %]</legend><ol>
<li>
<label for="definition_name">[% t('Definition name:') %]</label>
<input type="text" id="definition_name" name="definition_name" />
</li>
<li>
<label for="definition_description">[% t('Definition description:') %]</label>
<textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
</li>
</ol></fieldset>

[% END %]

[%- IF ( step_2 ) -%]
<h3>[% t('Add new definition') %]</h3>
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
  <fieldset class="rows">
    <legend>[% t('Step 2 of 5: Choose the area') %]</legend>
    <ol>
      <li>
        <input type="hidden" name="phase" value="New Term step 3" />
        <input type="hidden" name="definition_name" value="[% definition_name | html %]" />
        <input type="hidden" name="definition_description" value="[% definition_description | html %]" />
        <label for="area">[% t('Select table:') %]</label><select name="area" id="area">
      [%- FOREACH area IN areas -%]
        <option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>
      [%- END -%]

[%- END -%]

[% IF ( step_3 ) %]
<h3>[% t('Add new definition') %]</h3>
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">      
<fieldset class="rows">
<legend>[% t('Step 3 of 5: Choose a column') %]</legend>
<input type="hidden" name="area" value="[% area %]" />
<input type="hidden" name="definition_name" value="[% definition_name | html %]" />
<input type="hidden" name="definition_description" value="[% definition_description | html %]" />

[% END %]

[% IF ( step_4 ) %]
<h3>[% t('Add new definition') %]</h3>
<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
<fieldset class="rows">
<legend>[% t('Step 4 of 5: Specify a value') %]</legend>
<input type="hidden" name="area" value="[% area %]" />
<input type="hidden" name="definition_name" value="[% definition_name | html %]" />
<input type="hidden" name="definition_description" value="[% definition_description | html %]" />


[% FOREACH column IN columns %]
<input type="hidden" name="criteria_column" value="[% column.name %]" />
<ol><li><span class="label">[% t('Column:') %] </span> [% column.name %]</li>
[% IF ( column.distinct ) %]
    <li><label for="[% column.name %]_value">[% t('Choose:') %] </label> <select id="[% column.name %]_value" name="[% column.name %]_value">
        [% FOREACH value IN column.values %]
            <option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
        [% END %]

[% END %]
[% IF ( column.date ) %]
    <li class="radio">
        <label for="all_dates">[% t('All dates') %]</label>
        <input type="radio" id="all_dates" name="[% column.name %]_date_type_value" value="all" checked="checked" />
        <label for="date_range">[% t('Date range') %]</label>
        <input type="radio" id="date_range" name="[% column.name %]_date_type_value" value="range" />
    </li>
    <li class="radio">
        [% t('Start of date range') %]
        <input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />
        <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
        [% t('End of date range') %]
        <input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />
        <div class="hint">[% INCLUDE 'date-format.inc' %]</div>
    </li>
[% END %]
[% IF ( column.text ) %]
	<li><label for="[% column.name %]_value">[% t('Search string matches:') %] </label> <input type="text" size="13" name="[% column.name %]_value" /></li>
[% END %]

[% END %]

<input type="hidden" name="definition_description" value="[% definition_description | html %]" />
<input type="hidden" name="columnstring" value="[% columnstring %]" />

<h3>[% t('Add new definition') %]</h3>

<fieldset class="rows">
  <legend>[% t('Step 5 of 5: Confirm details') %]</legend>
  <ol>
    <li>
      <span class="label">[% t('Name:') %]</span>[%- definition_name | html -%]
    </li>
    <li>
      <span class="label">[% t('Description:') %]</span>[%- definition_description | html -%]
    </li>
    <li>
      <span class="label">[% t('Area:') %]</span>[%- PROCESS area_name area=area -%]
    </li>
    <li>
      <span class="label">[% t('Data:') %]</span>
      <table>
        <tr>
          <th>[% t('Columns') %]</th>
          <th>[% t('Values') %]</th>
        </tr>
      [%- FOREACH criteria_loo IN criteria_loop -%]
        <tr>




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE KohaDates %]
[% USE Koha %]

[% SET footerjs = 1 %]
[%- BLOCK area_name -%]
    [%- SWITCH area -%]
        [%- CASE 'CIRC' -%][% t('Circulation') %]
        [%- CASE 'CAT'  -%][% t('Catalog') %]
        [%- CASE 'PAT'  -%][% t('Patrons') %]
        [%- CASE 'ACQ'  -%][% t('Acquisitions') %]
        [%- CASE 'ACC'  -%][% t('Accounts') %]
        [%- CASE 'SER'  -%][% t('Serials') %]
    [%- END -%]
[%- END -%]

[% INCLUDE 'doc-head-open.inc' %]

<title>[% t('Koha › Reports › Guided reports wizard') %] [%- IF ( saved1 ) -%][% t('› Saved reports') %]
[%- ELSIF ( create ) -%][% t('› Create from SQL') %]
[%- ELSIF ( showsql ) -%][% t('› Saved reports › SQL view') %]
[%- ELSIF ( execute ) -%][% t('› Saved reports ›') %] [% name %] [% t('Report') %]
[%- ELSIF ( editsql ) -%][% t('› Saved reports › Edit SQL report') %]
[%- END -%]
[%- IF ( build1 ) -%][% t('› Build a report, step 1 of 6: Choose a module') %]
[%- ELSIF ( build2 ) -%][% t('› Build a report, step 2 of 6: Pick a report type') %]
[%- ELSIF ( build3 ) -%][% t('› Build a report, step 3 of 6: Select columns for display') %]
[%- ELSIF ( build4 ) -%][% t('› Build a report, step 4 of 6: Select criteria to limit on') %]
[%- ELSIF ( build5 ) -%][% t('› Build a report, step 5 of 6: Pick which columns to total') %]
[%- ELSIF ( build6 ) -%][% t('› Build a report, step 6 of 6: Select how you want the report ordered') %]
[%- END -%]</title>

[% INCLUDE 'doc-head-close.inc' %]

[% INCLUDE 'header.inc' %]
[% INCLUDE 'circ-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a>
› <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>
› <a href="/cgi-bin/koha/reports/guided_reports.pl">[% t('Guided reports wizard') %]</a>

[% IF ( saved1 ) %][% t('› Saved reports') %]
[% ELSIF ( create ) %][% t('› Create from SQL') %]
[% ELSIF ( showsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> [% t('› SQL view') %]
[% ELSIF ( editsql ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> [% t('› Edit SQL report') %]
[% ELSIF ( execute ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved">[% t('Saved reports') %]</a> › <em>[% name %]</em> [% t('Report') %]
[% ELSIF ( build1 || build2 || build3 || build4 || build5 || build6 ) %]› <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">[% t('Build a report') %]</a>
    [% IF ( build1 ) %][% t('› Step 1 of 6: Choose a module') %]
    [% ELSIF ( build2 ) %][% t('› Step 2 of 6: Pick a report type') %]
    [% ELSIF ( build3 ) %][% t('› Step 3 of 6: Select columns for display') %]
    [% ELSIF ( build4 ) %][% t('› Step 4 of 6: Select criteria to limit on') %]
    [% ELSIF ( build5 ) %][% t('› Step 5 of 6: Pick which columns to total') %]
    [% ELSIF ( build6 ) %][% t('› Step 6 of 6: Select how you want the report ordered') %]
    [% END %]
[% END %]
</div>

    <div class="modal-content">
    <div class="modal-header">
        <button type="button" class="closebtn" data-dismiss="modal" aria-hidden="true">×</button>
        <h3 id="update_sql_label">[% t('Update SQL') %]</h3>
    </div>
    <div class="modal-body">
        <div id="loading"> <img src="[% interface %]/[% theme %]/img/spinner-small.gif" alt="" /> [% t('Loading') %] </div>
    </div>
    <div class="modal-footer">
        <a href="#" class="btn btn-default" id="update_sql_button" role="button" data-toggle="modal">[% t('Update') %]</a>
        <button class="btn btn-default" data-dismiss="modal" aria-hidden="true">[% t('Close') %]</button>
    </div>
    </div>
    </div>

    [% INCLUDE "reports-toolbar.inc" %]

[% IF ( start ) %]
    <h2>[% t('Guided reports') %]</h2>
    <p>[% t('Use the guided reports engine to create non standard reports.') %]
[% t('This feature aims to provide some middle ground between the built in') %]
[% t('canned reports and writing custom SQL reports.') %]</p>

    <h3>[% t('Build and run reports') %]</h3>
        [% IF ( CAN_user_reports_create_reports ) %]
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
            <input type="hidden" name="phase" value="Build new" />
            <input type="submit" name="submit" value="Build new" />
        </form>
        [% END %]
        [% IF ( CAN_user_reports_execute_reports ) %]
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
            <input type="hidden" name="phase" value="Use saved" />
            <input type="submit" name="submit" value="Use saved" />
        </form>
        [% END %]
        [% IF ( CAN_user_reports_create_reports ) %]
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
            <input type="hidden" name="phase" value="Create report from SQL" />
            <input type="submit" name="submit" value="Create report from SQL" />
        </form>
        [% END %]
<h3>[% t('Reports Dictionary') %]</h3>
<p>[% t('Use the reports dictionary to define custom criteria to use in your reports') %]</p>
<form action="/cgi-bin/koha/reports/dictionary.pl">
<input type="hidden" name="phase" value="View Dictionary" />
<input type="submit" name="submit" value="View dictionary" />
</form>
[% END %]

[% IF report_converted %]
    <div class="dialog message">
        [% t('The report &#34;') %][% report_converted %][% t('&#34; has been converted.') %]
    </div>
[% END %]

[% IF ( saved1 ) %]
[% IF ( savedreports ) %]<h1>[% t('Saved reports') %]</h1>

<div id="tabs" class="toptabs">
    <ul>
        <li><a href="#reports">[% t('All') %]</a></li>
        [% FOREACH group IN groups_with_subgroups %]
            <li><a id="[% group.id %]" href="#reports">[% group.name %]</a></li>
        [% END %]
    </ul>
    <div id="reports">
        <div id="subgroup_filter_block">
            <label for="subgroup_filter">[% t('Subgroup:') %]</label>
            <select id="subgroup_filter">
                <option value="">[% t('All') %]</option>
            </select>
        </div>
<form action="/cgi-bin/koha/reports/guided_reports.pl" id="reports_form" method="post">

        <table id="table_reports">
            <thead>
                <tr>
                    <th> </th>
                    <th>[% t('ID') %]</th>
                    <th>[% t('Report name') %]</th>
                    <th>[% t('Type') %]</th>
                    <th>[% t('Group') %]</th>
                    <th>[% t('Subgroup') %]</th>
                    <th>[% t('Notes') %]</th>
                    <th>[% t('Author') %]</th>
                    <th class="title-string">[% t('Creation date') %]</th>
                    <th class="title-string">[% t('Last edit') %]</th>
                    <th class="title-string">[% t('Last run') %]</th>
                    <th class="report_public">[% t('Public') %]</th>
                    <th class="report_json_url">[% t('JSON URL') %]</th>
                    [% IF (usecache) %] <th>[% t('Cache expiry (seconds)') %]</th> [% END %]
                    <th>[% t('Saved results') %]</th>
                    [% IF has_obsolete_reports %]<th>[% t('Update') %]</th>[% END %]
                    <th>[% t('Actions') %]</th>
                </tr>
            </thead>
            <tbody>

                        <td><span title="[% savedreport.last_run %]">[% savedreport.last_run | $KohaDates with_hours => 1 %]</span></td>
                        <td class="report_public">
                        [% IF (savedreport.public) %]
                            [% t('Yes') %]
                        [% ELSE %]
                            [% t('No') %]
                        [% END %]
                        </td>
                        <td class="report_json_url">
                        [% IF (savedreport.public) %]
                            <a href="[% OPACBaseURL %]/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% OPACBaseURL %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %]</a>
                        [% ELSE %]
                            <a href="/cgi-bin/koha/svc/report?id=[% savedreport.id | uri %]">[% Koha.Preference('staffClientBaseURL') %][% t('/cgi-bin/koha/svc/report?id=') %][% savedreport.id | html %]</a>
                        [% END %]
                        </td>
                        [% IF (usecache) %] <td>[% savedreport.cache_expiry %]</td> [% END %]
                        <td>
                            [% FOR result IN savedreport.results %]
                                <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=[% result.id %]">[% result.date_run %]</a>
                                <br />
                            [% END %]
                        </td>
                        [% IF has_obsolete_reports %]
                        <td>
                            [% IF savedreport.seems_obsolete %]
                                [% t('This report seems obsolete, it uses biblioitems.marcxml field.') %]
                                <a href="/cgi-bin/koha/svc/convert_report?report_id=[% savedreport.id %]" data-report_id="[% savedreport.id %]" class="update_sql btn btn-default btn-xs" title="[% t('Update SQL') %]"><i class="fa fa-eye"></i> [% t('Update SQL') %]</a>
                            [% END %]
                        </td>
                        [% END %]

                            <div class="dropup">
                                <div class="btn-group">
                                    [%# There should be no space between these two buttons, it would render badly %]
                                    <a class="btn btn-default btn-xs" role="button" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Run%20this%20report"><i class="fa fa-play"></i> [% t('Run') %]</a><a class="btn btn-default btn-xs dropdown-toggle" id="reportactions[% savedreport.id %]" role="button" data-toggle="dropdown" href="#"><b class="caret"></b></a>
                                       href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&amp;phase=Run%20this%20report"><i
                                       class="fa fa-play"></i> Run</a><a
                                       class="btn btn-default btn-xs dropdown-toggle" id="reportactions[% savedreport.id %]" role="button" data-toggle="dropdown"
                                       href="#"><b class="caret"></b></a>
                                    <ul class="dropdown-menu pull-right" role="menu" aria-labelledby="reportactions[% savedreport.id %]">
                                        <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Show%20SQL"><i class="fa fa-search"></i> [% t('Show') %]</a></li>
                                        [% IF ( CAN_user_reports_create_reports ) %]
                                            <li><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Edit%20SQL"><i class="fa fa-pencil"></i> [% t('Edit') %]</a></li>
                                            <li><a title="[% t('Duplicate this saved report') %]" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create report from SQL&sql=[% savedreport.savedsql |uri %]&reportname=[% savedreport.report_name |uri %]&notes=[% savedreport.notes |uri %]"><i class="fa fa-copy"></i> [% t('Duplicate') %]</a></li>
                                        [% END %]
                                        <li><a href="/cgi-bin/koha/tools/scheduler.pl?id=[% savedreport.id %]"><i class="fa fa-clock-o"></i> [% t('Schedule') %]</a></li>
                                        [% IF ( CAN_user_reports_delete_reports ) %]
                                            <li><a class="confirmdelete" title="[% t('Delete this saved report') %]" href="/cgi-bin/koha/reports/guided_reports.pl?reports=[% savedreport.id %]&phase=Delete%20Saved"><i class="fa fa-trash"></i> [% t('Delete') %]</a></li>
                                        [% END %]
                                    </ul>
                                </div>

</div>
[% ELSE %]<div class="dialog message">
    [% IF (filter_set || filters.date || filters.author || filters.keyword) %]
    <h4>[% t('No saved reports match your criteria.') %] </h4>
    [% IF ( CAN_user_reports_create_reports ) %]
    <form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">
    <input type="hidden" name="phase" value="Build new" />
        <button type="submit" class="new"><i class="fa fa-plus"></i> [% t('New guided report') %]</button>
    </form>

    <form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">
        <input type="hidden" name="phase" value="Create report from SQL" />
        <button type="submit" class="new"><i class="fa fa-plus"></i> [% t('New SQL report') %]</button>
    </form>

    <form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">
    <input type="hidden" name="phase" value="Use saved" />
    <input type="hidden" name="filter_set" value="1" />
    <input type="hidden" name="filter_keyword" value="" />
        <button type="submit" class="deny"><i class="fa fa-fw fa-remove"></i> [% t('Cancel filter') %]</button>
    </form>

    [% END %]
    [% ELSE %]
    <h4>[% t('There are no saved reports.') %] </h4>
    [% IF ( CAN_user_reports_create_reports ) %]
        <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new">[% t('Build a new report?') %]</a>
    [% END %]
    [% END %]
    </div>

[% IF ( build1 ) %]
[% IF ( cache_error) %]
<div class="dialog alert">
<b> [% t('Please choose a cache_expiry less than 30 days') %] </b>
</div>
[% END %]
<h1>[% t('Build a report') %]</h1>
<form action="/cgi-bin/koha/reports/guided_reports.pl">
<fieldset class="rows">
<legend>[% t('Step 1 of 6: Choose a module to report on,') %][% IF (usecache) %] [% t('Set cache expiry,') %] [% END %] [% t('and choose report visibility') %] </legend>
<ol>
  <li>
    <label for="area">[% t('Choose:') %] </label>
      <select name="area" id="area">
    [%- FOREACH area IN areas -%]
      <option value="[% area %]">[%- PROCESS area_name area=area -%]</option>

      </select>
  </li>
[% IF (public) %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li>
[% ELSE %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li>
[% END %]
[% IF (usecache) %] <li>
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input>
<select id="cache_expiry_units" name="cache_expiry_units">
<option value="seconds">[% t('Seconds (default)') %]</option>
<option value="minutes">[% t('Minutes') %]</option>
<option value="hours">[% t('Hours') %]</option>
<option value="days">[% t('Days') %]</option>
</select>
</li>[% END %]
</ol>
</fieldset>
<fieldset class="action">
<input type="hidden" name="phase" value="Report on this Area" />
<input type="submit" name="submit" value="Next >>" />

</fieldset>
</form>



[% IF ( build2 ) %]
<h1>[% t('Build a report') %]</h1>
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<input type="hidden" name="area" value="[% area %]" />
<input type="hidden" name="public" value="[% public %]" />
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" />
<fieldset class="rows"><legend>[% t('Step 2 of 6: Pick a report type') %]</legend>
<ol><li><label for="types">[% t('Choose:') %] </label>
    <select id="types" name="types">
        <option value="1">[% t('Tabular') %]</option>
        <option value="2" disabled="disabled">[% t('Summary') %]</option>
        <option value="3" disabled="disabled">[% t('Matrix') %]</option>
    </select>
</li></ol></fieldset>

<fieldset class="action">
    <input type="hidden" name="phase" value="Choose this type" />
    <input type="button" name="back" value="<< Back" class="goback" />
    <input type="submit" name="submit" value="Next >>" />
</fieldset>
</form>
</div>

[% END %]

[% IF ( build3 ) %]
<h1>[% t('Build a report') %]</h1>
<h3>[% t('Step 3 of 6: Select columns for display') %]</h3>
<p>[% t('Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.') %]</p>

<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
    <input type="hidden" name="area" value="[% area %]" />

<optgroup label="[% column.table %]">
[% ELSE %]
<option value="[% column.name %]">
[% IF ( column.description ) %][% column.description %]   /   [% column.name %]
[% ELSE %]
[% column.name %]
[% END %]

</optgroup>
</select></div>
<div style="width: 6.3em; float: right; margin-top: 100px"><input type="button" name="Add" value="Add" class="button" style="width:6em;" id="addColumn" /><br />
<input type="button" name="delete" value="<< Delete" class="button" style="width: 6em; margin: 1em 0;" id="delColumn" /></div>
</div>

<div class="yui-u">

<div class="yui-g">
<fieldset class="action">
    <input type="hidden" name="phase" value="Choose these columns" />
    <input type="button" name="back" value="<< Back" class="goback" />
    <input type="submit" name="submit" value="Next >>" />
</fieldset>
</div>
</form>

[% END %]

[% IF ( build4 ) %]
<h1>[% t('Build a report') %]</h1>
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
    <input type="hidden" name="area" value="[% area %]" />
    <input type="hidden" name="type" value="[% type %]" />
    <input type="hidden" name="column" value="[% column %]" />
    <input type="hidden" name="public" value="[% public %]" />
    <input type="hidden" name="cache_expiry" value="[% cache_expiry %]" />
    <fieldset><legend>[% t('Step 4 of 6: Select criteria to limit on') %]</legend>
    <table>
        [% FOREACH criteri IN criteria %]
        <tr>

        </tr>
        [% ELSE %]
        [% IF ( criteri.textrange ) %]
            <td>[% t('from') %]
            <input type="text" size="10" id="[% criteri.from %]_value" name="[% criteri.from %]_value" value="" /> [% t('to') %] 
            <input type="text" size="10" id="[% criteri.to %]_value" name="[% criteri.to %]_value" value="" />
            </td>
            </tr>
        [% ELSE %]
            [% IF ( criteri.daterange ) %]
            <td>[% t('from') %] 
            <input type="text" size="10" id="from_[% criteri.name %]_value" name="from_[% criteri.name %]_value" value="" class="datepickerfrom" />
            [% t('to') %]
            <input type="text" size="10" id="to_[% criteri.name %]_value" name="to_[% criteri.name %]_value" value="" class="datepickerto" />
			<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
            </td>

            <td>
                <select name="[% criteri.name %]_value">
                [% FOREACH value IN criteri.values %]
                <option value="[% value.availablevalues %]">[% IF ( value.default ) %][% t('Default') %][% ELSE %][% value.display_value |html %][% END %]</option>
                [% END %]
                </select>
            </td>

    </fieldset>

[% IF ( definitions ) %]
<fieldset><legend>[% t('Dictionary definitions') %]</legend>
<table>
[% FOREACH definition IN definitions %]
    <tr><td><input type="checkbox" name="definition" value="[% definition.id %]" /> [% definition.name %]</td></tr>

[% END %]

<fieldset class="action"><input type="hidden" name="phase" value="Choose these criteria" />
    <input type="button" name="back" value="<< Back" class="goback" />
    <input type="submit" name="submit" value="Next >>" /> </fieldset>
</form>
[% END %]


[% IF ( build5 ) %]
<h1>[% t('Build a report') %]</h1>
<h3>[% t('Step 5 of 6: Pick which columns to total') %]</h3>
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<input type="hidden" name="area" value="[% area %]" />
<input type="hidden" name="type" value="[% type %]" />

</table></fieldset>

<fieldset class="action"><input type="hidden" name="phase" value="Choose these operations" />
    <input type="button" name="back" value="<< Back" class="goback" />
    <input type="submit" name="submit" value="Next >>" /></fieldset>
</form>
[% END %]


[% IF ( build6 ) %]
<h1>[% t('Build a report') %]</h1>
<h3>[% t('Step 6 of 6: Choose how you want the report ordered') %]</h3>
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<input type="hidden" name="area" value="[% area %]" />
<input type="hidden" name="type" value="[% type %]" />



[% IF ( showreport ) %]
<h1>[% t('Confirm custom report') %]</h1>
<p>[% t('Your report will be generated with the following SQL statement.') %]</p>
<p> 
[% sql |html %]
</p>

<input type="hidden" name="type" value="[% type %]" />
<input type="hidden" name="public" value="[% public %]" />
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" />
<p>[% t('You will need to save the report before you can execute it') %]</p>
<fieldset class="action"><input type="hidden" name="phase" value="Save" />  
<input type="submit" name="submit" value="Save" />  </fieldset>
</form>

<input type="hidden" name="public" value="[% public %]" />
<input type="hidden" name="cache_expiry" value="[% cache_expiry %]" />
<fieldset class="rows">
<legend>[% t('Save your custom report') %]</legend>
<ol>
    <li><label for="reportname" class="required">[% t('Report name:') %] </label><input type="text" id="reportname" name="reportname" class="required" required="required" /> <span class="required">[% t('Required') %]</span></li>
    [% PROCESS group_and_subgroup_selection %]
    <li><label for="notes">[% t('Notes:') %]</label> <textarea name="notes" id="notes"></textarea></li>
</ol></fieldset>
<fieldset class="action"><input type="hidden" name="phase" value="Save Report" />
<input type="submit" name="submit" value="Save report" /></fieldset>


[% IF ( warn_authval_problem ) %]
    <div class="dialog alert">
        <h3>[% t('Errors found when processing parameters for report:') %] [% name %]</h3>
        [% FOREACH problematic_authval IN problematic_authvals %]
            <p>
            <strong>[% problematic_authval.name %]:</strong> [% t('The authorized value category (') %]<strong>[% problematic_authval.authval %]</strong>)
                [% t('you selected does not exist.') %]
            </p>
        [% END %]
        <!-- Save Anyway Form -->
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
        <!--Every parameter the user issued is provided as a hidden field for recovery-->
            <input type="hidden" name="id" value="[% id %]" />
            <input type="hidden" name="sql" value="[% sql %]" />
            <input type="hidden" name="reportname" value="[% reportname %]" />
            <input type="hidden" name="group" value="[% group %]" />
            <input type="hidden" name="subgroup" value="[% subgroup %]" />
            <input type="hidden" name="notes" value="[% notes %]" />
            <input type="hidden" name="cache_expiry" value="[% cache_expiry %]" />
            <input type="hidden" name="cache_expiry_units" value="[% cache_expiry_units %]" />
            <input type="hidden" name="public" value="[% public %]" />
        [% IF ( phase_update) %]
            <input type="hidden" name="phase" value="Update SQL" />
            <button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> [% t('Save anyway') %]</button>
        [% ELSIF ( phase_save) %]
            <input type="hidden" name="area" value="[% area %]" />
            <input type="hidden" name="phase" value="Save Report" />
            <button type="submit" name="save_anyway" value="Save anyway" class="approve"><i class="fa fa-fw fa-check"></i> [% t('Save anyway') %]</button>
        [% END %]
        </form>
        <!-- Go back to editing -->
        <form action="/cgi-bin/koha/reports/guided_reports.pl">
            <button type="button" class="new goback"><i class="fa fa-fw fa-pencil"></i> [% t('Edit SQL') %]</button>
        </form>
    </div>
[% END %]

[% IF ( enter_params ) %]
    <form action="/cgi-bin/koha/reports/guided_reports.pl">
        <input type="hidden" name="reports" value="[% reports %]" />
    [% IF ( auth_val_error ) %]
        <input type="hidden" name="phase" value="Edit SQL" />
        <div class="dialog alert">
            <h3>[% t('Errors found when processing parameters for report:') %] [% name %]</h3>
            [% FOREACH auth_val_error IN auth_val_errors %]
                <p>
                    <strong>[% auth_val_error.entry %]:</strong> [% t('The authorized value category (') %]<strong>[% auth_val_error.auth_val %]</strong>)
                    [% t('you selected does not exist.') %]
                </p>
            [% END %]
        </div>
        <fieldset class="action"><input type="submit" value="Edit SQL" /></fieldset>
    [% ELSE %]
        <input type="hidden" name="phase" value="Run this report" />
        <h1>[% t('Enter parameters for report') %] [% name %]:</h1>
        [% IF ( notes ) %]<p>[% notes %]</p>[% END %]
        <fieldset class="rows">
            <ol>

                    <li><label for="sql_params[% loop.count %]">[% sql_param.entry %]: </label><input id="sql_params[% loop.count %]" type="text" name="sql_params" /></li>
                [% ELSE %]
                    <li><label for="sql_params_[% sql_param.labelid %]">[% sql_param.entry %]:</label>
                        <select name="[%- sql_param.input.name -%]" tabindex="1" size="1" id="[%- sql_param.input.id -%]">
                        [% FOREACH value IN sql_param.input.values %]
                            <option value="[%- value -%]">[%- sql_param.input.labels.$value -%]</option>
                        [% END %]


[% IF ( execute ) %]
<h1>[% name %]</h1>
[% IF ( notes ) %]<p><span class="label">[% t('Notes:') %]</span> [% notes %]</p>[% END %]
[% IF ( unlimited_total ) %]<p><span class="label">[% t('Total number of results:') %]</span> [% unlimited_total %][% IF unlimited_total > limit %] ([% limit %] [% t('shown)') %][% END %].</p>[% END %]
<div id="sql_output" style="display:none;"><span class="label">[% t('Report SQL:') %]</span><pre>[% sql |html %]</pre></div>
</br>

<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get" id="limitselect">
    <input type="hidden" name="phase" value="Run this report" />
    <input type="hidden" name="reports" value="[% report_id %]" />

    [% FOREACH p IN sql_params %]
        <input type="hidden" name="sql_params" value="[% p %]" />
    [% END %]

    <label for="limit">[% t('Rows per page:') %] </label>
    <select name="limit" id="limit">
        [% limits = [ 10, 20, 50, 100, 200, 300, 400, 500, 1000 ] %]
        [% FOREACH l IN limits %]

                [% FOREACH header_ro IN header_row %]
                    [% IF header_ro.cell == 'itemnumber' %]
                        <th>
                            [% header_ro.cell %] <button type="submit" data-toggle="tooltip" title="[% t('Send visible items to batch modification') %]" class="btn btn-xs btn-default send_to_item_mod"><i class="fa fa-pencil"></i> [% t('Batch modify') %]</button>
                        </th>
                    [% ELSE %]
                        <th>[% header_ro.cell %]</th>

</script>
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated">
<fieldset class="rows">
<legend>[% t('Create report from SQL') %]</legend>
<ol>
    <li><label for="reportname" class="required">[% t('Report name:') %]</label>
        [% IF ( reportname ) %]<input type="text" class="required" required="required" id="reportname" name="reportname" value="[% reportname | html %]" size="50" />
        [% ELSE %]<input type="text" class="required" required="required" id="reportname" name="reportname" size="50" />[% END %] <span class="required">[% t('Required') %]</span>
    </li>
    [% PROCESS group_and_subgroup_selection %]

[% IF (public) %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li>
[% ELSE %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li>
[% END %]
[% IF (usecache) %] <li>
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input>
<select id="cache_expiry_units" name="cache_expiry_units">
<option value="seconds" selected="selected">[% t('Seconds (default)') %]</option>
<option value="minutes">[% t('Minutes') %]</option>
<option value="hours">[% t('Hours') %]</option>
<option value="days">[% t('Days') %]</option>
</select>
</li>[% END %]
    <li><label for="notes">[% t('Notes:') %]</label> <textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li>
</ol>
</fieldset>
<fieldset class="rows">
<legend>[% t('SQL:') %]</legend>
<div style="margin:1em;">
<textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">[% t('Required') %]</span>
</div>
</fieldset>

<fieldset class="action"><input type="hidden" name="phase" value="Save Report" />
<input type="submit" name="submit" value="Save report" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">[% t('Cancel') %]</a>
</fieldset>
</form>
[% END %]

[% IF saved_results %]
<h1>[% t('Saved report results') %]</h1>
<h2>[% name %]</h2>
<p>[% notes %]</p>
<table>

<fieldset class="rows">
    <legend>[% reportname %]</legend>
    <ol>
        [% IF ( notes ) %]<li><span class="label">[% t('Notes:') %]</span> [% notes %]</li>[% ELSE %][% END %]
        <li><textarea id="sql">[% sql %]</textarea></li>
    </ol>
</fieldset>

</br>
<div id="report_updated">
    <div class="dialog message">
        <p>[% t('Your report &#34;') %][% reportname %][% t('&#34; has been saved') %]</p>
    </div>
</div>
[% END %]

[% IF ( editsql ) %]
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post" class="validated">
<input type="hidden" name="phase" value="Update SQL" />
<input type="hidden" name="id" value="[% id %]" />
<fieldset class="rows">
<legend>[% t('Edit SQL report') %]</legend>
<ol>
<li><label for="reportname" class="required">[% t('Report name:') %] </label><input type="text" id="reportname" name="reportname" value="[% reportname | html %]" size="50" class="required" required="required" /> <span class="required">[% t('Required') %]</span></li>
[% PROCESS group_and_subgroup_selection %]
[% IF (public) %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0">[% t('No (default)') %]</option> <option value="1" selected="selected">[% t('Yes') %]</option> </select></li>
[% ELSE %]
  <li><label for="public">[% t('Report is public:') %]</label><select id="public" name="public"> <option value="0" selected="selected">[% t('No (default)') %]</option> <option value="1">[% t('Yes') %]</option> </select></li>
[% END %]
[% IF (usecache) %] <li>
<label for="cache_expiry">[% t('Cache expiry:') %]</label><input type="text" id="cache_expiry" name="cache_expiry" value="[% cache_expiry %]"></input>
<select id="cache_expiry_units" name="cache_expiry_units">
<option value="seconds">[% t('Seconds (default)') %]</option>
<option value="minutes">[% t('Minutes') %]</option>
<option value="hours">[% t('Hours') %]</option>
<option value="days">[% t('Days') %]</option>
</select>
</li>[% END %]
<li><label for="notes">[% t('Notes:') %]</label><textarea id="notes" name="notes" cols="50" rows="2">[% notes %]</textarea></li>
</ol>
</fieldset>

<fieldset class="rows">
    <legend>[% t('SQL:') %]</legend>
    <div style="margin:1em;">
        <textarea id="sql" name="sql" class="required" required="required" cols="50" rows="10">[% sql %]</textarea> <span class="required">[% t('Required') %]</span>
    </div>
</fieldset>

<fieldset class="action">
<input type="submit" name="submit" value="Update SQL" /> <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved" class="cancel">[% t('Cancel') %]</a>
</fieldset>
</form>


[% IF ( errors ) %]
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<div class="dialog alert">
<b>[% t('The following error was encountered:') %]</b><br />
[% FOREACH error IN errors %]
    [% IF ( error.sqlerr ) %][% t('This report contains the SQL keyword') %] <b>[% error.sqlerr %]</b>.
    <br />[% t('Use of this keyword is not allowed in Koha reports due to security and data integrity risks. Only SELECT queries are allowed.') %]
    <br />[% t('Please return to the &#34;Saved Reports&#34; screen and delete this report or retry creating a new one.') %]
    [% ELSIF ( error.queryerr ) %][% t('The database returned the following error:') %] <br />[% error.queryerr %]<br />[% t('Please check the log for further details.') %]
    [% ELSIF ( error.cache_expiry ) %][% t('Please select a cache expiry less than 30 days.') %]
    [% ELSE %]
    [% END %]
    <div id="onerror_actions">
        <a href="#" class="button goback">[% t('Return to previous page') %]</a>
    </div>
[% END %]
</div>

  <input type="hidden" name="phase" value="Use saved" />
  <input type="hidden" name="filter_set" value="1" />
  <fieldset class="brief">
  <h3>[% t('Filter') %]</h3>
  <ol>
    <li><label for="filter_date">[% t('Date:') %]</label> <input type="text" id="filter_date" name="filter_date" size="10" value="[% filters.date %]" class="datepicker" />
    <div class="hint">[% INCLUDE 'date-format.inc' %]</div>

    </li>
    <li><label for="filter_author">[% t('Author:') %]</label> <input type="text" id="filter_author" name="filter_author" value="[% filters.author %]" size="16" /></li>
    <li><label for="filter_keyword">[% t('Keyword:') %]</label> <input type="text" id="filter_keyword" name="filter_keyword" value="[% filters.keyword %]" size="16" /></li>
  </ol>
  </fieldset>
  <fieldset class="action">
    <input type="submit" value="Apply filter" />
    <a id="resetReportsFilter" href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved&clear_filters=1">[% t('Clear') %]</a>
  </fieldset>
</form>
</div>


[% BLOCK group_and_subgroup_selection %]
    <li id="group">
        <label>[% t('Report group:') %]</label>
        <input type="radio" name="select_or_create_group" id="select_group" checked="checked" />
        <label for="select_group" style="float:none">[% t('Select') %]</label>
        <label for="select_group" style="float:none">Select</label>
        <select name="group" id="group_select">
            <option value="">[% t('(None)') %]</option>
            [% FOREACH group IN groups_with_subgroups %]
                [% IF (group.selected) %]
                    <option value="[% group.id %]" selected="selected">

            [% END %]
        </select>
        <input type="radio" name="select_or_create_group" id="create_group" />
        <label for="create_group" style="float:none">[% t('or create:') %]</label>
        <input type="text" name="group" id="group_input" title="[% t('Group code') %]" placeholder="[% t('Code') %]" />
        <input type="text" name="groupdesc" id="groupdesc_input" title="[% t('Group name') %]" placeholder="[% t('Name') %]" />
    </li>
    <li id="subgroup">
        <label>[% t('Report subgroup:') %]</label>
        <input type="radio" name="select_or_create_subgroup" id="select_subgroup" checked="checked" />
        <label for="select_subgroup" style="float:none">[% t('Select') %]</label>
        <label for="select_subgroup" style="float:none">Select</label>
        <select name="subgroup" id="subgroup_select">
            <option value="">[% t('(None)') %]</option>
            [% FOREACH group IN groups_with_subgroups %]
                [% IF (group.selected) %]
                    [% FOREACH subgroup IN group.subgroups %]

                [% END %]
            [% END %]
        </select>
        <input type="radio" name="select_or_create_subgroup" id="create_subgroup" />
        <label for="create_subgroup" style="float:none">[% t('or create') %]</label>
        <input type="text" name="subgroup" id="subgroup_input" title="[% t('Subgroup code') %]" placeholder="[% t('Code') %]" />
        <input type="text" name="subgroupdesc" id="subgroupdesc_input" title="[% t('Subgroup name') %]" placeholder="[% t('Name') %]" />
        <input type="text" name="subgroupdesc" id="subgroupdesc_input" title="Subgroup name" placeholder="Name" />
    </li>
[% END %]




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Average loan time') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>


[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/issues_avg_stats.pl">[% t('Average loan time') %]</a> [% t('› Results') %] [% ELSE %][% t('› Average loan time') %][% END %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
	[% FOREACH mainloo IN mainloop %]
        <h1>[% t('Average checkout period') %]</h1>
		[% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
			[% FOREACH loopfilte IN mainloo.loopfilter %]
					<p>[% IF ( loopfilte.err ) %]  [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %]  [% END %]</p>
			[% END %]

				[% FOREACH loopco IN mainloo.loopcol %]
					<th>[% loopco.coltitle %]</th>
				[% END %]
				<th>[% t('TOTAL') %]</th>
			</tr>
				[% FOREACH loopro IN mainloo.looprow %]
					<tr>

					</tr>
				[% END %]
				<tr>
					<th>[% t('TOTAL') %]</th>
					[% FOREACH loopfoote IN mainloo.loopfooter %]
						<th>
							[% loopfoote.totalcol %]


	<form method="post" action="/cgi-bin/koha/reports/issues_avg_stats.pl">
	<fieldset class="rows">
	<legend>[% t('Average checkout period statistics') %]</legend>
	<table>
		<thead>
			<tr>
			<th>[% t('Title') %]</th>
			<th>[% t('Row') %]</th>
			<th>[% t('Column') %]</th>
			<th>[% t('Filter') %]</th>
			</tr>
		</thead>
		<tbody>
			<tr class="hilighted">
				<td>[% t('Checkout date') %]</td>
				<td><input type="radio" name="Line" value="timestamp" /></td>
				<td><input type="radio" name="Column" value="timestamp" /></td>
				<td> <label for="from">[% t('From') %]</label> <input type="text" size="10" id="from" name="Filter" />
					<label for="to">[% t('To') %]</label> <input size="10" id="to" name="Filter" value="" type="text" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
				</td>
			</tr>
			<tr class="hilighted"> 
				<td> </td>
				<td colspan="2">[% t('by') %] <select name="IssueDisplay">
					<option value=""> </option>
					<option value="1">[% t('Day') %]</option>
					<option value="2">[% t('Month') %]</option>
					<option value="3">[% t('Year') %]</option>
					</select>
					
				</td>
				<td><!--Preparing Month and Day Selection--><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
			</tr>
			<tr>
				<td>[% t('Returns') %]</td>
				<td><input type="radio" name="Line" value="returndate" /></td>
				<td><input type="radio" name="Column" value="returndate" /></td>
				<td> <label for="fromRO">[% t('From') %]</label> <input type="text" size="10" id="fromRO" name="Filter" />
					<label for="toRO">[% t('To') %]</label> <input type="text" size="10" id="toRO" name="Filter" value="" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
				</td>
			</tr>
			<tr> 
				<td> </td>
				<td colspan="2">[% t('by') %] <select name="ReturnDisplay">
					<option value=""> </option>
					<option value="1">[% t('Day') %]</option>
					<option value="2">[% t('Month') %]</option>
					<option value="3">[% t('Year') %]</option>
					</select>
					
				</td>
				<td><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
			</tr>
			<tr class="hilighted">
				<td>[% t('Patron category') %]</td>
				<td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
				<td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
                <td>

                </td>
			</tr>
			<tr>
				<td>[% t('Item type') %]</td>
				<td><input type="radio" name="Line" value="itemtype" /></td>
				<td><input type="radio" name="Column" value="itemtype" /></td>
                <td>

                </td>
			</tr>
			<tr class="hilighted">
				<td>[% t('Library') %]</td>
				<td><input type="radio" name="Line" value="branchcode" /></td>
				<td><input type="radio" name="Column" value="branchcode" /></td>
                <td>

			</tr>
			[% IF ( hassort1 ) %]
				<tr class="hilighted"> 
					<td>[% t('Sort1') %]</td>
					<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
					<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
                    <td>

			[% END %]
			[% IF ( hassort2 ) %]
				[% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %] 
					<td>[% t('Sort2') %]</td>
					<td><input type="radio" name="Line" value="borrowers.sort2" /></td>
					<td><input type="radio" name="Column" value="borrowers.sort2" /></td>
                    <td>

	
	
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %] </label>
            <select name="MIME" size="1" id="MIME">
                <option value="CSV">[% t('CSV') %]</option>
            </select>
            <select name="sep" id="sep" size="1">
            [% FOREACH value IN CGIsepChoice.values.sort() %]




[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Circulation statistics') %] [% IF ( do_it ) %][% t('› Results') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">
	.sql {display:none;}

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/issues_stats.pl">[% t('Circulation statistics') %]</a> [% t('› Results') %] [% ELSE %][% t('› Circulation statistics') %][% END %]</div>

<div id="doc3" class="yui-t2">



[% IF ( do_it ) %]
    [% FOREACH mainloo IN mainloop %]
        <h1>[% t('Circulation statistics') %]</h1>
        [% IF ( mainloo.loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
            <ul>
            [% FOREACH loopfilte IN mainloo.loopfilter %]
                [% IF ( loopfilte.err ) %]
                    <li class="error">[% t('Error:') %]
                [% ELSIF ( loopfilte.sql ) %]
                    <li class="sql">
                [% ELSE %]
                    <li>
                [% END %]
                [% SWITCH loopfilte.crit %]
                    [% CASE 0 %][% t('Period From') %]
                    [% CASE 1 %][% t('Period To') %]
                    [% CASE 2 %][% t('Patron Category =') %]
                    [% CASE 3 %][% t('Item Type =') %]
                    [% CASE 4 %][% t('Issuing library =') %]
                    [% CASE 5 %][% t('Collection =') %]
                    [% CASE 6 %][% t('Location =') %]
                    [% CASE 7 %][% t('Item call number &gt;=') %]
                    [% CASE 8 %][% t('Item call number &lt;') %]
                    [% CASE 9 %][% t('Patron sort1 =') %]
                    [% CASE 10 %][% t('Patron sort2 =') %]
                    [% CASE 11 %][% t('Home library =') %]
                    [% CASE 12 %][% t('Holding library =') %]
                    [% CASE 13 %][% t('Patron library =') %]
                    [% CASE 14 %][% t('Issuing library =') %]
                    [% CASE %][% loopfilte.crit %] =
                [% END %]
                [% loopfilte.filter %]

                [% FOREACH loopco IN mainloo.loopcol %]
                    <th>[% loopco.coltitle_display |html %]</th>
                [% END %]
                <th>[% t('TOTAL') %]</th>
                </tr>
                [% FOREACH loopro IN mainloo.looprow %]
                    <tr>

                    </tr>
                [% END %]
            <tr>
                <th>[% t('TOTAL') %]</th>
                [% FOREACH loopfoote IN mainloo.loopfooter %]
                <th>[% loopfoote.totalcol %]</th>
                [% END %]


    <form method="post" action="/cgi-bin/koha/reports/issues_stats.pl">
    <fieldset class="rows">
	<legend>[% t('Circulation statistics') %]</legend><table>
        <thead>
            <tr>
                <th>[% t('Title') %]</th>
                <th>[% t('Row') %]</th>
                <th>[% t('Column') %]</th>
                <th>[% t('Filter') %]</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td>[% t('Period') %]</td>
                <td><input type="radio" name="Line" value="datetime" /></td>
                <td><input type="radio" name="Column" value="datetime" /></td>
                <td><label for="from">[% t('From') %]</label> <input type="text" size="10" id="from" name="Filter" class="datepickerfrom" />
                    <label for="to">[% t('To') %]</label> <input size="10" id="to" name="Filter" value="" type="text" class="datepickerto" />
                    <span class="hint">[% INCLUDE 'date-format.inc' %]</span>
                    </td>
                </tr>
            <tr>
                <td><label for="PeriodTypeSel">[% t('Type:') %]</label><select name="PeriodTypeSel" id="PeriodTypeSel">
                    <option value="issue">[% t('Checkout') %]</option>
                    <option value="renew">[% t('Renewal') %]</option>
                    <option value="return">[% t('Checkin') %]</option>
                    <option value="localuse">[% t('Local Use') %]</option>
                    </select></td>
                <td colspan="2"><label for="DisplayBy">[% t('group by') %]</label> <select name="DisplayBy" id="DisplayBy">
                    <option value="">[% t('None') %]</option>
                    <option value="4">[% t('Hour') %]</option>
                    <option value="1">[% t('Day of week') %]</option>
                    <option value="2">[% t('Month') %]</option>
                    <option value="3">[% t('Year') %]</option>
                    </select>
                </td>
                <td>
                    <label for="PeriodDaySel">[% t('Select day:') %] </label><select name="PeriodDaySel" id="PeriodDaySel">
                    <option value=""></option>
                    <option value="Monday">[% t('Monday') %]</option>
                    <option value="Tuesday">[% t('Tuesday') %]</option>
                    <option value="Wednesday">[% t('Wednesday') %]</option>
                    <option value="Thursday">[% t('Thursday') %]</option>
                    <option value="Friday">[% t('Friday') %]</option>
                    <option value="Saturday">[% t('Saturday') %]</option>
                    <option value="Sunday">[% t('Sunday') %]</option>
                    </select>
                    <label for="PeriodMonthSel">[% t('Select month:') %]</label> <select name="PeriodMonthSel" id="PeriodMonthSel">
                    <option value=""></option>
                    <option value="January">[% t('January') %]</option>
                    <option value="February">[% t('February') %]</option>
                    <option value="March">[% t('March') %]</option>
                    <option value="April">[% t('April') %]</option>
                    <option value="May">[% t('May') %]</option>
                    <option value="June">[% t('June') %]</option>
                    <option value="July">[% t('July') %]</option>
                    <option value="August">[% t('August') %]</option>
                    <option value="September">[% t('September') %]</option>
                    <option value="October">[% t('October') %]</option>
                    <option value="November">[% t('November') %]</option>
                    <option value="December">[% t('December') %]</option>
                    </select>
                </td>
        </tr>
        <tr>
            <td>[% t('Patron category') %]</td>
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
           <td><select name="Filter" id="borcat">

             </td> 
        </tr>
        <tr>
            <td>[% t('Item type') %]</td>
            <td><input type="radio" name="Line" value="itemtype" /></td>
            <td><input type="radio" name="Column" value="itemtype" /></td>
           <td><select name="Filter" id="itemtype">

             </td> 
        </tr>
        <tr>
            <td>[% t('Issuing library') %]</td>
            <td><input type="radio" name="Line" value="branch" /></td>
            <td><input type="radio" name="Column" value="branch" /></td>
            <td><select name="Filter" id="branch">

             </td> 
        </tr>
        <tr>
            <td>[% t('Collection') %]</td>
            <td><input type="radio" name="Line" value="items.ccode" /></td>
            <td><input type="radio" name="Column" value="items.ccode" /></td>
            <td><select name="Filter" id="ccode">
                <option value=""> </option>

            </td>
        </tr>
        <tr>
            <td>[% t('Shelving location') %]</td>
            <td><input type="radio" name="Line" value="items.location" /></td>
            <td><input type="radio" name="Column" value="items.location" /></td>
            <td><select name="Filter" id="location">

            </td> 
        </tr>
        <tr>
            <td>[% t('Item call number') %]</td>
            <td></td>
            <td></td>
            <td>[% t('From') %] <input type="text" name="Filter" size="10" /> [% t('(inclusive) to') %] <input type="text" name="Filter" size="10" /> [% t('(exclusive)') %] </td>
        </tr>
        [% IF ( hassort1 ) %]
        <tr><td>[% t('Patron sort 1') %]</td>
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
			<td><select name="Filter" id="sort1">
               <option value=""> </option>
               [% FOREACH Bsort IN Bsort1 %]
                <option value="[% Bsort.authorised_value %]">[% Bsort.lib %]</option>
               [% END %]
               </select>
            </td> 
        </tr>
        [% END %]
        [% IF ( hassort2 ) %]
        <tr><td>[% t('Patron sort 2') %]</td>
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
           	<td><select name="Filter" id="sort2">
               <option value=""> </option>
               [% FOREACH Bsort IN Bsort2 %]
                   <option value="[% Bsort.authorised_value %]">[% Bsort.lib %]</option>
               [% END %]
               </select>
            </td> 
        </tr>
        [% END %]
        <tr><td>[% t('Home library') %]</td>
            <td><input type="radio" name="Line" value="items.homebranch" /></td>
            <td><input type="radio" name="Column" value="items.homebranch" /></td>
            <td><select name="Filter" id="homebranch">

            </td>
        </tr>

        <tr><td>[% t('Holding library') %]</td>
            <td><input type="radio" name="Line" value="items.holdingbranch" /></td>
            <td><input type="radio" name="Column" value="items.holdingbranch" /></td>
            <td><select name="Filter" id="holdingbranch">

            </td>
        </tr>
        <tr>
            <td>[% t('Patron library') %]</td>
            <td><input type="radio" name="Line" value="borrowers.branchcode" /></td>
            <td><input type="radio" name="Column" value="borrowers.branchcode" /></td>
            <td>
                <select name="Filter" id="patronbranch">
                    <option value=""> </option>
                    [% FOREACH branch IN branchloop %]
                        <option value="[% branch.value %]">
                            [% branch.branchname %]

        </tr>
        [% IF (attribute_types_by_class.keys.size) %]
            <tr>
                <th colspan="4">[% t('Patron attributes') %]</th>
            </tr>
            [% FOREACH class IN attribute_types_by_class.keys.sort %]
                [% IF (class) %]

                        <td>
                            [% IF attr_type.authorised_value_category %]
                                <select name="Filter_borrower_attributes.[% attr_type.code %]">
                                    <option value=""> </option>
                                    [% FOREACH av IN attr_type.authorised_values %]
                                        <option value="[% av.authorised_value %]">
                                            [% av.lib %]

    </table><br /></fieldset>

<fieldset class="rows">
    <legend>[% t('Cell value') %]</legend>
    <ol>
        <li>
            <label for="cellvalue1">[% t('Count total items:') %]</label>
            <input type="radio" name="Cellvalue" value="1" id="cellvalue1" checked="checked" />
        </li>
        <li>
            <label for="cellvalue3">[% t('Count unique items:') %]</label>
            <input type="radio" name="Cellvalue" id="cellvalue3" value="3" />
        </li>
        <li>
            <label for="cellvalue5">[% t('Count unique biblios:') %]</label>
            <input type="radio" name="Cellvalue" id="cellvalue5" value="5" />
        </li>
    </ol>
</fieldset>
			
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE AuthorisedValues %]
[% USE Branches %]

[% USE ItemTypes %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Lost items') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
[% Asset.css("css/datatables.css") %]
</head>

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>[% IF ( get_items ) %] › <a href="/cgi-bin/koha/reports/itemslost.pl">[% t('Lost items') %]</a> [% t('› Results') %][% ELSE %] [% t('› Lost items') %][% END %]</div>

<div id="doc3" class="yui-t2">
   

	<div id="yui-main">
	<div class="yui-b">

<h1>[% t('Lost items') %]</h1>

[% IF ( get_items ) %]

<div class="results">
    [% IF items.count%]
        [% items.count %] [% t('lost items found') %]
    [% ELSE %]
        [% t('No lost items found') %]
    [% END %]
</div>

    [% IF items.count %]
        <div class="lostitems-table_table_controls">
                | <a href="#" class="SelectAll"><i class="fa fa-check"></i> [% t('Select all') %]</a> |
                <a href="#" class="ClearAll"><i class="fa fa-remove"></i> [% t('Clear all') %]</a>
                <span class="itemselection_actions">
                  [% t('| Actions:') %]
                  [% IF csv_profiles.count %]
                      <a class="itemselection_action_export"><i class="fa fa-download"></i> [% t('Export selected items') %]</a>
                      [% t('Using the following CSV profile:') %]
                      <select name="csv_profile_id" id="csv_profile_id">
                          [% FOREACH csv_profile IN csv_profiles %]
                              <option value="[% csv_profile.export_format_id %]">[% csv_profile.profile %]<!--<option-->
                          [% END %]
                      </select>
                  [% ELSE %]
                      <span class="itemselection_action_export" title="[% t('You should create a CSV profile for export_lost_items') %]"><i class="fa fa-download"></i> [% t('Export selected items') %]</a>
                  [% END %]
                </span>
        </div>

            <thead>
                <tr>
                    <th class="NoSort"></th>
                    <th>[% t('Title') %]</th>
                    <th>[% t('Author') %]</th>
                    <th>[% t('Lost status') %]</th>
                    <th class="title-string">[% t('Lost on') %]</th>
                    <th>[% t('Barcode') %]</th>
                    <th>[% t('Call number') %]</th>
                    <th class="title-string">[% t('Date last seen') %]</th>
                    <th>[% t('Price') %]</th>
                    <th>[% t('Rep.price') %]</th>
                    <th>[% t('Library') %]</th>
                    <th>[% t('Item type') %]</th>
                    <th>[% t('Current location') %]</th>
                    <th>[% t('Location') %]</th>
                    <th>[% t('Not for loan status') %]</th>
                    <th>[% t('Notes') %]</th>
                </tr>
            </thead>
            <tbody>

    <fieldset class="rows">
        <ol>

	<li><label for="barcodefilter">[% t('Barcode:') %] </label><input type="text" name="barcodefilter" id="barcodefilter" size="6" /></li>
	<li><label for="branchfilter">[% t('Library:') %] </label><select name="branchfilter" id="branchfilter">
                <option value="">[% t('All') %]</option>
                [% PROCESS options_for_libraries libraries => Branches.all() %]
            </select></li>
    <li><label for="itemtypesfilter">[% t('Item type:') %] </label><select name="itemtypesfilter" id="itemtypesfilter">
                <option value="">[% t('All') %]</option>
                [% FOREACH itemtype IN itemtypes %]
                    <option value="[% itemtype.itemtype  %]">[% itemtype.translated_description %]</option>
                [% END %]
            </select></li>

    <li>
        <label for="loststatusfilter">[% t('Lost status:') %] </label>
        <select name="loststatusfilter" id="loststatusfilter">
            <option value="">[% t('All') %]</option>
            [% FOREACH l IN AuthorisedValues.GetDescriptionsByKohaField( kohafield => 'items.itemlost') %]
                [% IF l.authorised_value == lostfilter %]
                    <option value="[% l.authorised_value %]" selected="selected">[% l.lib %]</option>

    </li>

    <li>
        <label for="notforloanfilter">[% t('Not for loan:') %] </label>
        <select name="notforloanfilter" id="notforloanfilter">
            <option value="">[% t('All') %]</option>
            [% FOREACH n IN AuthorisedValues.GetDescriptionsByKohaField( kohafield => 'items.notforloan') %]
                [% IF n.authorised_value == notforloanfilter %]
                    <option value="[% n.authorised_value %]" selected="selected">[% n.lib %]</option>

    [% INCLUDE 'columns_settings.inc' %]
    [% Asset.js("js/table_filters.js") %]
    [% Asset.js("lib/jquery/plugins/jquery.checkboxes.min.js") %]
    <script type="text/javascript">
        $(document).ready(function() {
            var columns_settings = [% ColumnsSettings.GetColumns( 'reports', 'lostitems', 'lostitems-table', 'json' ) %];
            var lostitems_table = KohaTable("lostitems-table", {




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE Branches %]
[% USE ItemTypes %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Catalog by item types') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
[% IF ( do_it ) %]
[% Asset.css("css/datatables.css") %]

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>[% IF ( do_it ) %] › <a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">[% t('Catalog by item type') %]</a> [% t('› Results') %][% ELSE %] [% t('› Catalog by item type') %][% END %]</div>

<div id="doc3" class="yui-t2">
   


[% IF ( do_it ) %]
[% FOREACH mainloo IN mainloop %]
    <h1>[% t('Reports on item types') %] [% IF branch %] [% t('held at') %] [% Branches.GetName( branch ) %][% END %]</h1>
	<table id="itemtypest">
		<thead>
		<tr>
			<th>[% t('Item type') %]</th>
			<th>[% t('Count') %]</th>
		</tr>
		</thead>
		<tfoot>
			<tr>
				<th>[% t('TOTAL') %]</th>
				<th>[% mainloo.total %]</th>
			</tr>
		</tfoot>

	</table>
[% END %]
[% ELSE %]
        <h3>[% t('View a count of items held at your library grouped by item type') %]</h3>
        <form method="post" action="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">
          <fieldset class="rows">
            <ol>
              <li>
                <label for="value">[% t('Select a library:') %]</label>
                <select name="value" size="1" id="value">
                  <option value=""></option>
                  [% PROCESS options_for_libraries libraries => Branches.all() %]
                </select>
                <span class="tip">[% t('Select none to see all libraries') %]</span>
              </li>
            </ol>
          </fieldset>




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE Price %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Orders by fund') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>
<body id="rep_orders_by_budget" class="rep">

[% INCLUDE 'cat-search.inc' %]

[% Asset.css("css/datatables.css") %]
<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>[% IF ( get_orders ) %] › <a href="/cgi-bin/koha/reports/orders_by_fund.pl">[% t('Orders by fund') %]</a> [% t('› Results') %][% ELSE %] [% t('› Orders by fund') %][% END %]</div>

<div id="doc3" class="yui-t2">


        <div id="yui-main">
        <div class="yui-b">

[% IF ( current_budget_name ) %]<h1>[% t('Orders for fund \'') %][% current_budget_name %]'</h1>
[% ELSE %]<h1>[% t('Orders by fund') %]</h1>
[% END %]

[% IF ( get_orders ) %]
    <div class="results">
        [% IF ( total ) %]
            [% t('Orders found:') %] [% total %]
        [% ELSE %]
            [% t('No order found') %]
        [% END %]
    </div>

    [% IF ( ordersloop ) %]<table id="funds">
        <thead>
        <tr>
        <th>[% t('Fund') %]</th>
        <th>[% t('Basket') %]</th>
        <th>[% t('Basket name') %]</th>
        <th>[% t('Basket by') %]</th>
        <th>[% t('Title') %]</th>
        <th>[% t('Currency') %]</th>
        <th>[% t('List price') %]</th>
        <th>[% t('RRP') %]</th>
        <th>[% t('Budgeted cost') %]</th>
        <th>[% t('Quantity') %]</th>
        <th>[% t('Total RRP') %]</th>
        <th>[% t('Total cost') %]</th>
        <th>[% t('Entry date') %]</th>
        <th>[% t('Date received') %]</th>
        <th>[% t('Internal note') %]</th>
        <th>[% t('Vendor note') %]</th>
        </tr>
        </thead>
        <tbody>

            </tr>
        [% END %]
        </tbody>
        <tfoot><tr><th>[% t('TOTAL') %]</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>[% total_quantity  %]</th><th>[% total_rrp | $Price %]</th><th>[% total_ecost | $Price %]</th><th></th><th></th><th></th><th></th></tr></tfoot>
        </table>
    [% END %]
    [% ELSE %]
        <form name="f" action="/cgi-bin/koha/reports/orders_by_fund.pl" method="post">
        <fieldset class="rows">
        <legend>[% t('Filters') %]</legend>
        <ol><li><label for="budgetfilter">[% t('Fund:') %] </label>
        <select name="budgetfilter" id="budgetfilter">
            <option value="">[% t('All funds') %]</option>
            <option value="activebudgets">[% t('All active funds') %]</option>
        [% FOREACH budgetsloo IN budgetsloop %]
            [% IF ( budgetsloo.selected ) %]
                <option value="[% budgetsloo.value %]" selected="selected">

                [% bdgclass=budgetsloo.active? "": "b_inactive" %]
                    <option class="[% bdgclass %]" value="[% budgetsloo.value %]">
            [% END %]
            [% budgetsloo.description %] [% IF !budgetsloo.active %][% t('(inactive)') %][% END %]
            </option>
        [% END %]
        </select>
        <label for="showallbudgets" style="float:none;">[% t(' Show inactive:') %]</label>
        <input type="checkbox" id="showbudgets" />
        </li></ol>
        </fieldset>

        <fieldset class="rows">
        <legend>[% t('Output') %]</legend>
        <ol><li><label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /> </li>
            <li><label for="outputfile">[% t('To a file:') %]</label>
                <input type="radio" name="output" value="file" id="outputfile" />
                <label class="inline" for="basename">[% t('Named:') %] </label>
                <input type="text" name="basename" id="basename" value="Export" />
                <label class="inline" for="MIME">[% t('Into an application') %] </label>
                <select id="MIME" name="MIME" size="1">
                [% FOREACH outputFormatloo IN outputFormatloop %]
                    <option value="[% outputFormatloo %]">[% outputFormatloo %]</option>
                [% END %]
                </select>
                <select id="sep" name="sep" size="1">
                [% FOREACH delimiterloo IN delimiterloop %]
                    [% IF delimiterloo == delimiterPreference %]
                        <option value="[% delimiterloo %]">[% delimiterloo %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Koha %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
</head>
<body id="rep_reports-home" class="rep">
[% INCLUDE 'header.inc' %]
[% INCLUDE 'circ-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> [% t('› Reports') %]</div>

<div class="main container-fluid">
    <div class="row">

                    [% IF ( CAN_user_reports_execute_reports || CAN_user_reports_create_reports ) %]
                        <form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">
                            <fieldset class="brief">
                                <h2>[% t('Guided reports') %]</h2>
                                <input name="phase" value="Use saved" type="hidden">
                                <input name="filter_set" value="1" type="hidden">
                                [% IF ( CAN_user_reports_create_reports ) %]
                                    <p>
                                        <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new"><i class="fa fa-code-fork"></i> [% t('Create guided report') %]</a>
                                    </p>
                                    <p>
                                        <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL"><i class="fa fa-plus"></i> [% t('Create from SQL') %]</a>
                                    </p>
                                [% END %]
                                <p>
                                    <a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved"><i class="fa fa-list"></i> [% t('Use saved') %]</a>
                                </p>
                                <label for="filter_keyword">[% t('Search by keyword:') %]</label> <input id="filter_keyword" name="filter_keyword" value="" size="16" type="text" /> <input value="Search" type="submit" />
                            </fieldset>
                        </form>
                    [% END %]

        <h5>[% t('Reports dictionary') %]</h5>
        <ul>
            <li><a href="/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary">[% t('View dictionary') %]</a></li>
        </ul>

        <h2>[% t('Statistics wizards') %]</h2>
        <ul>
            <li><a href="/cgi-bin/koha/reports/acquisitions_stats.pl">[% t('Acquisitions') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/borrowers_stats.pl">[% t('Patrons') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/catalogue_stats.pl">[% t('Catalog') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/issues_stats.pl">[% t('Circulation') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/serials_stats.pl">[% t('Serials') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/cash_register_stats.pl">[% t('Cash register') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/reserves_stats.pl">[% t('Holds') %]</a></li>
      </ul>

        [% IF UseKohaPlugins %]
            <h2>[% t('Report plugins') %]</h2>
            <ul>
                <li><a href="/cgi-bin/koha/plugins/plugins-home.pl?method=report">[% t('Report plugins') %]</a></li>
            </ul>
        [% END %]

    </div>

    <div class="col-xs-6"><h2>[% t('Top lists') %]</h2>
        <ul>
            <li><a href="/cgi-bin/koha/reports/bor_issues_top.pl">[% t('Patrons with the most checkouts') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/cat_issues_top.pl">[% t('Most-circulated items') %]</a></li>
        </ul>

        <h2>[% t('Inactive') %]</h2>
        <ul>
                <li><a href="/cgi-bin/koha/reports/borrowers_out.pl">[% t('Patrons who haven\'t checked out') %]</a></li>
                <li><a href="/cgi-bin/koha/reports/catalogue_out.pl">[% t('Items with no checkouts') %]</a></li>
        </ul>

        <h2>[% t('Other') %]</h2>
        <ul>
            <li><a href="/cgi-bin/koha/reports/itemslost.pl">[% t('Items lost') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/orders_by_fund.pl">[% t('Orders by fund') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">[% t('Catalog by item type') %]</a></li>
            <li><a href="/cgi-bin/koha/reports/issues_avg_stats.pl">[% t('Average loan time') %]</a></li>
            <li><a href="http://schema.koha-community.org/" target="blank">[% t('Koha database schema') %]</a></li>
            <li><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="blank">[% t('Koha reports library') %]</a></li>
        </ul></div>
</div>





[% PROCESS 'i18n.inc' %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Holds statistics') %] [% IF ( do_it ) %][% t('› Results') %][% END %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">
	.sql {display:none;}

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/reserves_stats.pl">[% t('Holds statistics') %]</a> [% t('› Results') %] [% ELSE %][% t('› Holds statistics') %][% END %]</div>

<div id="doc3" class="yui-t2">



[% IF ( do_it ) %]
    [% IF ( mainloop ) %]
        <h1>[% t('Holds statistics') %]</h1>
        [% IF ( loopfilter ) %]
            <p>[% t('Filtered on:') %]</p>
            <ul>
            [% FOREACH loopfilte IN loopfilter %]
                [% IF ( loopfilte.err ) %]<li class="error">[% t('Error:') %]
				[% ELSIF ( loopfilte.sql ) %]<li class="sql">
				[% ELSE %]<li>
				[% END %]

                [% FOREACH loopco IN mainloo.loopcol %]
                    <th>[% loopco.coltitle_display |html %]</th>
                [% END %]
                <th>[% t('TOTAL') %]</th>
                </tr>
                [% FOREACH loopro IN mainloo.looprow %]
                    <tr>
                        <td>[% loopro.rowtitle_display or "UNKNOWN VALUE" |html %]</td>
                    [% FOREACH loopcel IN loopro.loopcell %]
						<td align="center">
						[% IF ( loopcel.url_complement ) %]<a href="reserves_stats.pl?output=[% loopcel.output %]&[% loopcel.url_complement %]">[% loopcel.value %]</a>[% ELSE %][% loopcel.value %][% END %]
						</td>
                    [% END %]
						<td align="center">[% loopro.totalrow %]</td>
                    </tr>
                [% END %]
            <tr>
                <th>[% t('TOTAL') %]</th>
                [% FOREACH loopfoote IN mainloo.loopfooter %]
                <th>[% loopfoote.totalcol %]</th>
                [% END %]


    <form method="post" action="/cgi-bin/koha/reports/reserves_stats.pl">
    <fieldset class="rows">
	<legend>[% t('Holds statistics') %]</legend><table>
        <thead>
            <tr>
                <th>[% t('Title') %]</th>
                <th>[% t('Row') %]</th>
                <th>[% t('Column') %]</th>
                <th>[% t('Filter') %]</th>
            </tr>
        </thead>
        <tbody>
        	<tr>
                <td>[% t('Hold status') %] </td>
                <td><input type="radio" name="Line" value="reservestatus" /></td>
                <td><input type="radio" name="Column" value="reservestatus" checked="checked" /></td>
                <td>
				<input type="checkbox" name="filter_reservestatus_or_1" value="1" /> [% t('Asked') %]
				<input type="checkbox" name="filter_reservestatus_or_2" value="2" /> [% t('Processing') %]
				<input type="checkbox" name="filter_reservestatus_or_3" value="3" /> [% t('Waiting') %]
				<input type="checkbox" name="filter_reservestatus_or_4" value="4" /> [% t('Satisfied') %]
				<input type="checkbox" name="filter_reservestatus_or_5" value="5" /> [% t('Cancelled') %]
				</td>
             </tr>
             <tr>
                <td>[% t('Hold date') %]</td>
                <td><input type="radio" name="Line" value="reservedate" /></td>
                <td><input type="radio" name="Column" value="reservedate" /></td>
                <td><label for="filter_reservedate_begin">[% t('From') %]</label> <input type="text" size="10" id="filter_reservedate_begin" name="filter_reservedate_begin" />
                    <label for="filter_reservedate_end">[% t('To') %]</label> <input size="10" id="filter_reservedate_end" name="filter_reservedate_end" value="" type="text" />
                    </td>
                </tr>
            <tr>
                <td>[% t('Notification date') %]</td>
                <td><input type="radio" name="Line" value="notificationdate" /></td>
                <td><input type="radio" name="Column" value="notificationdate" /></td>
                <td><label for="filter_notificationdate_begin">[% t('From') %]</label> <input type="text" size="10" id="filter_notificationdate_begin" name="filter_notificationdate_begin" />
                    <label for="filter_notificationdate_end">[% t('To') %]</label> <input size="10" id="filter_notificationdate_end" name="filter_notificationdate_end" value="" type="text" />
                    </td>
             </tr>
            <tr>
                <td>[% t('Reminder date') %]</td>
                <td><input type="radio" name="Line" value="reminderdate" /></td>
                <td><input type="radio" name="Column" value="reminderdate" /></td>
                <td><label for="filter_reminderdate_begin">[% t('From') %]</label> <input type="text" size="10" id="filter_reminderdate_begin" name="Filter" />
                    <label for="filter_reminderdate_end">[% t('To') %]</label> <input size="10" id="filter_reminderdate_end" name="filter_reminderdate_end" value="" type="text" />
                    </td>
             </tr>
            <tr>
                <td>[% t('Waiting date') %]</td>
                <td><input type="radio" name="Line" value="waitingdate" /></td>
                <td><input type="radio" name="Column" value="waitingdate" /></td>
                <td><label for="filter_waitingdate_begin">[% t('From') %]</label> <input type="text" size="10" id="filter_waitingdate_begin" name="filter_waitingdate_begin" />
                    <label for="filter_waitingdate_end">[% t('To') %]</label> <input size="10" id="filter_waitingdate_end" name="filter_waitingdate_end" value="" type="text" />
                    </td>
             </tr>
			 <tr>
                <td>[% t('Cancellation date') %]</td>
                <td><input type="radio" name="Line" value="cancellationdate" /></td>
                <td><input type="radio" name="Column" value="cancellationdate" /></td>
                <td><label for="filter_cancellationdate_begin">[% t('From') %]</label> <input type="text" size="10" id="filter_cancellationdate_begin" name="filter_cancellationdate_begin" />
                    <label for="filter_cancellationdate_end">[% t('To') %]</label> <input size="10" id="filter_cancellationdate_end" name="filter_cancellationdate_end" value="" type="text" />
                    </td>
             </tr>
        <tr>
            <td>[% t('Patron category') %]</td>
            <td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
            <td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
           <td><select name="filter_categorycode" id="borcat">

             </td> 
        </tr>
        <tr>
            <td>[% t('Item type') %]</td>
            <td><input type="radio" name="Line" value="items.itype" /></td>
            <td><input type="radio" name="Column" value="items.itype" /></td>
           <td><select name="filter_items.itype" id="itype">

             </td> 
        </tr>
        <tr>
            <td>[% t('Pickup library') %]</td>
            <td><input type="radio" name="Line" value="reserves.branchcode" checked="checked" /></td>
            <td><input type="radio" name="Column" value="reserves.branchcode" /></td>
            <td><select name="filter_reserves.branchcode" id="resbranchcode">

             </td> 
        </tr>
        <tr>
            <td>[% t('Holding library') %]</td>
            <td><input type="radio" name="Line" value="items.holdingbranch" /></td>
            <td><input type="radio" name="Column" value="items.holdingbranch" /></td>
            <td><select name="filter_items.holdingbranch" id="holdingbranch">

             </td> 
        </tr>
        <tr>
            <td>[% t('Home library') %]</td>
            <td><input type="radio" name="Line" value="items.homebranch" /></td>
            <td><input type="radio" name="Column" value="items.homebranch" /></td>
            <td><select name="filter_items.homebranch" id="homebranch">

             </td> 
        </tr>
        <tr>
            <td>[% t('Collection') %]</td>
            <td><input type="radio" name="Line" value="items.ccode" /></td>
            <td><input type="radio" name="Column" value="items.ccode" /></td>
            <td><select name="filter_items.ccode" id="ccode">
                <option value=""> </option>

            </td>
        </tr>
        <tr>
            <td>[% t('Shelving location') %]</td>
            <td><input type="radio" name="Line" value="items.location" /></td>
            <td><input type="radio" name="Column" value="items.location" /></td>
            <td><select name="filter_items.location" id="location">

            </td> 
        </tr>
        <tr>
            <td>[% t('Item call number') %]</td>
            <td></td>
            <td></td>
            <td>[% t('From') %] <input type="text" name="filter_items.itemcallnumber_begin" size="10" /> [% t('(inclusive) to') %] <input type="text" name="filter_items.itemcallnumber_endex" size="10" /> [% t('(exclusive)') %] </td>
        </tr>
        [% IF ( hassort1 ) %]
        <tr><td>[% t('Patron sort 1') %]</td>
			<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
			<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
			<td><select name="filter_borrowers.sort1" id="sort1">
               <option value=""> </option>
               [% FOREACH Bsort IN Bsort1 %]
			   [% IF ( Bsort.selected ) %]<option value="[% Bsort.authorised_value %]" selected="selected">[% Bsort.lib %]</option>[% ELSE %]<option value="[% Bsort.authorised_value %]">[% Bsort.lib %]</option>[% END %]
               [% END %]
               </select>
            </td> 
        </tr>
        [% END %]
        [% IF ( hassort2 ) %]
        <tr><td>[% t('Patron sort 2') %]</td>
            <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
            <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
           	<td><select name="filter_borrowers.sort2" id="sort2">
               <option value=""> </option>
               [% FOREACH Bsort IN Bsort2 %]
			   [% IF ( Bsort.selected ) %]<option value="[% Bsort.authorised_value %]" selected="selected">[% Bsort.lib %]</option>[% ELSE %]<option value="[% Bsort.authorised_value %]">[% Bsort.lib %]</option>[% END %]
               [% END %]
               </select>
            </td> 

        </tbody>
    </table><br /></fieldset>

<fieldset class="rows"><legend>[% t('Cell value') %] </legend><ol><li><label for="cellvalue1">[% t('Count holds:') %]</label> <input type="radio" name="Cellvalue" value="1" id="cellvalue1" checked="checked" /> </li>
            <li><label for="cellvalue2">[% t('Count unique borrowers:') %]</label> <input type="radio" name="Cellvalue" value="2" id="cellvalue2" /> </li><li><label for="cellvalue3">[% t('Count unique items:') %]</label> <input type="radio" name="Cellvalue" id="cellvalue3" value="3" /> </li><li><label for="cellvalue4">[% t('Count unique biblios:') %]</label> <input type="radio" name="Cellvalue" id="cellvalue4" value="4" /> </li></ol></fieldset>
			
	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>




[% PROCESS 'i18n.inc' %]
[% USE Asset %]
[% USE KohaDates %]
[% USE Branches %]
[% SET footerjs = 1 %]
[% INCLUDE 'doc-head-open.inc' %]
<title>[% t('Koha › Reports › Serials subscriptions stats') %]</title>
[% INCLUDE 'doc-head-close.inc' %]
<style type="text/css">
	.sql {display: none;}

[% INCLUDE 'header.inc' %]
[% INCLUDE 'cat-search.inc' %]

<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% t('› Serials subscriptions stats') %]</div>

<div id="doc3" class="yui-t2">
   <div id="bd">
	<div id="yui-main">
	<div class="yui-b">

	<h1>[% t('Serials subscriptions') %]</h1>
[% IF ( do_it ) %]
	<table id="resulttable">
		<thead>
			<tr>
				<th>[% t('Vendor') %]</th>
				<th>[% t('Title') %]</th>
				<th>[% t('Subscription id') %]</th>
				<th>[% t('Branch') %]</th>
                <th>[% t('Call number') %]</th>
                <th>[% t('Subscription begin') %]</th>
                <th>[% t('Subscription end') %]</th>
                <th>[% t('Expired? / Closed?') %]</th>
			</tr>
		</thead>
		<tbody>

                    <td><span title="[% data.enddate %]">[% data.enddate | $KohaDates %]</span></td>
                    <td>
                        [% IF data.closed %]
                            [% t('Closed') %]
                        [% ELSIF data.expired %]
                            [% t('Expired') %]
                        [% END %]
                    </td>
				</tr>

			<li>

				<label for="bookseller">
					[% t('Vendor:') %]
			    </label>
				<select name="bookseller" id="bookseller">
                    <option value="">[% t('Any vendor') %]</option>
    				[% FOREACH bookseller IN booksellers %]
						<option value="[% bookseller.aqbooksellerid %]">[% bookseller.name %]</option>
					[% END %]
			    </select>
			</li><li>
                <label for="branchcode">
					[% t('Library:') %]
		    	</label>
		    	<select name="branchcode" id="branchcode">
				<option value="">[% t('Any library') %]</option>
                [% PROCESS options_for_libraries libraries => Branches.all() %]
		    	</select>

		    </li>
		    <li>
		    	<label for="expired">[% t('Include expired subscriptions:') %] </label>
                <input type="checkbox" name="expired" id="expired" />
		    </li>
		</ol>



	<fieldset class="rows">
	<legend>[% t('Output') %]</legend>
    <ol>
        <li>
            <label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
        </li>
        <li>
            <label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
            <label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
            <label class="inline" for="MIME">[% t('Into an application:') %]</label>
            <select name="MIME" id="MIME" size="1">
            [% FOREACH value IN CGIextChoice %]
                <option value="[% value %]">[% value %]</option>
- 

Return to bug 20988

Lines 1-9 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/bor_issues_top.tt (-50 / +51 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Branches %]	2	[% USE Branches %]
2	[% USE KohaDates %]	3	[% USE KohaDates %]
3	[% USE ItemTypes %]	4	[% USE ItemTypes %]
4	[% SET footerjs = 1 %]	5	[% SET footerjs = 1 %]
5	[% INCLUDE 'doc-head-open.inc' %]	6	[% INCLUDE 'doc-head-open.inc' %]
6	<title>Koha &rsaquo; Reports &rsaquo; Patrons with the most checkouts</title>	7	<title>[% t('Koha › Reports › Patrons with the most checkouts') %]</title>
7	[% INCLUDE 'doc-head-close.inc' %]	8	[% INCLUDE 'doc-head-close.inc' %]
8	</head>	9	</head>
9		10
Lines 11-17 Link Here
11	[% INCLUDE 'header.inc' %]	12	[% INCLUDE 'header.inc' %]
12	[% INCLUDE 'cat-search.inc' %]	13	[% INCLUDE 'cat-search.inc' %]
13		14
14	<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/bor_issues_top.pl">Patrons with the most checkouts</a> &rsaquo; Results[% ELSE %]&rsaquo; Patrons with the most checkouts[% END %]</div>	15	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/bor_issues_top.pl">[% t('Patrons with the most checkouts') %]</a> [% t('› Results') %][% ELSE %][% t('› Patrons with the most checkouts') %][% END %]</div>
15		16
16	<div id="doc3" class="yui-t2">	17	<div id="doc3" class="yui-t2">
17		18
Lines 21-54 Link Here
21		22
22	[% IF ( do_it ) %]	23	[% IF ( do_it ) %]
23	[% FOREACH mainloo IN mainloop %]	24	[% FOREACH mainloo IN mainloop %]
24	<h1>Patrons with the most checkouts</h1>	25	<h1>[% t('Patrons with the most checkouts') %]</h1>
25	[% IF ( mainloo.loopfilter ) %]	26	[% IF ( mainloo.loopfilter ) %]
26	[% IF mainloo.loopfilter.size %]	27	[% IF mainloo.loopfilter.size %]
27	<p>Filtered on:</p>	28	<p>[% t('Filtered on:') %]</p>
28	<ul>	29	<ul>
29	[% FOREACH loopfilte IN mainloo.loopfilter %]	30	[% FOREACH loopfilte IN mainloo.loopfilter %]
30	<li>	31	<li>
31	[% SWITCH loopfilte.crit -%]	32	[% SWITCH loopfilte.crit -%]
32	[% CASE "Issue From" -%]	33	[% CASE "Issue From" -%]
33	Checked out after [% loopfilte.filter \| $KohaDates %]	34	[% t('Checked out after') %] [% loopfilte.filter \| $KohaDates %]
34	[% CASE "Issue To" -%]	35	[% CASE "Issue To" -%]
35	Checked out before [% loopfilte.filter \| $KohaDates %]	36	[% t('Checked out before') %] [% loopfilte.filter \| $KohaDates %]
36	[% CASE "Return From" -%]	37	[% CASE "Return From" -%]
37	Checked in after [% loopfilte.filter \| $KohaDates %]	38	[% t('Checked in after') %] [% loopfilte.filter \| $KohaDates %]
38	[% CASE "Return To" -%]	39	[% CASE "Return To" -%]
39	Checked in before [% loopfilte.filter \| $KohaDates %]	40	[% t('Checked in before') %] [% loopfilte.filter \| $KohaDates %]
40	[% CASE "Branch" -%]	41	[% CASE "Branch" -%]
41	Library is [% Branches.GetName( loopfilte.filter ) %]	42	[% t('Library is') %] [% Branches.GetName( loopfilte.filter ) %]
42	[% CASE "Doc Type" -%]	43	[% CASE "Doc Type" -%]
43	Item type is [% ItemTypes.GetDescription( loopfilte.filter ) %]	44	[% t('Item type is') %] [% ItemTypes.GetDescription( loopfilte.filter ) %]
44	[% CASE "Bor Cat" -%]	45	[% CASE "Bor Cat" -%]
45	Patron category code is [% loopfilte.filter %]	46	[% t('Patron category code is') %] [% loopfilte.filter %]
46	[% CASE "Day" -%]	47	[% CASE "Day" -%]
47	Day is [% loopfilte.filter %]	48	[% t('Day is') %] [% loopfilte.filter %]
48	[% CASE "Month" -%]	49	[% CASE "Month" -%]
49	Month is [% loopfilte.filter %]	50	[% t('Month is') %] [% loopfilte.filter %]
50	[% CASE "Year" -%]	51	[% CASE "Year" -%]
51	Year is [% loopfilte.filter %]	52	[% t('Year is') %] [% loopfilte.filter %]
52	[% CASE # default case -%]	53	[% CASE # default case -%]
53	[% loopfilte.crit %] = [% loopfilte.filter %]	54	[% loopfilte.crit %] = [% loopfilte.filter %]
54	[% END -%]	55	[% END -%]
Lines 60-74 Link Here
60		61
61	<table>	62	<table>
62	<tr>	63	<tr>
63	<th rowspan="2">Rank</th>	64	<th rowspan="2">[% t('Rank') %]</th>
64	[% FOREACH loopco IN mainloo.loopcol %]	65	[% FOREACH loopco IN mainloo.loopcol %]
65	<th colspan="2">[% loopco.coltitle %]</th>	66	<th colspan="2">[% loopco.coltitle %]</th>
66	[% END %]	67	[% END %]
67	</tr>	68	</tr>
68	<tr>	69	<tr>
69	[% FOREACH loopco IN mainloo.loopcol %]	70	[% FOREACH loopco IN mainloo.loopcol %]
70	<th>Patron</th>	71	<th>[% t('Patron') %]</th>
71	<th>Checkout count</th>	72	<th>[% t('Checkout count') %]</th>
72	[% END %]	73	[% END %]
73	</tr>	74	</tr>
74	[% FOREACH loopro IN mainloo.looprow %]	75	[% FOREACH loopro IN mainloo.looprow %]
Lines 90-122 Link Here
90	</table>	91	</table>
91	[% END %]	92	[% END %]
92	[% ELSE %]	93	[% ELSE %]
93	<h1>Patrons with the most checkouts</h1>	94	<h1>[% t('Patrons with the most checkouts') %]</h1>
94	<form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">	95	<form method="post" action="/cgi-bin/koha/reports/bor_issues_top.pl">
95	<fieldset class="rows">	96	<fieldset class="rows">
96	<ol><li><label for="from">Checkout date from:</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />	97	<ol><li><label for="from">[% t('Checkout date from:') %]</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
97	<label class="inline" for="to">To: </label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />	98	<label class="inline" for="to">[% t('To:') %] </label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
98	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>	99	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
99	<li> <label for="fromRO">Check-in date from:</label> <input type="text" readonly="readonly" size="10" id="fromRO" name="Filter" />	100	<li> <label for="fromRO">[% t('Check-in date from:') %]</label> <input type="text" readonly="readonly" size="10" id="fromRO" name="Filter" />
100	<label class="inline" for="toRO">To: </label> <input type="text" readonly="readonly" size="10" id="toRO" name="Filter" value="" />	101	<label class="inline" for="toRO">[% t('To:') %] </label> <input type="text" readonly="readonly" size="10" id="toRO" name="Filter" value="" />
101	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>	102	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
102	<li>	103	<li>
103	<label for="branch">Library: </label>	104	<label for="branch">[% t('Library:') %] </label>
104	<select name="Filter" id="branch"><option value="" > Any library</option>	105	<select name="Filter" id="branch"><option value=""> [% t('Any library') %]</option>
105	[% FOREACH l IN Branches.all( unfiltered => 1 ) %]	106	[% FOREACH l IN Branches.all( unfiltered => 1 ) %]
106	<option value="[% l.branchcode %]" >[% l.branchname %] </option>	107	<option value="[% l.branchcode %]">[% l.branchname %] </option>
107	[% END %]	108	[% END %]
108	</select> </li>	109	</select> </li>
109	<li>	110	<li>
110	<label for="documenttype">Item type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>	111	<label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype"><option value=""> [% t('Any item type') %]</option>
111	[% FOREACH itemtype IN itemtypes %]	112	[% FOREACH itemtype IN itemtypes %]
112	<option value="[% itemtype.itemtype %]" >[% itemtype.translated_description %] </option>	113	<option value="[% itemtype.itemtype %]">[% itemtype.translated_description %] </option>
113	[% END %]	114	[% END %]
114	</select>	115	</select>
115	</li>	116	</li>
116	<li>	117	<li>
117	<label for="patroncategory">Patron category: </label><select name="Filter" id="patroncategory"><option value="" > Any category code</option>	118	<label for="patroncategory">[% t('Patron category:') %] </label><select name="Filter" id="patroncategory"><option value=""> [% t('Any category code') %]</option>
118	[% FOREACH patron_category IN patron_categories%]	119	[% FOREACH patron_category IN patron_categories%]
119	<option value="[% patron_category.categorycode %]" >[% patron_category.description %] </option>	120	<option value="[% patron_category.categorycode %]">[% patron_category.description %] </option>
120	[% END %]	121	[% END %]
121	</select>	122	</select>
122	</li>	123	</li>
Lines 125-166 Link Here
125		126
126	<fieldset class="rows">	127	<fieldset class="rows">
127	<ol>	128	<ol>
128	<li><label for="numlimit">Limit to: </label> <select name="Limit" id="numlimit">	129	<li><label for="numlimit">[% t('Limit to:') %] </label> <select name="Limit" id="numlimit">
129	<option value ="5" selected="selected"> 5</option>	130	<option value="5" selected="selected"> [% t('5') %]</option>
130	<option value ="10">10</option>	131	<option value="10">[% t('10') %]</option>
131	<option value ="15">15</option>	132	<option value="15">[% t('15') %]</option>
132	<option value ="20">20</option>	133	<option value="20">[% t('20') %]</option>
133	<option value ="">No limit</option>	134	<option value="">[% t('No limit') %]</option>
134	<!-- <option value ="25">25</option>	135	<!-- <option value ="25">25</option>
135	<option value ="40">40</option>	136	<option value ="40">40</option>
136	<option value ="50">50</option>	137	<option value ="50">50</option>
137	<option value ="100">100</option>-->	138	<option value ="100">100</option>-->
138	</select></li>	139	</select></li>
139	<li><label for="criteria">By: </label> <select name="Criteria" id="criteria">	140	<li><label for="criteria">[% t('By:') %] </label> <select name="Criteria" id="criteria">
140	<option value ="" selected="selected">None</option>	141	<option value="" selected="selected">[% t('None') %]</option>
141	<option value ="branchcode">Library</option>	142	<option value="branchcode">[% t('Library') %]</option>
142	<option value ="categorycode">Category code</option>	143	<option value="categorycode">[% t('Category code') %]</option>
143	<option value ="itemtype">Item type</option>	144	<option value="itemtype">[% t('Item type') %]</option>
144	<option value ="Day">Day</option>	145	<option value="Day">[% t('Day') %]</option>
145	<option value ="Week">Week</option>	146	<option value="Week">[% t('Week') %]</option>
146	<option value ="Month">Month</option>	147	<option value="Month">[% t('Month') %]</option>
147	<option value ="Year">Year</option>	148	<option value="Year">[% t('Year') %]</option>
148	</select></li>	149	</select></li>
149	</ol>	150	</ol>
150	</fieldset>	151	</fieldset>
151		152
152	<fieldset class="rows">	153	<fieldset class="rows">
153	<legend>Output</legend>	154	<legend>[% t('Output') %]</legend>
154	<ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>	155	<ol><li><label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /></li>
155	<li><label for="outputfile">To a file: </label><input type="radio" name="output" value="file" id="outputfile" />	156	<li><label for="outputfile">[% t('To a file:') %] </label><input type="radio" name="output" value="file" id="outputfile" />
156	<label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />	157	<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
157	<label class="inline" for="MIME">Into an application: </label>	158	<label class="inline" for="MIME">[% t('Into an application:') %] </label>
158	<select name="MIME" id="MIME">	159	<select name="MIME" id="MIME">
159	[% FOREACH mimeloo IN mimeloop %]	160	[% FOREACH mimeloo IN mimeloop %]
160	<option value="[% mimeloo.type %]">[% mimeloo.type %]</option>	161	<option value="[% mimeloo.type %]">[% mimeloo.type %]</option>
161	[% END %]	162	[% END %]
162	</select>	163	</select>
163	<label class="inline" for="sep">Delimiter: </label>	164	<label class="inline" for="sep">[% t('Delimiter:') %] </label>
164	<select name="sep" id="sep" size="1">	165	<select name="sep" id="sep" size="1">
165	[% FOREACH value IN CGIseplist.values.sort() %]	166	[% FOREACH value IN CGIseplist.values.sort() %]
166	[% IF ( value == CGIseplist.default ) %]	167	[% IF ( value == CGIseplist.default ) %]

Lines 1-7 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cat_issues_top.tt (-52 / +53 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Branches %]	2	[% USE Branches %]
2	[% SET footerjs = 1 %]	3	[% SET footerjs = 1 %]
3	[% INCLUDE 'doc-head-open.inc' %]	4	[% INCLUDE 'doc-head-open.inc' %]
4	<title>Koha &rsaquo; Reports &rsaquo; Most-circulated items[% IF ( do_it ) %] &rsaquo; Results[% END %]</title>	5	<title>[% t('Koha › Reports › Most-circulated items') %][% IF ( do_it ) %] [% t('› Results') %][% END %]</title>
5	[% INCLUDE 'doc-head-close.inc' %]	6	[% INCLUDE 'doc-head-close.inc' %]
6	</head>	7	</head>
7		8
Lines 9-15 Link Here
9	[% INCLUDE 'header.inc' %]	10	[% INCLUDE 'header.inc' %]
10	[% INCLUDE 'cat-search.inc' %]	11	[% INCLUDE 'cat-search.inc' %]
11		12
12	<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>	13	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> › [% IF ( do_it ) %]<a href="/cgi-bin/koha/reports/cat_issues_top.pl">[% t('Most-circulated items') %]</a> [% t('› Results') %][% ELSE %][% t('Most-Circulated Items') %][% END %]</div>
13		14
14	<div id="doc3" class="yui-t2">	15	<div id="doc3" class="yui-t2">
15		16
Lines 20-43 Link Here
20	[% IF ( do_it ) %]	21	[% IF ( do_it ) %]
21		22
22	[% FOREACH mainloo IN mainloop %]	23	[% FOREACH mainloo IN mainloop %]
23	<h1>Top [% mainloo.limit %] Most-circulated items</h1>	24	<h1>[% t('Top') %] [% mainloo.limit %] [% t('Most-circulated items') %]</h1>
24	[% IF ( mainloo.loopfilter ) %]	25	[% IF ( mainloo.loopfilter ) %]
25	<p>Filtered on:</p>	26	<p>[% t('Filtered on:') %]</p>
26	[% FOREACH loopfilte IN mainloo.loopfilter %]	27	[% FOREACH loopfilte IN mainloo.loopfilter %]
27	<p>[% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter \|html %][% IF ( loopfilte.err ) %] [% END %]</p>	28	<p>[% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter \|html %][% IF ( loopfilte.err ) %] [% END %]</p>
28	[% END %]	29	[% END %]
29	[% END %]	30	[% END %]
30		31
31	<table>	32	<table>
32	<tr> <th>Rank/Biblioitemnumbers</th>	33	<tr> <th>[% t('Rank/Biblioitemnumbers') %]</th>
33	[% FOREACH loopco IN mainloo.loopcol %]	34	[% FOREACH loopco IN mainloo.loopcol %]
34	<th colspan="2">[% loopco.coltitle %]</th>	35	<th colspan="2">[% loopco.coltitle %]</th>
35	[% END %]</tr>	36	[% END %]</tr>
36	<tr>	37	<tr>
37	<th> </th>	38	<th> </th>
38	[% FOREACH loopco IN mainloo.loopcol %]	39	[% FOREACH loopco IN mainloo.loopcol %]
39	<th>Item</th>	40	<th>[% t('Item') %]</th>
40	<th>Count of checkouts</th>	41	<th>[% t('Count of checkouts') %]</th>
41	[% END %]	42	[% END %]
42	</tr>	43	</tr>
43	[% FOREACH loopro IN mainloo.looprow %]	44	[% FOREACH loopro IN mainloo.looprow %]
Lines 67-160 Link Here
67	</table>	68	</table>
68	[% END %]	69	[% END %]
69	[% ELSE %]	70	[% ELSE %]
70	<h1>Most-circulated items</h1>	71	<h1>[% t('Most-circulated items') %]</h1>
71	<form method="post" action="/cgi-bin/koha/reports/cat_issues_top.pl">	72	<form method="post" action="/cgi-bin/koha/reports/cat_issues_top.pl">
72	<fieldset class="rows">	73	<fieldset class="rows">
73	<ol>	74	<ol>
74	<li><label for="from">Checkout date from: </label> <input type="text" size="10" id="from" name="Filter" />	75	<li><label for="from">[% t('Checkout date from:') %] </label> <input type="text" size="10" id="from" name="Filter" />
75	<label for="to" class="inline">To:</label> <input size="10" id="to" name="Filter" value="" type="text" />	76	<label for="to" class="inline">[% t('To:') %]</label> <input size="10" id="to" name="Filter" value="" type="text" />
76	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>	77	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
77	<li><label for="fromRO">Check-in date from</label> <input type="text" size="10" id="fromRO" name="Filter" />	78	<li><label for="fromRO">[% t('Check-in date from') %]</label> <input type="text" size="10" id="fromRO" name="Filter" />
78	<label for="toRO" class="inline">To: </label> <input type="text" size="10" id="toRO" name="Filter" value="" />	79	<label for="toRO" class="inline">[% t('To:') %] </label> <input type="text" size="10" id="toRO" name="Filter" value="" />
79	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>	80	<span class="hint">[% INCLUDE 'date-format.inc' %]</span></li>
80	<li>	81	<li>
81	<label for="branch">Library: </label>	82	<label for="branch">[% t('Library:') %] </label>
82	<select name="Filter" id="branch"><option value="" > Any library</option>	83	<select name="Filter" id="branch"><option value=""> [% t('Any library') %]</option>
83	[% PROCESS options_for_libraries libraries => Branches.all() %]	84	[% PROCESS options_for_libraries libraries => Branches.all() %]
84	</select>	85	</select>
85	</li>	86	</li>
86	<li>	87	<li>
87	<label for="documenttype">Item type: </label><select name="Filter" id="documenttype"><option value="" > Any item type</option>	88	<label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype"><option value=""> [% t('Any item type') %]</option>
88	[% FOREACH itemtype IN itemtypes %]	89	[% FOREACH itemtype IN itemtypes %]
89	<option value="[% itemtype.itemtype %]" >[% itemtype.translated_description %] </option>	90	<option value="[% itemtype.itemtype %]">[% itemtype.translated_description %] </option>
90	[% END %]	91	[% END %]
91	</select>	92	</select>
92	</li>	93	</li>
93	<li>	94	<li>
94	<label for="itemcallnumber">Call number: </label><input type="text" name="Filter" id="itemcallnumber" value="" />	95	<label for="itemcallnumber">[% t('Call number:') %] </label><input type="text" name="Filter" id="itemcallnumber" value="" />
95	</li>	96	</li>
96	<li>	97	<li>
97	<label for="ccode">Collection: </label><select name="Filter" id="ccode"><option value="" > Any collection</option>	98	<label for="ccode">[% t('Collection:') %] </label><select name="Filter" id="ccode"><option value=""> [% t('Any collection') %]</option>
98	[% FOREACH ccodeloo IN ccodeloop %]	99	[% FOREACH ccodeloo IN ccodeloop %]
99	<option value="[% ccodeloo.value %]" >[% ccodeloo.description %] </option>	100	<option value="[% ccodeloo.value %]">[% ccodeloo.description %] </option>
100	[% END %]	101	[% END %]
101	</select>	102	</select>
102	</li>	103	</li>
103	<li>	104	<li>
104	<label for="shelvingloc">Shelving location: </label><select name="Filter" id="shelvingloc"><option value="" > Any shelving location</option>	105	<label for="shelvingloc">[% t('Shelving location:') %] </label><select name="Filter" id="shelvingloc"><option value=""> [% t('Any shelving location') %]</option>
105	[% FOREACH shelvinglocloo IN shelvinglocloop %]	106	[% FOREACH shelvinglocloo IN shelvinglocloop %]
106	<option value="[% shelvinglocloo.value %]" >[% shelvinglocloo.description %] </option>	107	<option value="[% shelvinglocloo.value %]">[% shelvinglocloo.description %] </option>
107	[% END %]	108	[% END %]
108	</select>	109	</select>
109	</li>	110	</li>
110	<li>	111	<li>
111	<label for="patroncategory">Patron category: </label><select name="Filter" id="patroncategory"><option value="" > Any category code</option>	112	<label for="patroncategory">[% t('Patron category:') %] </label><select name="Filter" id="patroncategory"><option value=""> [% t('Any category code') %]</option>
112	[% FOREACH patron_category IN patron_categories %]	113	[% FOREACH patron_category IN patron_categories %]
113	<option value="[% patron_category.categorycode %]" >[% patron_category.description %] </option>	114	<option value="[% patron_category.categorycode %]">[% patron_category.description %] </option>
114	[% END %]	115	[% END %]
115	</select>	116	</select>
116	</li>	117	</li>
117	<li><label for="day">Day: </label> <input type="text" name="Filter" id="day" value="" /></li>	118	<li><label for="day">[% t('Day:') %] </label> <input type="text" name="Filter" id="day" value="" /></li>
118	<li><label for="month">Month: </label> <input type="text" name="Filter" id="month" value="" /></li>	119	<li><label for="month">[% t('Month:') %] </label> <input type="text" name="Filter" id="month" value="" /></li>
119	<li><label for="year">Year: </label> <input type="text" name="Filter" id="year" value="" /></li>	120	<li><label for="year">[% t('Year:') %] </label> <input type="text" name="Filter" id="year" value="" /></li>
120	</ol>	121	</ol>
121	</fieldset>	122	</fieldset>
122		123
123	<fieldset class="rows">	124	<fieldset class="rows">
124	<legend>Limits</legend>	125	<legend>[% t('Limits') %]</legend>
125	<ol><li><label for="numberlimit">Limit to:</label><select name="Limit" id="numberlimit">	126	<ol><li><label for="numberlimit">[% t('Limit to:') %]</label><select name="Limit" id="numberlimit">
126	<option value ="" selected="selected">None</option>	127	<option value="" selected="selected">[% t('None') %]</option>
127	<option value="5" selected="selected"> 5</option>	128	<option value="5" selected="selected"> [% t('5') %]</option>
128	<option value ="10">10</option>	129	<option value="10">[% t('10') %]</option>
129	<option value ="15">15</option>	130	<option value="15">[% t('15') %]</option>
130	<option value ="20">20</option>	131	<option value="20">[% t('20') %]</option>
131	<option value ="25">25</option>	132	<option value="25">[% t('25') %]</option>
132	<option value ="40">40</option>	133	<option value="40">[% t('40') %]</option>
133	<option value ="50">50</option>	134	<option value="50">[% t('50') %]</option>
134	<option value ="100">100</option>	135	<option value="100">[% t('100') %]</option>
135	</select></li>	136	</select></li>
136	<li><label for="criteria">By: </label><select name="Criteria" id="criteria">	137	<li><label for="criteria">[% t('By:') %] </label><select name="Criteria" id="criteria">
137	<option value ="" selected="selected">None</option>	138	<option value="" selected="selected">[% t('None') %]</option>
138	<option value ="branch">Library</option>	139	<option value="branch">[% t('Library') %]</option>
139	<option value ="categorycode">Categorycode</option>	140	<option value="categorycode">[% t('Categorycode') %]</option>
140	<option value ="itemtype">Itemtype</option>	141	<option value="itemtype">[% t('Itemtype') %]</option>
141	<option value ="Day">Day</option>	142	<option value="Day">[% t('Day') %]</option>
142	<option value ="Week">Week</option>	143	<option value="Week">[% t('Week') %]</option>
143	<option value ="Month">Month</option>	144	<option value="Month">[% t('Month') %]</option>
144	<option value ="Year">Year</option>	145	<option value="Year">[% t('Year') %]</option>
145	</select></li></ol>	146	</select></li></ol>
146	</fieldset>	147	</fieldset>
147		148
148	<fieldset class="rows">	149	<fieldset class="rows">
149	<legend>Output</legend>	150	<legend>[% t('Output') %]</legend>
150	<ol>	151	<ol>
151	<li>	152	<li>
152	<label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />	153	<label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
153	</li>	154	</li>
154	<li>	155	<li>
155	<label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" />	156	<label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
156	<label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />	157	<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
157	<label class="inline" for="MIME">Into an application:</label>	158	<label class="inline" for="MIME">[% t('Into an application:') %]</label>
158	<select name="MIME" id="MIME" size="1">	159	<select name="MIME" id="MIME" size="1">
159	[% FOREACH value IN CGIextChoice %]	160	[% FOREACH value IN CGIextChoice %]
160	<option value="[% value %]">[% value %]</option>	161	<option value="[% value %]">[% value %]</option>

Lines 1-6 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/catalogue_out.tt (-37 / +38 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Branches %]	2	[% USE Branches %]
2	[% INCLUDE 'doc-head-open.inc' %]	3	[% INCLUDE 'doc-head-open.inc' %]
3	<title>Koha &rsaquo; Reports &rsaquo; Items with no checkouts</title>	4	<title>[% t('Koha › Reports › Items with no checkouts') %]</title>
4	[% INCLUDE 'doc-head-close.inc' %]	5	[% INCLUDE 'doc-head-close.inc' %]
5	<style type="text/css">	6	<style type="text/css">
6	.sql {display: none;}	7	.sql {display: none;}
Lines 10-16 Link Here
10	[% INCLUDE 'header.inc' %]	11	[% INCLUDE 'header.inc' %]
11	[% INCLUDE 'cat-search.inc' %]	12	[% INCLUDE 'cat-search.inc' %]
12		13
13	<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>	14	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% t('› Items with no checkouts') %]</div>
14		15
15	<div id="doc3" class="yui-t2">	16	<div id="doc3" class="yui-t2">
16	<div id="bd">	17	<div id="bd">
Lines 18-29 Link Here
18	<div class="yui-b">	19	<div class="yui-b">
19		20
20	[% IF ( do_it ) %]	21	[% IF ( do_it ) %]
21	<h1>Items with no checkouts</h1>	22	<h1>[% t('Items with no checkouts') %]</h1>
22	[% FOREACH mainloo IN mainloop %]	23	[% FOREACH mainloo IN mainloop %]
23	[% IF ( mainloo.loopfilter ) %]	24	[% IF ( mainloo.loopfilter ) %]
24	<p>Filtered on:</p>	25	<p>[% t('Filtered on:') %]</p>
25	[% FOREACH loopfilte IN mainloo.loopfilter %]	26	[% FOREACH loopfilte IN mainloo.loopfilter %]
26	[% IF ( loopfilte.err ) %]<p class="error">Error:	27	[% IF ( loopfilte.err ) %]<p class="error">[% t('Error:') %]
27	[% ELSE %]<p>	28	[% ELSE %]<p>
28	[% END %]	29	[% END %]
29	[% IF ( loopfilte.sql ) %]<span class="sql">[% END %]	30	[% IF ( loopfilte.sql ) %]<span class="sql">[% END %]
Lines 34-54 Link Here
34	[% END %]	35	[% END %]
35		36
36	[% IF ( mainloo.looptables ) %]	37	[% IF ( mainloo.looptables ) %]
37	<h3><a name="summary" id="summary"></a>Summary</h3>	38	<h3><a name="summary" id="summary"></a>[% t('Summary') %]</h3>
38	<table id="summary_table">	39	<table id="summary_table">
39	<tr><th>Group</th><th>Call number range</th><th>Number of items displayed</th><th>Total items in group</th>	40	<tr><th>[% t('Group') %]</th><th>[% t('Call number range') %]</th><th>[% t('Number of items displayed') %]</th><th>[% t('Total items in group') %]</th>
40	</tr>	41	</tr>
41	[% FOREACH looptable IN mainloo.looptables %]	42	[% FOREACH looptable IN mainloo.looptables %]
42	<tr><td><a href="#table[% looptable.coltitle %]">[% looptable.coltitle %]</a></td>	43	<tr><td><a href="#table[% looptable.coltitle %]">[% looptable.coltitle %]</a></td>
43	<td>[% IF ( looptable.looptable_count ) %]	44	<td>[% IF ( looptable.looptable_count ) %]
44	[% looptable.looptable_first %] to [% looptable.looptable_last %]	45	[% looptable.looptable_first %] [% t('to') %] [% looptable.looptable_last %]
45	[% END %]	46	[% END %]
46	</td>	47	</td>
47	<td>[% looptable.looptable_count %]</td>	48	<td>[% looptable.looptable_count %]</td>
48	<td>[% looptable.coltitle_count %]</td>	49	<td>[% looptable.coltitle_count %]</td>
49	</tr>	50	</tr>
50	[% END %]	51	[% END %]
51	<tr><th>TOTAL</th><th></th><th>[% mainloo.total_looptable_count %]</th><th>[% mainloo.total_coltitle_count %]</th>	52	<tr><th>[% t('TOTAL') %]</th><th></th><th>[% mainloo.total_looptable_count %]</th><th>[% mainloo.total_coltitle_count %]</th>
52	</tr>	53	</tr>
53	</table>	54	</table>
54		55
Lines 60-102 Link Here
60	<table>	61	<table>
61	<tr>	62	<tr>
62	<th>#</th>	63	<th>#</th>
63	<th>Call number</th>	64	<th>[% t('Call number') %]</th>
64	<th>Barcode</th>	65	<th>[% t('Barcode') %]</th>
65	<th>Item details</th>	66	<th>[% t('Item details') %]</th>
66	</tr>	67	</tr>
67	[% IF ( looptable.looprow ) %]	68	[% IF ( looptable.looprow ) %]
68	[% FOREACH loopro IN looptable.looprow %]	69	[% FOREACH loopro IN looptable.looprow %]
69	<tr>	70	<tr>
70		71
71	<td>[% loop.count %]</td>	72	<td>[% loop.count %]</td>
72	<td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber %][% ELSE %]No call number[% END %]</td>	73	<td>[% IF ( loopro.itemcallnumber ) %][% loopro.itemcallnumber %][% ELSE %][% t('No call number') %][% END %]</td>
73	<td>[% IF ( loopro.barcode ) %][% loopro.barcode %][% ELSE %]No barcode[% END %]</td>	74	<td>[% IF ( loopro.barcode ) %][% loopro.barcode %][% ELSE %][% t('No barcode') %][% END %]</td>
74	<td><p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber %]">[% IF ( loopro.title ) %][% loopro.title %][% ELSE %]NO TITLE[% END %]</a> [% IF ( loopro.author ) %] by [% loopro.author %][% END %]</p>	75	<td><p><a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=[% loopro.biblionumber %]">[% IF ( loopro.title ) %][% loopro.title %][% ELSE %][% t('NO TITLE') %][% END %]</a> [% IF ( loopro.author ) %] [% t('by') %] [% loopro.author %][% END %]</p>
75	[% IF ( loopro.branch ) %]at [% Branches.GetName( loopro.branch ) %][% END %]	76	[% IF ( loopro.branch ) %][% t('at') %] [% Branches.GetName( loopro.branch ) %][% END %]
76	</td>	77	</td>
77	</tr>	78	</tr>
78	[% END %]	79	[% END %]
79	[% ELSE %]	80	[% ELSE %]
80	<tr><td colspan="4">No items for [% looptable.coltitle %]</td>	81	<tr><td colspan="4">[% t('No items for') %] [% looptable.coltitle %]</td>
81	</tr>	82	</tr>
82	[% END %]	83	[% END %]
83	</table>	84	</table>
84	[% END %]	85	[% END %]
85	[% END %]	86	[% END %]
86	[% ELSE %]	87	[% ELSE %]
87	<h1>Items with no checkouts</h1>	88	<h1>[% t('Items with no checkouts') %]</h1>
88	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">	89	<form method="post" action="/cgi-bin/koha/reports/catalogue_out.pl">
89		90
90	<fieldset class="rows">	91	<fieldset class="rows">
91	<ol>	92	<ol>
92	<li><label for="branch">Library: </label>	93	<li><label for="branch">[% t('Library:') %] </label>
93	<select name="Filter" id="branch">	94	<select name="Filter" id="branch">
94	<option value="">Any library</option>	95	<option value="">[% t('Any library') %]</option>
95	[% PROCESS options_for_libraries libraries => Branches.all() %]	96	[% PROCESS options_for_libraries libraries => Branches.all() %]
96	</select></li>	97	</select></li>
97	<li>	98	<li>
98	<label for="documenttype">Item type: </label><select name="Filter" id="documenttype">	99	<label for="documenttype">[% t('Item type:') %] </label><select name="Filter" id="documenttype">
99	<option value="">Any item type</option>	100	<option value="">[% t('Any item type') %]</option>
100	[% FOREACH itemtype IN itemtypes %]	101	[% FOREACH itemtype IN itemtypes %]
101	<option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>	102	<option value="[% itemtype.itemtype %]">[% itemtype.translated_description %]</option>
102	[% END %]	103	[% END %]
Lines 106-131 Link Here
106	</fieldset>	107	</fieldset>
107		108
108	<fieldset class="rows">	109	<fieldset class="rows">
109	<legend>Limits</legend>	110	<legend>[% t('Limits') %]</legend>
110	<ol>	111	<ol>
111	<li>	112	<li>
112	<label for="numberlimit">Limit to: </label>	113	<label for="numberlimit">[% t('Limit to:') %] </label>
113	<select name="Limit" id="numberlimit">	114	<select name="Limit" id="numberlimit">
114	<option value ="10">10</option>	115	<option value="10">[% t('10') %]</option>
115	<option value ="20">20</option>	116	<option value="20">[% t('20') %]</option>
116	<option value ="50">50</option>	117	<option value="50">[% t('50') %]</option>
117	<option value ="100">100</option>	118	<option value="100">[% t('100') %]</option>
118	<option value ="200">200</option>	119	<option value="200">[% t('200') %]</option>
119	<option value ="300">300</option>	120	<option value="300">[% t('300') %]</option>
120	<option value ="400">400</option>	121	<option value="400">[% t('400') %]</option>
121	<option value ="500">500</option>	122	<option value="500">[% t('500') %]</option>
122	<option value ="1000">1000</option>	123	<option value="1000">[% t('1000') %]</option>
123	</select>	124	</select>
124	</li>	125	</li>
125	<li><label for="criteria">By: </label><select name="Criteria" id="criteria">	126	<li><label for="criteria">[% t('By:') %] </label><select name="Criteria" id="criteria">
126	<option value ="" selected="selected">None</option>	127	<option value="" selected="selected">[% t('None') %]</option>
127	<option value ="homebranch">Library</option>	128	<option value="homebranch">[% t('Library') %]</option>
128	<option value ="itype">Item type</option>	129	<option value="itype">[% t('Item type') %]</option>
129	</select></li>	130	</select></li>
130	</ol>	131	</ol>
131	</fieldset>	132	</fieldset>

Lines 1-6 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/dictionary.tt (-52 / +53 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% SET footerjs = 1 %]	2	[% SET footerjs = 1 %]
2	[% INCLUDE 'doc-head-open.inc' %]	3	[% INCLUDE 'doc-head-open.inc' %]
3	<title>Koha &rsaquo; Reports &rsaquo; Guided reports &rsaquo; Dictionary</title>	4	<title>[% t('Koha › Reports › Guided reports › Dictionary') %]</title>
4	[% INCLUDE 'doc-head-close.inc' %]	5	[% INCLUDE 'doc-head-close.inc' %]
5	<style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>	6	<style type="text/css">fieldset.rows table { clear: none; margin: 0;}</style>
6	</head>	7	</head>
Lines 11-31 Link Here
11		12
12	[%- BLOCK area_name -%]	13	[%- BLOCK area_name -%]
13	[%- SWITCH area -%]	14	[%- SWITCH area -%]
14	[%- CASE 'CIRC' -%]Circulation	15	[%- CASE 'CIRC' -%][% t('Circulation') %]
15	[%- CASE 'CAT' -%]Catalog	16	[%- CASE 'CAT' -%][% t('Catalog') %]
16	[%- CASE 'PAT' -%]Patrons	17	[%- CASE 'PAT' -%][% t('Patrons') %]
17	[%- CASE 'ACQ' -%]Acquisitions	18	[%- CASE 'ACQ' -%][% t('Acquisitions') %]
18	[%- CASE 'ACC' -%]Accounts	19	[%- CASE 'ACC' -%][% t('Accounts') %]
19	[%- END -%]	20	[%- END -%]
20	[%- END -%]	21	[%- END -%]
21		22
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; <a href="/cgi-bin/koha/reports/guided_reports.pl">Guided reports wizard</a>	23	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> › <a href="/cgi-bin/koha/reports/guided_reports.pl">[% t('Guided reports wizard') %]</a>
23	[% IF ( new_dictionary ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Name the new definition</strong>	24	[% IF ( new_dictionary ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Name the new definition') %]</strong>
24	[% ELSIF ( step_2 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 2: Choose the area </strong>	25	[% ELSIF ( step_2 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 2: Choose the area') %] </strong>
25	[% ELSIF ( step_3 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 3: Choose a column </strong>	26	[% ELSIF ( step_3 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 3: Choose a column') %] </strong>
26	[% ELSIF ( step_4 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 4: Specify a value </strong>	27	[% ELSIF ( step_4 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 4: Specify a value') %] </strong>
27	[% ELSIF ( step_5 ) %] &rsaquo; <a href="/cgi-bin/koha/reports/dictionary.pl">Dictionary</a> &rsaquo; <strong>Step 5: Confirm definition</strong>	28	[% ELSIF ( step_5 ) %] › <a href="/cgi-bin/koha/reports/dictionary.pl">[% t('Dictionary') %]</a> › <strong>[% t('Step 5: Confirm definition') %]</strong>
28	[% ELSE %] &rsaquo; <strong> Dictionary </strong>[% END %]</div>	29	[% ELSE %] › <strong> [% t('Dictionary') %] </strong>[% END %]</div>
29		30
30	<div id="doc3" class="yui-t2">	31	<div id="doc3" class="yui-t2">
31		32
Lines 34-54 Link Here
34	<div class="yui-b">	35	<div class="yui-b">
35	[% IF ( start_dictionary ) %]	36	[% IF ( start_dictionary ) %]
36	<div id="toolbar">	37	<div id="toolbar">
37	<a id="newdictionary" class="btn btn-default btn-sm" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition"><i class="fa fa-plus"></i> New definition</a>	38	<a id="newdictionary" class="btn btn-default btn-sm" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition"><i class="fa fa-plus"></i> [% t('New definition') %]</a>
38	</div>	39	</div>
39	[% END %]	40	[% END %]
40	<h1>Dictionary</h1>	41	<h1>[% t('Dictionary') %]</h1>
41	[% IF ( start_dictionary ) %]	42	[% IF ( start_dictionary ) %]
42	<p>Use the dictionary to define custom criteria for reporting.</p>	43	<p>[% t('Use the dictionary to define custom criteria for reporting.') %]</p>
43		44
44	[% IF ( definitions ) %]	45	[% IF ( definitions ) %]
45	<h2>Current terms</h2>	46	<h2>[% t('Current terms') %]</h2>
46	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">	47	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
47	<input type="hidden" name="phase" value="View Dictionary" />	48	<input type="hidden" name="phase" value="View Dictionary" />
48	[% IF ( areas ) %]	49	[% IF ( areas ) %]
49	Filter by area	50	[% t('Filter by area') %]
50	<select name="area">	51	<select name="area">
51	<option value="">All</option>	52	<option value="">[% t('All') %]</option>
52	[% FOREACH area IN areas %]	53	[% FOREACH area IN areas %]
53	[%- IF ( area.selected ) -%]	54	[%- IF ( area.selected ) -%]
54	<option value="[% area.id %]" selected="selected">[%- PROCESS area_name area=area.id -%]</option>	55	<option value="[% area.id %]" selected="selected">[%- PROCESS area_name area=area.id -%]</option>
Lines 63-73 Link Here
63	<br />	64	<br />
64	<table>	65	<table>
65	<tr>	66	<tr>
66	<th>Name</th>	67	<th>[% t('Name') %]</th>
67	<th>Description</th>	68	<th>[% t('Description') %]</th>
68	<th>Area</th>	69	<th>[% t('Area') %]</th>
69	<th>Definition</th>	70	<th>[% t('Definition') %]</th>
70	<th>Action</th>	71	<th>[% t('Action') %]</th>
71	</tr>	72	</tr>
72	[% FOREACH definition IN definitions %]	73	[% FOREACH definition IN definitions %]
73	<tr>	74	<tr>
Lines 78-103 Link Here
78	<td class="actions"><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">	79	<td class="actions"><form method="post" action="/cgi-bin/koha/reports/dictionary.pl">
79	<input type="hidden" name="id" value="[% definition.id %]" />	80	<input type="hidden" name="id" value="[% definition.id %]" />
80	<input type="hidden" name="phase" value="Delete Definition" />	81	<input type="hidden" name="phase" value="Delete Definition" />
81	<button type="submit" name="submit" class="btn btn-default btn-xs" id="delete"><i class="fa fa-trash"></i> Delete</button>	82	<button type="submit" name="submit" class="btn btn-default btn-xs" id="delete"><i class="fa fa-trash"></i> [% t('Delete') %]</button>
82	</form></td>	83	</form></td>
83	</tr>	84	</tr>
84	[% END %]	85	[% END %]
85	</table>	86	</table>
86	[% ELSE %]	87	[% ELSE %]
87	<div class="dialog message">There are no saved definitions. <a id="newdictionary" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition">Add a definition to the dictionary.</a></div>	88	<div class="dialog message">[% t('There are no saved definitions.') %] <a id="newdictionary" href="/cgi-bin/koha/reports/dictionary.pl?phase=Add%20New%20Definition">[% t('Add a definition to the dictionary.') %]</a></div>
88	[% END %]	89	[% END %]
89	[% END %]	90	[% END %]
90		91
91	[% IF ( new_dictionary ) %]	92	[% IF ( new_dictionary ) %]
92	<h3>Add new definition</h3>	93	<h3>[% t('Add new definition') %]</h3>
93	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">	94	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
94	<fieldset class="rows"><legend>Step 1 of 5: Name the new definition</legend><ol>	95	<fieldset class="rows"><legend>[% t('Step 1 of 5: Name the new definition') %]</legend><ol>
95	<li>	96	<li>
96	<label for="definition_name">Definition name:</label>	97	<label for="definition_name">[% t('Definition name:') %]</label>
97	<input type="text" id="definition_name" name="definition_name" />	98	<input type="text" id="definition_name" name="definition_name" />
98	</li>	99	</li>
99	<li>	100	<li>
100	<label for="definition_description">Definition description:</label>	101	<label for="definition_description">[% t('Definition description:') %]</label>
101	<textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>	102	<textarea name="definition_description" id="definition_description" rows="3" cols="20"></textarea>
102	</li>	103	</li>
103	</ol></fieldset>	104	</ol></fieldset>
Lines 108-123 Link Here
108	[% END %]	109	[% END %]
109		110
110	[%- IF ( step_2 ) -%]	111	[%- IF ( step_2 ) -%]
111	<h3>Add new definition</h3>	112	<h3>[% t('Add new definition') %]</h3>
112	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">	113	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
113	<fieldset class="rows">	114	<fieldset class="rows">
114	<legend>Step 2 of 5: Choose the area</legend>	115	<legend>[% t('Step 2 of 5: Choose the area') %]</legend>
115	<ol>	116	<ol>
116	<li>	117	<li>
117	<input type="hidden" name="phase" value="New Term step 3" />	118	<input type="hidden" name="phase" value="New Term step 3" />
118	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />	119	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />
119	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />	120	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />
120	<label for="area">Select table:</label><select name="area" id="area">	121	<label for="area">[% t('Select table:') %]</label><select name="area" id="area">
121	[%- FOREACH area IN areas -%]	122	[%- FOREACH area IN areas -%]
122	<option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>	123	<option value="[%- area.id -%]">[%- PROCESS area_name area=area.id -%]</option>
123	[%- END -%]	124	[%- END -%]
Lines 130-139 Link Here
130	[%- END -%]	131	[%- END -%]
131		132
132	[% IF ( step_3 ) %]	133	[% IF ( step_3 ) %]
133	<h3>Add new definition</h3>	134	<h3>[% t('Add new definition') %]</h3>
134	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">	135	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
135	<fieldset class="rows">	136	<fieldset class="rows">
136	<legend>Step 3 of 5: Choose a column</legend>	137	<legend>[% t('Step 3 of 5: Choose a column') %]</legend>
137	<input type="hidden" name="area" value="[% area %]" />	138	<input type="hidden" name="area" value="[% area %]" />
138	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />	139	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />
139	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />	140	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />
Lines 166-175 Link Here
166	[% END %]	167	[% END %]
167		168
168	[% IF ( step_4 ) %]	169	[% IF ( step_4 ) %]
169	<h3>Add new definition</h3>	170	<h3>[% t('Add new definition') %]</h3>
170	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">	171	<form action="/cgi-bin/koha/reports/dictionary.pl" method="post">
171	<fieldset class="rows">	172	<fieldset class="rows">
172	<legend>Step 4 of 5: Specify a value</legend>	173	<legend>[% t('Step 4 of 5: Specify a value') %]</legend>
173	<input type="hidden" name="area" value="[% area %]" />	174	<input type="hidden" name="area" value="[% area %]" />
174	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />	175	<input type="hidden" name="definition_name" value="[% definition_name \| html %]" />
175	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />	176	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />
Lines 177-185 Link Here
177		178
178	[% FOREACH column IN columns %]	179	[% FOREACH column IN columns %]
179	<input type="hidden" name="criteria_column" value="[% column.name %]" />	180	<input type="hidden" name="criteria_column" value="[% column.name %]" />
180	<ol><li><span class="label">Column: </span> [% column.name %]</li>	181	<ol><li><span class="label">[% t('Column:') %] </span> [% column.name %]</li>
181	[% IF ( column.distinct ) %]	182	[% IF ( column.distinct ) %]
182	<li><label for="[% column.name %]_value">Choose: </label> <select id="[% column.name %]_value" name="[% column.name %]_value">	183	<li><label for="[% column.name %]_value">[% t('Choose:') %] </label> <select id="[% column.name %]_value" name="[% column.name %]_value">
183	[% FOREACH value IN column.values %]	184	[% FOREACH value IN column.values %]
184	<option value="[% value.availablevalues %]">[% value.availablevalues %]</option>	185	<option value="[% value.availablevalues %]">[% value.availablevalues %]</option>
185	[% END %]	186	[% END %]
Lines 187-208 Link Here
187	[% END %]	188	[% END %]
188	[% IF ( column.date ) %]	189	[% IF ( column.date ) %]
189	<li class="radio">	190	<li class="radio">
190	<label for="all_dates">All dates</label>	191	<label for="all_dates">[% t('All dates') %]</label>
191	<input type="radio" id="all_dates" name="[% column.name %]_date_type_value" value="all" checked="checked" />	192	<input type="radio" id="all_dates" name="[% column.name %]_date_type_value" value="all" checked="checked" />
192	<label for="date_range">Date range</label>	193	<label for="date_range">[% t('Date range') %]</label>
193	<input type="radio" id="date_range" name="[% column.name %]_date_type_value" value="range" />	194	<input type="radio" id="date_range" name="[% column.name %]_date_type_value" value="range" />
194	</li>	195	</li>
195	<li class="radio">	196	<li class="radio">
196	Start of date range	197	[% t('Start of date range') %]
197	<input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />	198	<input type="text" size="10" id="from" name="[% column.name %]_start_value" value="" class="datepickerfrom" />
198	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>	199	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>
199	End of date range	200	[% t('End of date range') %]
200	<input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />	201	<input type="text" size="10" id="to" name="[% column.name %]_end_value" value="" class="datepickerto" />
201	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>	202	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>
202	</li>	203	</li>
203	[% END %]	204	[% END %]
204	[% IF ( column.text ) %]	205	[% IF ( column.text ) %]
205	<li><label for="[% column.name %]_value">Search string matches: </label> <input type="text" size="13" name="[% column.name %]_value" /></li>	206	<li><label for="[% column.name %]_value">[% t('Search string matches:') %] </label> <input type="text" size="13" name="[% column.name %]_value" /></li>
206	[% END %]	207	[% END %]
207		208
208	[% END %]	209	[% END %]
Lines 222-247 Link Here
222	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />	223	<input type="hidden" name="definition_description" value="[% definition_description \| html %]" />
223	<input type="hidden" name="columnstring" value="[% columnstring %]" />	224	<input type="hidden" name="columnstring" value="[% columnstring %]" />
224		225
225	<h3>Add new definition</h3>	226	<h3>[% t('Add new definition') %]</h3>
226		227
227	<fieldset class="rows">	228	<fieldset class="rows">
228	<legend>Step 5 of 5: Confirm details</legend>	229	<legend>[% t('Step 5 of 5: Confirm details') %]</legend>
229	<ol>	230	<ol>
230	<li>	231	<li>
231	<span class="label">Name:</span>[%- definition_name \| html -%]	232	<span class="label">[% t('Name:') %]</span>[%- definition_name \| html -%]
232	</li>	233	</li>
233	<li>	234	<li>
234	<span class="label">Description:</span>[%- definition_description \| html -%]	235	<span class="label">[% t('Description:') %]</span>[%- definition_description \| html -%]
235	</li>	236	</li>
236	<li>	237	<li>
237	<span class="label">Area:</span>[%- PROCESS area_name area=area -%]	238	<span class="label">[% t('Area:') %]</span>[%- PROCESS area_name area=area -%]
238	</li>	239	</li>
239	<li>	240	<li>
240	<span class="label">Data:</span>	241	<span class="label">[% t('Data:') %]</span>
241	<table>	242	<table>
242	<tr>	243	<tr>
243	<th>Columns</th>	244	<th>[% t('Columns') %]</th>
244	<th>Values</th>	245	<th>[% t('Values') %]</th>
245	</tr>	246	</tr>
246	[%- FOREACH criteria_loo IN criteria_loop -%]	247	[%- FOREACH criteria_loo IN criteria_loop -%]
247	<tr>	248	<tr>

Lines 1-7 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/issues_avg_stats.tt (-39 / +40 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Branches %]	2	[% USE Branches %]
2	[% SET footerjs = 1 %]	3	[% SET footerjs = 1 %]
3	[% INCLUDE 'doc-head-open.inc' %]	4	[% INCLUDE 'doc-head-open.inc' %]
4	<title>Koha &rsaquo; Reports &rsaquo; Average loan time</title>	5	<title>[% t('Koha › Reports › Average loan time') %]</title>
5	[% INCLUDE 'doc-head-close.inc' %]	6	[% INCLUDE 'doc-head-close.inc' %]
6	</head>	7	</head>
7		8
Lines 9-15 Link Here
9	[% INCLUDE 'header.inc' %]	10	[% INCLUDE 'header.inc' %]
10	[% INCLUDE 'cat-search.inc' %]	11	[% INCLUDE 'cat-search.inc' %]
11		12
12	<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 loan time</a> &rsaquo; Results [% ELSE %]&rsaquo; Average loan time[% END %]</div>	13	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a> [% IF ( do_it ) %]› <a href="/cgi-bin/koha/reports/issues_avg_stats.pl">[% t('Average loan time') %]</a> [% t('› Results') %] [% ELSE %][% t('› Average loan time') %][% END %]</div>
13		14
14	<div id="doc3" class="yui-t2">	15	<div id="doc3" class="yui-t2">
15		16
Lines 19-27 Link Here
19		20
20	[% IF ( do_it ) %]	21	[% IF ( do_it ) %]
21	[% FOREACH mainloo IN mainloop %]	22	[% FOREACH mainloo IN mainloop %]
22	<h1>Average checkout period</h1>	23	<h1>[% t('Average checkout period') %]</h1>
23	[% IF ( mainloo.loopfilter ) %]	24	[% IF ( mainloo.loopfilter ) %]
24	<p>Filtered on:</p>	25	<p>[% t('Filtered on:') %]</p>
25	[% FOREACH loopfilte IN mainloo.loopfilter %]	26	[% FOREACH loopfilte IN mainloo.loopfilter %]
26	<p>[% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %] [% END %]</p>	27	<p>[% IF ( loopfilte.err ) %] [% END %] [% loopfilte.crit %] =[% loopfilte.filter %][% IF ( loopfilte.err ) %] [% END %]</p>
27	[% END %]	28	[% END %]
Lines 33-39 Link Here
33	[% FOREACH loopco IN mainloo.loopcol %]	34	[% FOREACH loopco IN mainloo.loopcol %]
34	<th>[% loopco.coltitle %]</th>	35	<th>[% loopco.coltitle %]</th>
35	[% END %]	36	[% END %]
36	<th>TOTAL</th>	37	<th>[% t('TOTAL') %]</th>
37	</tr>	38	</tr>
38	[% FOREACH loopro IN mainloo.looprow %]	39	[% FOREACH loopro IN mainloo.looprow %]
39	<tr>	40	<tr>
Lines 50-56 Link Here
50	</tr>	51	</tr>
51	[% END %]	52	[% END %]
52	<tr>	53	<tr>
53	<th>TOTAL</th>	54	<th>[% t('TOTAL') %]</th>
54	[% FOREACH loopfoote IN mainloo.loopfooter %]	55	[% FOREACH loopfoote IN mainloo.loopfooter %]
55	<th>	56	<th>
56	[% loopfoote.totalcol %]	57	[% loopfoote.totalcol %]
Lines 64-124 Link Here
64		65
65	<form method="post" action="/cgi-bin/koha/reports/issues_avg_stats.pl">	66	<form method="post" action="/cgi-bin/koha/reports/issues_avg_stats.pl">
66	<fieldset class="rows">	67	<fieldset class="rows">
67	<legend>Average checkout period statistics</legend>	68	<legend>[% t('Average checkout period statistics') %]</legend>
68	<table>	69	<table>
69	<thead>	70	<thead>
70	<tr>	71	<tr>
71	<th>Title</th>	72	<th>[% t('Title') %]</th>
72	<th>Row</th>	73	<th>[% t('Row') %]</th>
73	<th>Column</th>	74	<th>[% t('Column') %]</th>
74	<th>Filter</th>	75	<th>[% t('Filter') %]</th>
75	</tr>	76	</tr>
76	</thead>	77	</thead>
77	<tbody>	78	<tbody>
78	<tr class="hilighted">	79	<tr class="hilighted">
79	<td>Checkout date</td>	80	<td>[% t('Checkout date') %]</td>
80	<td><input type="radio" name="Line" value="timestamp" /></td>	81	<td><input type="radio" name="Line" value="timestamp" /></td>
81	<td><input type="radio" name="Column" value="timestamp" /></td>	82	<td><input type="radio" name="Column" value="timestamp" /></td>
82	<td > <label for="from">From</label> <input type="text" size="10" id="from" name="Filter" />	83	<td> <label for="from">[% t('From') %]</label> <input type="text" size="10" id="from" name="Filter" />
83	<label for="to">To</label> <input size="10" id="to" name="Filter" value="" type="text" />	84	<label for="to">[% t('To') %]</label> <input size="10" id="to" name="Filter" value="" type="text" />
84	<span class="hint">[% INCLUDE 'date-format.inc' %]</span>	85	<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
85	</td>	86	</td>
86	</tr>	87	</tr>
87	<tr class="hilighted">	88	<tr class="hilighted">
88	<td> </td>	89	<td> </td>
89	<td colspan="2">by <select name="IssueDisplay">	90	<td colspan="2">[% t('by') %] <select name="IssueDisplay">
90	<option value=""> </option>	91	<option value=""> </option>
91	<option value ="1">Day</option>	92	<option value="1">[% t('Day') %]</option>
92	<option value ="2">Month</option>	93	<option value="2">[% t('Month') %]</option>
93	<option value ="3">Year</option>	94	<option value="3">[% t('Year') %]</option>
94	</select>	95	</select>
95		96
96	</td>	97	</td>
97	<td><!--Preparing Month and Day Selection--><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>	98	<td><!--Preparing Month and Day Selection--><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
98	</tr>	99	</tr>
99	<tr>	100	<tr>
100	<td>Returns</td>	101	<td>[% t('Returns') %]</td>
101	<td><input type="radio" name="Line" value="returndate" /></td>	102	<td><input type="radio" name="Line" value="returndate" /></td>
102	<td><input type="radio" name="Column" value="returndate" /></td>	103	<td><input type="radio" name="Column" value="returndate" /></td>
103	<td > <label for="fromRO">From</label> <input type="text" size="10" id="fromRO" name="Filter" />	104	<td> <label for="fromRO">[% t('From') %]</label> <input type="text" size="10" id="fromRO" name="Filter" />
104	<label for="toRO">To</label> <input type="text" size="10" id="toRO" name="Filter" value="" />	105	<label for="toRO">[% t('To') %]</label> <input type="text" size="10" id="toRO" name="Filter" value="" />
105	<span class="hint">[% INCLUDE 'date-format.inc' %]</span>	106	<span class="hint">[% INCLUDE 'date-format.inc' %]</span>
106	</td>	107	</td>
107	</tr>	108	</tr>
108	<tr>	109	<tr>
109	<td> </td>	110	<td> </td>
110	<td colspan="2">by <select name="ReturnDisplay">	111	<td colspan="2">[% t('by') %] <select name="ReturnDisplay">
111	<option value=""> </option>	112	<option value=""> </option>
112	<option value ="1">Day</option>	113	<option value="1">[% t('Day') %]</option>
113	<option value ="2">Month</option>	114	<option value="2">[% t('Month') %]</option>
114	<option value ="3">Year</option>	115	<option value="3">[% t('Year') %]</option>
115	</select>	116	</select>
116		117
117	</td>	118	</td>
118	<td><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>	119	<td><input type="hidden" name="Filter" value="" /><input type="hidden" name="Filter" value="" /></td>
119	</tr>	120	</tr>
120	<tr class="hilighted">	121	<tr class="hilighted">
121	<td>Patron category</td>	122	<td>[% t('Patron category') %]</td>
122	<td><input type="radio" name="Line" value="borrowers.categorycode" /></td>	123	<td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
123	<td><input type="radio" name="Column" value="borrowers.categorycode" /></td>	124	<td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
124	<td>	125	<td>
Lines 131-137 Link Here
131	</td>	132	</td>
132	</tr>	133	</tr>
133	<tr>	134	<tr>
134	<td>Item type</td>	135	<td>[% t('Item type') %]</td>
135	<td><input type="radio" name="Line" value="itemtype" /></td>	136	<td><input type="radio" name="Line" value="itemtype" /></td>
136	<td><input type="radio" name="Column" value="itemtype" /></td>	137	<td><input type="radio" name="Column" value="itemtype" /></td>
137	<td>	138	<td>
Lines 144-150 Link Here
144	</td>	145	</td>
145	</tr>	146	</tr>
146	<tr class="hilighted">	147	<tr class="hilighted">
147	<td>Library</td>	148	<td>[% t('Library') %]</td>
148	<td><input type="radio" name="Line" value="branchcode" /></td>	149	<td><input type="radio" name="Line" value="branchcode" /></td>
149	<td><input type="radio" name="Column" value="branchcode" /></td>	150	<td><input type="radio" name="Column" value="branchcode" /></td>
150	<td>	151	<td>
Lines 156-162 Link Here
156	</tr>	157	</tr>
157	[% IF ( hassort1 ) %]	158	[% IF ( hassort1 ) %]
158	<tr class="hilighted">	159	<tr class="hilighted">
159	<td>Sort1</td>	160	<td>[% t('Sort1') %]</td>
160	<td><input type="radio" name="Line" value="borrowers.sort1" /></td>	161	<td><input type="radio" name="Line" value="borrowers.sort1" /></td>
161	<td><input type="radio" name="Column" value="borrowers.sort1" /></td>	162	<td><input type="radio" name="Column" value="borrowers.sort1" /></td>
162	<td>	163	<td>
Lines 171-177 Link Here
171	[% END %]	172	[% END %]
172	[% IF ( hassort2 ) %]	173	[% IF ( hassort2 ) %]
173	[% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %]	174	[% IF ( HglghtSort2 ) %]<tr class="hilighted"> [% ELSE %]<tr>[% END %]
174	<td>Sort2</td>	175	<td>[% t('Sort2') %]</td>
175	<td><input type="radio" name="Line" value="borrowers.sort2" /></td>	176	<td><input type="radio" name="Line" value="borrowers.sort2" /></td>
176	<td><input type="radio" name="Column" value="borrowers.sort2" /></td>	177	<td><input type="radio" name="Column" value="borrowers.sort2" /></td>
177	<td>	178	<td>
Lines 189-205 Link Here
189		190
190		191
191	<fieldset class="rows">	192	<fieldset class="rows">
192	<legend>Output</legend>	193	<legend>[% t('Output') %]</legend>
193	<ol>	194	<ol>
194	<li>	195	<li>
195	<label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />	196	<label for="outputscreen">[% t('To screen into the browser:') %] </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
196	</li>	197	</li>
197	<li>	198	<li>
198	<label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" />	199	<label for="outputfile">[% t('To a file:') %]</label> <input type="radio" name="output" value="file" id="outputfile" />
199	<label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />	200	<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
200	<label class="inline" for="MIME">Into an application: </label>	201	<label class="inline" for="MIME">[% t('Into an application:') %] </label>
201	<select name="MIME" size="1" id="MIME">	202	<select name="MIME" size="1" id="MIME">
202	<option value="CSV">CSV</option>	203	<option value="CSV">[% t('CSV') %]</option>
203	</select>	204	</select>
204	<select name="sep" id="sep" size="1">	205	<select name="sep" id="sep" size="1">
205	[% FOREACH value IN CGIsepChoice.values.sort() %]	206	[% FOREACH value IN CGIsepChoice.values.sort() %]

Lines 1-10 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/cash_register_stats.tt (-64 / +65 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Asset %]	2	[% USE Asset %]
2	[% USE KohaDates %]	3	[% USE KohaDates %]
3	[% USE Price %]	4	[% USE Price %]
4	[% USE ItemTypes %]	5	[% USE ItemTypes %]
5	[% SET footerjs = 1 %]	6	[% SET footerjs = 1 %]
6	[% INCLUDE 'doc-head-open.inc' %]	7	[% INCLUDE 'doc-head-open.inc' %]
7	<title>Koha &rsaquo; Reports [% IF ( do_it ) %]&rsaquo; Cash register statistics &rsaquo; Results[% ELSE %]&rsaquo; Cash register statistics[% END %]</title>	8	<title>[% t('Koha › Reports') %] [% IF ( do_it ) %][% t('› Cash register statistics › Results') %][% ELSE %][% t('› Cash register statistics') %][% END %]</title>
8	[% INCLUDE 'doc-head-close.inc' %]	9	[% INCLUDE 'doc-head-close.inc' %]
9	[% Asset.css("css/datatables.css") %]	10	[% Asset.css("css/datatables.css") %]
10	</head>	11	</head>
Lines 14-25 Link Here
14	[% INCLUDE 'cat-search.inc' %]	15	[% INCLUDE 'cat-search.inc' %]
15		16
16	<div id="breadcrumbs">	17	<div id="breadcrumbs">
17	<a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a>	18	<a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">[% t('Reports') %]</a>
18	&rsaquo;	19	›
19	[% IF ( do_it ) %]	20	[% IF ( do_it ) %]
20	<a href="/cgi-bin/koha/reports/cash_register_stats.pl">Cash register statistics</a> &rsaquo; Results	21	<a href="/cgi-bin/koha/reports/cash_register_stats.pl">[% t('Cash register statistics') %]</a> [% t('› Results') %]
21	[% ELSE %]	22	[% ELSE %]
22	Cash register statistics	23	[% t('Cash register statistics') %]
23	[% END %]	24	[% END %]
24	</div>	25	</div>
25		26
Lines 29-124 Link Here
29	<div id="yui-main">	30	<div id="yui-main">
30	<div class="yui-b">	31	<div class="yui-b">
31		32
32	<h1>Cash register statistics</h1>	33	<h1>[% t('Cash register statistics') %]</h1>
33	<form method="post" action="/cgi-bin/koha/reports/cash_register_stats.pl" id="frmCashRegister">	34	<form method="post" action="/cgi-bin/koha/reports/cash_register_stats.pl" id="frmCashRegister">
34	<fieldset class="rows">	35	<fieldset class="rows">
35	<legend>Cash register statistics [% beginDate \| $KohaDates %] to [% endDate \| $KohaDates %]</legend>	36	<legend>[% t('Cash register statistics') %] [% beginDate \| $KohaDates %] [% t('to') %] [% endDate \| $KohaDates %]</legend>
36	<ol>	37	<ol>
37	<br>	38	<br>
38	<li>	39	<li>
39	<label for="from">From: </label>	40	<label for="from">[% t('From:') %] </label>
40	<input type="text" size="10" id="from" name="from" value="[% beginDate \| $KohaDates %]" class="datepickerfrom" />	41	<input type="text" size="10" id="from" name="from" value="[% beginDate \| $KohaDates %]" class="datepickerfrom" />
41	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>	42	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>
42	</li>	43	</li>
43	<li>	44	<li>
44	<label for="to">To: </label>	45	<label for="to">[% t('To:') %] </label>
45	<input type="text" size="10" id="to" name="to" value="[% endDate \| $KohaDates %]" class="datepickerto" />	46	<input type="text" size="10" id="to" name="to" value="[% endDate \| $KohaDates %]" class="datepickerto" />
46	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>	47	<div class="hint">[% INCLUDE 'date-format.inc' %]</div>
47	</li>	48	</li>
48		49
49	<li>	50	<li>
50	<label for="">Transaction type:</label>	51	<label for="">[% t('Transaction type:') %]</label>
51	<select name="transaction_type" id="transaction_type">	52	<select name="transaction_type" id="transaction_type">
52	[% IF transaction_type == "ALL" %]	53	[% IF transaction_type == "ALL" %]
53	<option value="ALL" selected="selected">All transactions</option>	54	<option value="ALL" selected="selected">[% t('All transactions') %]</option>
54	[% ELSE %]	55	[% ELSE %]
55	<option value="ALL">All transactions</option>	56	<option value="ALL">[% t('All transactions') %]</option>
56	[% END %]	57	[% END %]
57		58
58	[% IF transaction_type == "ACT" %]	59	[% IF transaction_type == "ACT" %]
59	<option value="ACT" selected="selected">All payments to the library</option>	60	<option value="ACT" selected="selected">[% t('All payments to the library') %]</option>
60	[% ELSE %]	61	[% ELSE %]
61	<option value="ACT">All payments to the library</option>	62	<option value="ACT">[% t('All payments to the library') %]</option>
62	[% END %]	63	[% END %]
63		64
64	[% IF transaction_type == "C" %]	65	[% IF transaction_type == "C" %]
65	<option value="C" selected="selected">Credit</option>	66	<option value="C" selected="selected">[% t('Credit') %]</option>
66	[% ELSE %]	67	[% ELSE %]
67	<option value="C">Credit</option>	68	<option value="C">[% t('Credit') %]</option>
68	[% END %]	69	[% END %]
69		70
70	[% IF transaction_type == "CR" %]	71	[% IF transaction_type == "CR" %]
71	<option value="CR" selected="selected">Credit (item returned)</option>	72	<option value="CR" selected="selected">[% t('Credit (item returned)') %]</option>
72	[% ELSE %]	73	[% ELSE %]
73	<option value="CR">Credit (item returned)</option>	74	<option value="CR">[% t('Credit (item returned)') %]</option>
74	[% END %]	75	[% END %]
75		76
76	[% IF transaction_type == "FORW" %]	77	[% IF transaction_type == "FORW" %]
77	<option value="FORW" selected="selected">Write off</option>	78	<option value="FORW" selected="selected">[% t('Write off') %]</option>
78	[% ELSE %]	79	[% ELSE %]
79	<option value="FORW">Write off</option>	80	<option value="FORW">[% t('Write off') %]</option>
80	[% END %]	81	[% END %]
81		82
82	[% IF transaction_type == "F" %]	83	[% IF transaction_type == "F" %]
83	<option value="F" selected="selected">Fine</option>	84	<option value="F" selected="selected">[% t('Fine') %]</option>
84	[% ELSE %]	85	[% ELSE %]
85	<option value="F">Fine</option>	86	<option value="F">[% t('Fine') %]</option>
86	[% END %]	87	[% END %]
87		88
88	[% IF transaction_type == "FU" %]	89	[% IF transaction_type == "FU" %]
89	<option value="FU" selected="selected">Accruing fine</option>	90	<option value="FU" selected="selected">[% t('Accruing fine') %]</option>
90	[% ELSE %]	91	[% ELSE %]
91	<option value="FU">Accruing fine</option>	92	<option value="FU">[% t('Accruing fine') %]</option>
92	[% END %]	93	[% END %]
93		94
94	[% IF transaction_type == "PAY" %]	95	[% IF transaction_type == "PAY" %]
95	<option value="PAY" selected="selected">Payment</option>	96	<option value="PAY" selected="selected">[% t('Payment') %]</option>
96	[% ELSE %]	97	[% ELSE %]
97	<option value="PAY">Payment</option>	98	<option value="PAY">[% t('Payment') %]</option>
98	[% END %]	99	[% END %]
99		100
100	[% IF transaction_type == "A" %]	101	[% IF transaction_type == "A" %]
101	<option value="A" selected="selected">Account management fee</option>	102	<option value="A" selected="selected">[% t('Account management fee') %]</option>
102	[% ELSE %]	103	[% ELSE %]
103	<option value="A">Account management fee</option>	104	<option value="A">[% t('Account management fee') %]</option>
104	[% END %]	105	[% END %]
105		106
106	[% IF transaction_type == "M" %]	107	[% IF transaction_type == "M" %]
107	<option value="M" selected="selected">Sundry</option>	108	<option value="M" selected="selected">[% t('Sundry') %]</option>
108	[% ELSE %]	109	[% ELSE %]
109	<option value="M">Sundry</option>	110	<option value="M">[% t('Sundry') %]</option>
110	[% END %]	111	[% END %]
111		112
112	[% IF transaction_type == "L" %]	113	[% IF transaction_type == "L" %]
113	<option value="L" selected="selected">Lost item</option>	114	<option value="L" selected="selected">[% t('Lost item') %]</option>
114	[% ELSE %]	115	[% ELSE %]
115	<option value="L">Lost item</option>	116	<option value="L">[% t('Lost item') %]</option>
116	[% END %]	117	[% END %]
117		118
118	[% IF transaction_type == "N" %]	119	[% IF transaction_type == "N" %]
119	<option value="N" selected="selected">New card</option>	120	<option value="N" selected="selected">[% t('New card') %]</option>
120	[% ELSE %]	121	[% ELSE %]
121	<option value="N">New card</option>	122	<option value="N">[% t('New card') %]</option>
122	[% END %]	123	[% END %]
123		124
124	[% FOREACH manualinv IN manualinv_types %]	125	[% FOREACH manualinv IN manualinv_types %]
Lines 132-140 Link Here
132	</select>	133	</select>
133	</li>	134	</li>
134	<li>	135	<li>
135	<label>Transaction branch</label>	136	<label>[% t('Transaction branch') %]</label>
136	<select name="branch" id="branch">	137	<select name="branch" id="branch">
137	<option value="ALL">All</option>	138	<option value="ALL">[% t('All') %]</option>
138	[% FOREACH branchloo IN branchloop %]	139	[% FOREACH branchloo IN branchloop %]
139	[% IF ( branchloo.selected ) %]	140	[% IF ( branchloo.selected ) %]
140	<option value="[% branchloo.branchcode %]" selected="selected">[% branchloo.branchname %]</option>	141	<option value="[% branchloo.branchcode %]" selected="selected">[% branchloo.branchname %]</option>
Lines 150-165 Link Here
150	</fieldset>	151	</fieldset>
151		152
152	<fieldset class="rows">	153	<fieldset class="rows">
153	<legend>Output</legend>	154	<legend>[% t('Output') %]</legend>
154	<ol>	155	<ol>
155	<li>	156	<li>
156	<label for="outputscreen">To screen into the browser: </label>	157	<label for="outputscreen">[% t('To screen into the browser:') %] </label>
157	<input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />	158	<input type="radio" checked="checked" name="output" id="outputscreen" value="screen" />
158	</li>	159	</li>
159	<li>	160	<li>
160	<label for="outputfile">To a file:</label>	161	<label for="outputfile">[% t('To a file:') %]</label>
161	<input type="radio" name="output" value="file" id="outputfile" />	162	<input type="radio" name="output" value="file" id="outputfile" />
162	<label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" />	163	<label class="inline" for="basename">[% t('Named:') %] </label><input type="text" name="basename" id="basename" value="Export" />
163		164
164	</li>	165	</li>
165	</ol>	166	</ol>
Lines 171-191 Link Here
171	</form>	172	</form>
172		173
173	[% IF ( do_it ) %]	174	[% IF ( do_it ) %]
174	<div> </div>	175	<div> </div>
175	<table id="tbl_cash_register_stats">	176	<table id="tbl_cash_register_stats">
176	<thead>	177	<thead>
177	<tr>	178	<tr>
178	<th>Manager name</th>	179	<th>[% t('Manager name') %]</th>
179	<th>Patron card number</th>	180	<th>[% t('Patron card number') %]</th>
180	<th>Patron name</th>	181	<th>[% t('Patron name') %]</th>
181	<th>Transaction branch</th>	182	<th>[% t('Transaction branch') %]</th>
182	<th>Transaction date</th>	183	<th>[% t('Transaction date') %]</th>
183	<th>Transaction type</th>	184	<th>[% t('Transaction type') %]</th>
184	<th>Notes</th>	185	<th>[% t('Notes') %]</th>
185	<th>Amount</th>	186	<th>[% t('Amount') %]</th>
186	<th>Biblio title</th>	187	<th>[% t('Biblio title') %]</th>
187	<th>Barcode</th>	188	<th>[% t('Barcode') %]</th>
188	<th>Item type</th>	189	<th>[% t('Item type') %]</th>
189	</tr>	190	</tr>
190	</thead>	191	</thead>
191	[% FOREACH loopresul IN loopresult %]	192	[% FOREACH loopresul IN loopresult %]
Lines 197-221 Link Here
197	<td>[% loopresul.date \| $KohaDates %]</td>	198	<td>[% loopresul.date \| $KohaDates %]</td>
198	<td>	199	<td>
199	[% IF loopresul.accounttype == "ACT" %]	200	[% IF loopresul.accounttype == "ACT" %]
200	<span>All payments to the library</span>	201	<span>[% t('All payments to the library') %]</span>
201	[% ELSIF loopresul.accounttype == "C" \|\| loopresul.accounttype == "CR" %]	202	[% ELSIF loopresul.accounttype == "C" \|\| loopresul.accounttype == "CR" %]
202	<span>Credit</span>	203	<span>[% t('Credit') %]</span>
203	[% ELSIF loopresul.accounttype == "FORW" \|\| loopresul.accounttype == "W" %]	204	[% ELSIF loopresul.accounttype == "FORW" \|\| loopresul.accounttype == "W" %]
204	<span>Write off</span>	205	<span>[% t('Write off') %]</span>
205	[% ELSIF loopresul.accounttype == "F" %]	206	[% ELSIF loopresul.accounttype == "F" %]
206	<span>Fine</span>	207	<span>[% t('Fine') %]</span>
207	[% ELSIF loopresul.accounttype == "FU" %]	208	[% ELSIF loopresul.accounttype == "FU" %]
208	<span>Accruing fine</span>	209	<span>[% t('Accruing fine') %]</span>
209	[% ELSIF loopresul.accounttype == "Pay" %]	210	[% ELSIF loopresul.accounttype == "Pay" %]
210	<span>Payment</span>	211	<span>[% t('Payment') %]</span>
211	[% ELSIF loopresul.accounttype == "A" %]	212	[% ELSIF loopresul.accounttype == "A" %]
212	<span>Account management fee</span>	213	<span>[% t('Account management fee') %]</span>
213	[% ELSIF loopresul.accounttype == "M" %]	214	[% ELSIF loopresul.accounttype == "M" %]
214	<span>Sundry</span>	215	<span>[% t('Sundry') %]</span>
215	[% ELSIF loopresul.accounttype == "L" \|\| loopresul.accounttype == "LR" %]	216	[% ELSIF loopresul.accounttype == "L" \|\| loopresul.accounttype == "LR" %]
216	<span>Lost item</span>	217	<span>[% t('Lost item') %]</span>
217	[% ELSIF loopresul.accounttype == "N" %]	218	[% ELSIF loopresul.accounttype == "N" %]
218	<span>New card</span>	219	<span>[% t('New card') %]</span>
219	[% ELSE %]	220	[% ELSE %]
220	[% FOREACH manualinv IN manualinv_types %]	221	[% FOREACH manualinv IN manualinv_types %]
221	[% value_manualinv = manualinv.authorised_value\|truncate(5, '') %]	222	[% value_manualinv = manualinv.authorised_value\|truncate(5, '') %]
Lines 236-244 Link Here
236	<tfoot>	237	<tfoot>
237	<tr>	238	<tr>
238	[% IF transaction_type == "ACT" %]	239	[% IF transaction_type == "ACT" %]
239	<th colspan="7" style="text-align:right;">TOTAL</th>	240	<th colspan="7" style="text-align:right;">[% t('TOTAL') %]</th>
240	<th style="text-align:right;">[% total \| $Price %]</th>	241	<th style="text-align:right;">[% total \| $Price %]</th>
241	<th colspan="3"> </th>	242	<th colspan="3"> </th>
242	[% END %]	243	[% END %]
243	</tr>	244	</tr>
244	</tfoot>	245	</tfoot>

Lines 1-13 Link Here

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/reports-home.tt (-32 / +33 lines)
		1	[% PROCESS 'i18n.inc' %]
1	[% USE Koha %]	2	[% USE Koha %]
2	[% INCLUDE 'doc-head-open.inc' %]	3	[% INCLUDE 'doc-head-open.inc' %]
3	<title>Koha &rsaquo; Reports</title>	4	<title>[% t('Koha › Reports') %]</title>
4	[% INCLUDE 'doc-head-close.inc' %]	5	[% INCLUDE 'doc-head-close.inc' %]
5	</head>	6	</head>
6	<body id="rep_reports-home" class="rep">	7	<body id="rep_reports-home" class="rep">
7	[% INCLUDE 'header.inc' %]	8	[% INCLUDE 'header.inc' %]
8	[% INCLUDE 'circ-search.inc' %]	9	[% INCLUDE 'circ-search.inc' %]
9		10
10	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> &rsaquo; Reports</div>	11	<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">[% t('Home') %]</a> [% t('› Reports') %]</div>
11		12
12	<div class="main container-fluid">	13	<div class="main container-fluid">
13	<div class="row">	14	<div class="row">
Lines 19-88 Link Here
19	[% IF ( CAN_user_reports_execute_reports \|\| CAN_user_reports_create_reports ) %]	20	[% IF ( CAN_user_reports_execute_reports \|\| CAN_user_reports_create_reports ) %]
20	<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">	21	<form action="/cgi-bin/koha/reports/guided_reports.pl" method="get">
21	<fieldset class="brief">	22	<fieldset class="brief">
22	<h2>Guided reports</h2>	23	<h2>[% t('Guided reports') %]</h2>
23	<input name="phase" value="Use saved" type="hidden">	24	<input name="phase" value="Use saved" type="hidden">
24	<input name="filter_set" value="1" type="hidden">	25	<input name="filter_set" value="1" type="hidden">
25	[% IF ( CAN_user_reports_create_reports ) %]	26	[% IF ( CAN_user_reports_create_reports ) %]
26	<p>	27	<p>
27	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new"><i class="fa fa-code-fork"></i> Create guided report</a>	28	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Build%20new"><i class="fa fa-code-fork"></i> [% t('Create guided report') %]</a>
28	</p>	29	</p>
29	<p>	30	<p>
30	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL"><i class="fa fa-plus"></i> Create from SQL</a>	31	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Create%20report%20from%20SQL"><i class="fa fa-plus"></i> [% t('Create from SQL') %]</a>
31	</p>	32	</p>
32	[% END %]	33	[% END %]
33	<p>	34	<p>
34	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved"><i class="fa fa-list"></i> Use saved</a>	35	<a href="/cgi-bin/koha/reports/guided_reports.pl?phase=Use%20saved"><i class="fa fa-list"></i> [% t('Use saved') %]</a>
35	</p>	36	</p>
36	<label for="filter_keyword">Search by keyword:</label> <input id="filter_keyword" name="filter_keyword" value="" size="16" type="text" /> <input value="Search" type="submit" />	37	<label for="filter_keyword">[% t('Search by keyword:') %]</label> <input id="filter_keyword" name="filter_keyword" value="" size="16" type="text" /> <input value="Search" type="submit" />
37	</fieldset>	38	</fieldset>
38	</form>	39	</form>
39	[% END %]	40	[% END %]
40		41
41	<h5>Reports dictionary</h5>	42	<h5>[% t('Reports dictionary') %]</h5>
42	<ul>	43	<ul>
43	<li><a href="/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary">View dictionary</a></li>	44	<li><a href="/cgi-bin/koha/reports/dictionary.pl?phase=View%20Dictionary">[% t('View dictionary') %]</a></li>
44	</ul>	45	</ul>
45		46
46	<h2>Statistics wizards</h2>	47	<h2>[% t('Statistics wizards') %]</h2>
47	<ul>	48	<ul>
48	<li><a href="/cgi-bin/koha/reports/acquisitions_stats.pl">Acquisitions</a></li>	49	<li><a href="/cgi-bin/koha/reports/acquisitions_stats.pl">[% t('Acquisitions') %]</a></li>
49	<li><a href="/cgi-bin/koha/reports/borrowers_stats.pl">Patrons</a></li>	50	<li><a href="/cgi-bin/koha/reports/borrowers_stats.pl">[% t('Patrons') %]</a></li>
50	<li><a href="/cgi-bin/koha/reports/catalogue_stats.pl">Catalog</a></li>	51	<li><a href="/cgi-bin/koha/reports/catalogue_stats.pl">[% t('Catalog') %]</a></li>
51	<li><a href="/cgi-bin/koha/reports/issues_stats.pl">Circulation</a></li>	52	<li><a href="/cgi-bin/koha/reports/issues_stats.pl">[% t('Circulation') %]</a></li>
52	<li><a href="/cgi-bin/koha/reports/serials_stats.pl">Serials</a></li>	53	<li><a href="/cgi-bin/koha/reports/serials_stats.pl">[% t('Serials') %]</a></li>
53	<li><a href="/cgi-bin/koha/reports/cash_register_stats.pl">Cash register</a></li>	54	<li><a href="/cgi-bin/koha/reports/cash_register_stats.pl">[% t('Cash register') %]</a></li>
54	<li><a href="/cgi-bin/koha/reports/reserves_stats.pl">Holds</a></li>	55	<li><a href="/cgi-bin/koha/reports/reserves_stats.pl">[% t('Holds') %]</a></li>
55	</ul>	56	</ul>
56		57
57	[% IF UseKohaPlugins %]	58	[% IF UseKohaPlugins %]
58	<h2>Report plugins</h2>	59	<h2>[% t('Report plugins') %]</h2>
59	<ul>	60	<ul>
60	<li><a href="/cgi-bin/koha/plugins/plugins-home.pl?method=report">Report plugins</a></li>	61	<li><a href="/cgi-bin/koha/plugins/plugins-home.pl?method=report">[% t('Report plugins') %]</a></li>
61	</ul>	62	</ul>
62	[% END %]	63	[% END %]
63		64
64	</div>	65	</div>
65		66
66	<div class="col-xs-6"><h2>Top lists</h2>	67	<div class="col-xs-6"><h2>[% t('Top lists') %]</h2>
67	<ul>	68	<ul>
68	<li><a href="/cgi-bin/koha/reports/bor_issues_top.pl">Patrons with the most checkouts</a></li>	69	<li><a href="/cgi-bin/koha/reports/bor_issues_top.pl">[% t('Patrons with the most checkouts') %]</a></li>
69	<li><a href="/cgi-bin/koha/reports/cat_issues_top.pl">Most-circulated items</a></li>	70	<li><a href="/cgi-bin/koha/reports/cat_issues_top.pl">[% t('Most-circulated items') %]</a></li>
70	</ul>	71	</ul>
71		72
72	<h2>Inactive</h2>	73	<h2>[% t('Inactive') %]</h2>
73	<ul>	74	<ul>
74	<li><a href="/cgi-bin/koha/reports/borrowers_out.pl">Patrons who haven't checked out</a></li>	75	<li><a href="/cgi-bin/koha/reports/borrowers_out.pl">[% t('Patrons who haven\'t checked out') %]</a></li>
75	<li><a href="/cgi-bin/koha/reports/catalogue_out.pl">Items with no checkouts</a></li>	76	<li><a href="/cgi-bin/koha/reports/catalogue_out.pl">[% t('Items with no checkouts') %]</a></li>
76	</ul>	77	</ul>
77		78
78	<h2>Other</h2>	79	<h2>[% t('Other') %]</h2>
79	<ul>	80	<ul>
80	<li><a href="/cgi-bin/koha/reports/itemslost.pl">Items lost</a></li>	81	<li><a href="/cgi-bin/koha/reports/itemslost.pl">[% t('Items lost') %]</a></li>
81	<li><a href="/cgi-bin/koha/reports/orders_by_fund.pl">Orders by fund</a></li>	82	<li><a href="/cgi-bin/koha/reports/orders_by_fund.pl">[% t('Orders by fund') %]</a></li>
82	<li><a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">Catalog by item type</a></li>	83	<li><a href="/cgi-bin/koha/reports/manager.pl?report_name=itemtypes">[% t('Catalog by item type') %]</a></li>
83	<li><a href="/cgi-bin/koha/reports/issues_avg_stats.pl">Average loan time</a></li>	84	<li><a href="/cgi-bin/koha/reports/issues_avg_stats.pl">[% t('Average loan time') %]</a></li>
84	<li><a href="http://schema.koha-community.org/" target="blank">Koha database schema</a></li>	85	<li><a href="http://schema.koha-community.org/" target="blank">[% t('Koha database schema') %]</a></li>
85	<li><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="blank">Koha reports library</a></li>	86	<li><a href="http://wiki.koha-community.org/wiki/SQL_Reports_Library" target="blank">[% t('Koha reports library') %]</a></li>
86	</ul></div>	87	</ul></div>
87	</div>	88	</div>
88		89