<!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
-<title>Koha › Reports</title>
+<title>Koha › Reports › Checkout statistics <!-- TMPL_IF NAME="do_it" -->› Results<!-- /TMPL_IF --></title>
<!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
-<!--TMPL_INCLUDE NAME="menus.inc" --><!-- TMPL_INCLUDE NAME="menu-reports.inc"-->
-<!-- Additions to enable Calendar system -->
-<link rel="stylesheet" type="text/css" href="<!-- TMPL_VAR name="themelang" -->/lib/calendar/calendar-system.css" />
-<!-- End of additions --><!-- Additions to enable Calendar system -->
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/calendar/calendar.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/calendar/calendar-en.js"></script>
-<script type="text/javascript" src="<!-- TMPL_VAR name="themelang" -->/lib/calendar/calendar-setup.js"></script>
-<!-- End of additions -->
+<!-- TMPL_INCLUDE NAME="calendar.inc" -->
+<style type="text/css">
+ .sql {display:none;}
+</style>
+</head>
+<body>
+<!-- TMPL_INCLUDE NAME="header.inc" -->
+<!-- TMPL_INCLUDE NAME="cat-search.inc" -->
+<div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/reports/reports-home.pl">Reports</a> <!-- TMPL_IF NAME="do_it" -->› <a href="/cgi-bin/koha/reports/issues_stats.pl">Checkout statistics</a> › Results <!-- TMPL_ELSE -->› Checkout statistics<!-- /TMPL_IF --></div>
+
+<div id="doc3" class="yui-t2">
+
+ <div id="bd">
+ <div id="yui-main">
+ <div class="yui-b">
<!-- TMPL_IF NAME="do_it" -->
<!-- TMPL_LOOP NAME="mainloop" -->
- <h1>Checkouts statistics </h1>
+ <h1>Checkout statistics</h1>
<!-- TMPL_IF NAME="loopfilter" -->
<p>Filtered on</p>
<ul>
<!-- TMPL_LOOP NAME="loopfilter" -->
- <li><!-- TMPL_IF NAME="err" --> <!--/TMPL_IF --> <!-- TMPL_VAR NAME="crit"--> <!-- TMPL_VAR NAME="filter"--><!-- TMPL_IF NAME="err" --> <!--/TMPL_IF --></li>
+ <!-- TMPL_IF NAME="err" --><li class="error">Error:
+ <!-- TMPL_ELSIF NAME="sql" --><li class="sql">
+ <!-- TMPL_ELSE --><li>
+ <!--/TMPL_IF -->
+ <!-- TMPL_VAR NAME="crit"--> <!-- TMPL_VAR NAME="filter"-->
+ </li>
<!-- /TMPL_LOOP -->
</ul>
<!-- /TMPL_IF -->
<table>
- <tr >
+ <tr>
<th><!-- TMPL_VAR name="line" --> / <!-- TMPL_VAR name="column" --></th>
<!-- TMPL_LOOP NAME="loopcol" -->
- <th><!-- TMPL_VAR NAME="coltitle" --></th>
+ <th><!-- TMPL_VAR ESCAPE="HTML" NAME="coltitle_display" --></th>
<!-- /TMPL_LOOP -->
<th>TOTAL</th>
</tr>
- <!-- TMPL_LOOP NAME="looprow" -->
- <tr>
- <!-- TMPL_IF NAME="hilighted" --><td class="hilighted"><!-- TMPL_ELSE --><td><!-- /TMPL_IF -->
- <!-- TMPL_VAR NAME="rowtitle" --></td>
- <!-- TMPL_LOOP NAME="loopcell" -->
- <!-- TMPL_IF NAME="hilighted" --><td><!-- TMPL_ELSE --><td><!-- /TMPL_IF -->
- <!-- TMPL_IF NAME="value" --><!-- TMPL_VAR NAME="value" -->
- <!-- TMPL_ELSE -->
- <!-- /TMPL_IF -->
- </td>
- <!-- /TMPL_LOOP -->
- <!-- TMPL_IF NAME="hilighted" --><td><!-- TMPL_ELSE --><td><!-- /TMPL_IF -->
- <!-- TMPL_VAR NAME="totalrow" -->
- </td>
- </tr>
- <!-- /TMPL_LOOP -->
- <tr >
- <th>TOTAL</th>
- <!-- TMPL_LOOP NAME="loopfooter" -->
- <th>
- <!-- TMPL_VAR NAME="totalcol" -->
- </th>
- <!-- /TMPL_LOOP -->
- <th><!-- TMPL_VAR NAME="total" --></th>
- </tr>
+ <!-- TMPL_LOOP NAME="looprow" -->
+ <tr<!-- TMPL_UNLESS NAME="__odd__" --> class="highlight"<!-- /TMPL_UNLESS -->>
+ <td><!-- TMPL_VAR ESCAPE="HTML" NAME="rowtitle_display" DEFAULT="UNKNOWN VALUE" --></td>
+ <!-- TMPL_LOOP NAME="loopcell" -->
+ <td><!-- TMPL_VAR NAME="value" DEFAULT=" " --></td>
+ <!-- /TMPL_LOOP -->
+ <td><!-- TMPL_VAR NAME="totalrow" --></td>
+ </tr>
+ <!-- /TMPL_LOOP -->
+ <tr>
+ <th>TOTAL</th>
+ <!-- TMPL_LOOP NAME="loopfooter" -->
+ <th><!-- TMPL_VAR NAME="totalcol" --></th>
+ <!-- /TMPL_LOOP -->
+ <th><!-- TMPL_VAR NAME="total" --></th>
+ </tr>
</table>
<!-- /TMPL_LOOP -->
<!-- TMPL_ELSE -->
- <h1>Checkouts statistics </h1>
- <form method="post">
- <table>
+
+ <form method="post" action="/cgi-bin/koha/reports/issues_stats.pl">
+ <fieldset class="rows">
+ <legend>Checkout statistics</legend><table>
<thead>
<tr>
- <th><div>Title</th>
+ <th>Title</th>
<th>Row</th>
<th>Column</th>
<th>Filter</th>
</tr>
</thead>
<tbody>
- <tr class="hilighted">
+ <tr>
<td>Period</td>
<td><input type="radio" name="Line" value="datetime" /></td>
<td><input type="radio" name="Column" value="datetime" /></td>
- <td > From <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
- <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" border="0" hspace="0" vspace="0" id="openCalendarFrom" style="cursor: pointer;" valign="top">
- <script language="JavaScript" type="text/javascript">
- function validate1(date) {
+ <td><label for="from">From</label> <input type="text" readonly="readonly" size="10" id="from" name="Filter" />
+ <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" alt="Show Calendar" border="0" id="openCalendarFrom" style="cursor: pointer;" />
+ <script type="text/javascript">
+ //<![CDATA[
+ function validate1(date) {
var day = date.getDate();
var month = date.getMonth() + 1;
var year = date.getFullYear();
var dateTo = document.getElementById('to').value.split("-");
var limitDate = new Date(dateTo[0], (dateTo[1] - 1), dateTo[2]);
if (date > limitDate) {
- return true;
+ return true;
} else {
- return false;
- }
+ return false;
}
- Calendar.setup(
- {
+ }
+ Calendar.setup({
inputField : "from",
- ifFormat : "%Y-%m-%d",
+ ifFormat : "<!-- TMPL_VAR NAME="DHTMLcalendar_dateformat" -->",
button : "openCalendarFrom",
disableFunc : validate1,
dateStatusFunc : validate1
- }
- );
- </script>
- To <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
- <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" id="openCalendarTo" style="cursor: pointer;" valign="top" border="0" hspace="0" vspace="0">
- <script type="text/javascript">
- function validate2(date) {
- var day = date.getDate();
- var month = date.getMonth() + 1;
- var year = date.getFullYear();
- var weekDay = date.getDay();
- var dayMonth = month + '-' + day;
- var dateString = year + '-' + month + '-' + day;
- var dateFrom = document.getElementById('from').value.split("-");
- var limitDate = new Date(dateFrom[0], (dateFrom[1] - 1), dateFrom[2]);
- if (limitDate > date) {
- return true;
- } else {
- return false;
- }
- }
-
- Calendar.setup(
- {
- inputField : "to",
- ifFormat : "%Y-%m-%d",
- button : "openCalendarTo",
- disableFunc : validate2,
- dateStatusFunc : validate2
- }
- );
- </script>
+ });
+ //]]>
+ </script>
+ <label for="to">To</label> <input readonly="readonly" size="10" id="to" name="Filter" value="" type="text" />
+ <img src="<!-- TMPL_VAR Name="themelang" -->/lib/calendar/cal.gif" alt="Show Calendar" id="openCalendarTo" style="cursor: pointer;" border="0" />
+ <script type="text/javascript">
+ //<![CDATA[
+ function validate2(date) {
+ var day = date.getDate();
+ var month = date.getMonth() + 1;
+ var year = date.getFullYear();
+ var weekDay = date.getDay();
+ var dayMonth = month + '-' + day;
+ var dateString = year + '-' + month + '-' + day;
+ var dateFrom = document.getElementById('from').value.split("-");
+ var limitDate = new Date(dateFrom[0], (dateFrom[1] - 1), dateFrom[2]);
+ if (limitDate > date) {
+ return true;
+ } else {
+ return false;
+ }
+ }
+ Calendar.setup({
+ inputField : "to",
+ ifFormat : "<!-- TMPL_VAR NAME="DHTMLcalendar_dateformat" -->",
+ button : "openCalendarTo",
+ disableFunc : validate2,
+ dateStatusFunc : validate2
+ });
+ //]]>
+ </script>
</td>
</tr>
- <tr class="hilighted">
- <td>Type :<select name="PeriodTypeSel">
- <option value ="issue">Issue</option>
- <option value ="return">Return</option>
+ <tr class="highlight">
+ <td><label for="PeriodTypeSel">Type:</label><select name="PeriodTypeSel" id="PeriodTypeSel">
+ <option value ="issue">Checkout</option>
+ <option value ="renew">Renewal</option>
+ <option value ="return">Checkin</option>
+ <option value ="localuse">Local Use</option>
</select></td>
- <td colspan="2">group by <select name="DisplayBy">
+ <td colspan="2"><label for="DisplayBy">group by</label> <select name="DisplayBy" id="DisplayBy">
<option value="">None</option>
<option value ="1">Day of week</option>
<option value ="2">Month</option>
</select>
</td>
<td>
- Select Day : <select name="PeriodDaySel">
+ <label for="PeriodDaySel">Select Day: </label><select name="PeriodDaySel" id="PeriodDaySel">
<option value =""></option>
<option value ="Monday">Monday</option>
<option value ="Tuesday">Tuesday</option>
<option value ="Saturday">Saturday</option>
<option value ="Sunday">Sunday</option>
</select>
- Select Month : <select name="PeriodMonthSel">
+ <label for="PeriodMonthSel">Select Month:</label> <select name="PeriodMonthSel" id="PeriodMonthSel">
<option value =""></option>
<option value ="January">January</option>
<option value ="February">February</option>
</select>
</td>
</tr>
- <tr >
+ <tr>
<td>Patron Category</td>
<td><input type="radio" name="Line" value="borrowers.categorycode" /></td>
<td><input type="radio" name="Column" value="borrowers.categorycode" /></td>
- <td><!-- TMPL_VAR NAME="CGIBorCat" --></td>
+ <td><select name="Filter" id="borcat">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="categoryloop" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="categorycode" -->" selected="selected"><!-- TMPL_VAR NAME="description" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="categorycode" -->"><!-- TMPL_VAR NAME="description" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
</tr>
- <tr class="hilighted">
- <td>Document Type</td>
+ <tr class="highlight">
+ <td>Item Type</td>
<td><input type="radio" name="Line" value="itemtype" /></td>
<td><input type="radio" name="Column" value="itemtype" /></td>
- <td ><!-- TMPL_VAR NAME="CGIItemType" --></td>
+ <td><select name="Filter" id="itemtype">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="itemtypeloop" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="code" -->" selected="selected"><!-- TMPL_VAR NAME="description" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="code" -->"><!-- TMPL_VAR NAME="description" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
</tr>
<tr>
- <td>Branch</td>
+ <td>Library</td>
<td><input type="radio" name="Line" value="branch" /></td>
<td><input type="radio" name="Column" value="branch" /></td>
- <td><!-- TMPL_VAR NAME="CGIBranch" --></td>
+ <td><select name="Filter" id="branch">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="branchloop" -->
+<!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="value" -->" selected="selected"><!-- TMPL_VAR NAME="branchname" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="value" -->"><!-- TMPL_VAR NAME="branchname" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
</tr>
- <tr>
- <td>Location</td>
- <td><input type="radio" name="Line" value="location" /></td>
- <td><input type="radio" name="Column" value="location" /></td>
- <td><!-- TMPL_VAR NAME="CGILocation" --></td>
+ <tr class="highlight">
+ <td>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>
+ <!-- TMPL_LOOP NAME="ccodeloop" -->
+ <!-- TMPL_IF NAME="selected" --> <option value="<!-- TMPL_VAR NAME="code" -->" selected="selected"><!-- TMPL_VAR NAME="description" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="code" -->"><!-- TMPL_VAR NAME="description" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
</tr>
<tr>
- <td>Item Callnumber</td>
+ <td>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">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="locationloop" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="code" -->" selected="selected"><!-- TMPL_VAR NAME="description" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="code" -->"><!-- TMPL_VAR NAME="description" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
+ </tr>
+ <tr class="highlight">
+ <td>Item Call Number</td>
<td></td>
<td></td>
- <td>From <input type="text" name="Filter" size="10" /> (included) to <input type="text" name="Filter" size="10" /> (excluded) </td>
+ <td>From <input type="text" name="Filter" size="10" /> (inclusive) to <input type="text" name="Filter" size="10" /> (exclusive) </td>
</tr>
<!-- TMPL_IF Name="hassort1" -->
- <tr class="hilighted">
- <td>Patron sort1</td>
- <td><input type="radio" name="Line" value="borrowers.sort1" /></td>
- <td><input type="radio" name="Column" value="borrowers.sort1" /></td>
- <td><!-- TMPL_VAR NAME="CGISort1" --> </td>
- </tr>
+ <tr><td>Patron sort1</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>
+ <!-- TMPL_LOOP NAME="Bsort1" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="authorised_value" -->" selected="selected"><!-- TMPL_VAR NAME="lib" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="authorised_value" -->" ><!-- TMPL_VAR NAME="lib" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
+ </tr>
<!-- /TMPL_IF -->
<!-- TMPL_IF Name="hassort2" -->
- <!-- TMPL_IF Name="HglghtSort2"--><tr class="hilighted"> <!-- TMPL_ELSE --><tr><!--/TMPL_IF -->
- <td>Patron sort2</td>
- <td><input type="radio" name="Line" value="borrowers.sort2" /></td>
- <td><input type="radio" name="Column" value="borrowers.sort2" /></td>
- <td><!-- TMPL_VAR NAME="CGISort2" --> </td>
- </tr>
+ <tr class="highlight"><td>Patron sort2</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>
+ <!-- TMPL_LOOP NAME="Bsort2" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="authorised_value" -->" selected="selected"><!-- TMPL_VAR NAME="lib" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="authorised_value" -->" ><!-- TMPL_VAR NAME="lib" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
+ </tr>
<!-- /TMPL_IF -->
- <tr></tr>
+ <tr><td>Home branch</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">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="branchloop" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="value" -->" selected="selected"><!-- TMPL_VAR NAME="branchname" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="value" -->"><!-- TMPL_VAR NAME="branchname" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
+ </tr>
+
+ <tr><td>Holding branch</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">
+ <option value=""> </option>
+ <!-- TMPL_LOOP NAME="branchloop" -->
+ <!-- TMPL_IF NAME="selected" --><option value="<!-- TMPL_VAR NAME="value" -->" selected="selected"><!-- TMPL_VAR NAME="branchname" --></option><!-- TMPL_ELSE --><option value="<!-- TMPL_VAR NAME="value" -->"><!-- TMPL_VAR NAME="branchname" --></option><!-- /TMPL_IF -->
+ <!-- /TMPL_LOOP -->
+ </select>
+ </td>
+ </tr>
+
</tbody>
- </table>
- <h3> Cell value </h3>
- <p><input type="radio" name="Cellvalue" value="1" checked="checked" /> Count checkouts </p>
- <p><input type="radio" name="Cellvalue" value="3" /> Circulation rate </p>
- <h3> Output </h3>
- <input type="radio" checked name="output" value="screen" /> To screen into the browser
- <input type="radio" name="output" value="file"> To file <input type="text" name="basename" value="Export" /> into an application
- <!-- TMPL_VAR NAME="CGIextChoice" -->
- <!-- TMPL_VAR NAME="CGIsepChoice" -->
- </p>
- <p>
- <input type="submit" value="OK" />
- <input type="hidden" name="report_name" value="<!--TMPL_VAR NAME="report_name" -->" />
- <input type="hidden" name="do_it" value="1" />
- </form>
+ </table><br /></fieldset>
+
+<fieldset class="rows"><legend>Cell value </legend><ol><li><label for="cellvalue1">Count total items</label> <input type="radio" name="Cellvalue" value="1" id="cellvalue1" checked="checked" /> </li>
+ <li><label for="cellvalue3">Count unique items</label> <input type="radio" name="Cellvalue" id="cellvalue3" value="3" /> </li></ol></fieldset>
+
+ <fieldset class="rows">
+ <legend>Output</legend>
+<ol><li><label for="outputscreen">To screen into the browser: </label><input type="radio" checked="checked" name="output" id="outputscreen" value="screen" /> </li>
+<li><label for="outputfile">To a file:</label> <input type="radio" name="output" value="file" id="outputfile" /> <label class="inline" for="basename">Named: </label><input type="text" name="basename" id="basename" value="Export" /> <label class="inline" for="MIME">Into an application
+ </label><!-- TMPL_VAR NAME="CGIextChoice" -->
+ <!-- TMPL_VAR NAME="CGIsepChoice" --></li></ol>
+ </fieldset>
+
+ <fieldset class="action">
+ <input type="submit" value="Submit" />
+ <input type="hidden" name="report_name" value="<!--TMPL_VAR NAME="report_name" -->" />
+ <input type="hidden" name="do_it" value="1" />
+ </fieldset>
+ </form>
<!-- /TMPL_IF -->
+</div>
+</div>
+<div class="yui-b">
+<!-- TMPL_INCLUDE NAME="reports-menu.inc" -->
+</div>
+</div>
<!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->