<p>Choose the report to run from the list</p>
<form action="/cgi-bin/koha/reports/guided_reports.pl">
<table>
-<tr><th>Report Name</th><th>Type</th><th>Notes</th><th>Saved Results</th><th>Saved SQL</th><th colspan="3"> </th></tr>
+<tr><th>Report Name</th><th>Type</th><th>Notes</th><th>Author</th><th>Creation Date</th><th>Saved Results</th><th>Saved SQL</th><th colspan="3"> </th></tr>
<!-- TMPL_LOOP NAME="savedreports" -->
<tr><td><!-- TMPL_VAR NAME="report_name" --></td>
<td><!-- TMPL_VAR NAME="type" --></td>
<td><!-- TMPL_VAR NAME="notes" --></td>
+<td><!-- TMPL_VAR NAME="borrowersurname" --><!-- TMPL_IF NAME="borrowerfirstname" -->, <!-- TMPL_VAR NAME="borrowerfirstname" --><!-- /TMPL_IF --> (<!-- TMPL_VAR NAME="borrowernumber" -->)</td>
+<td><!-- TMPL_VAR NAME="date_created" --></td>
<td><!-- TMPL_IF NAME="date_run" --><a href="/cgi-bin/koha/reports/guided_reports.pl?phase=retrieve%20results&id=<!-- TMPL_VAR NAME="id" -->"><!-- TMPL_VAR NAME="date_run" --></a><!-- /TMPL_IF -->
</td>
<td><a href="/cgi-bin/koha/reports/guided_reports.pl?reports=<!-- TMPL_VAR NAME="id" -->&phase=Show%20SQL">Show SQL</a>
<h3>Step 3 of 6: Select Columns for Display</h3>
<p>Note: Be careful selecting when selecting columns. If your choice is too broad it could result in a very large report that will either not complete, or slow your system down.</p>
-<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
+<form id="column_submit" action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<input type="hidden" name="area" value="<!-- TMPL_VAR NAME="area" -->" />
<input type="hidden" name="type" value="<!-- TMPL_VAR NAME="type" -->" />
<fieldset>
</div>
<div class="yui-u">
-<select id="selectedColumns" name="columns" multiple="multiple" size="25" style="min-width:200px;height:300px;"></select>
+<select id="selectedColumns" name="columns" multiple="multiple" size="25" style="width:200px; height:300px;"></select>
</div>
</div>
</fieldset>
<!-- TMPL_IF NAME="editsql" -->
<form action="/cgi-bin/koha/reports/guided_reports.pl" method="post">
<input type="hidden" name="phase" value="Update SQL" />
-<input type="hidden" name="id" value="<!-- TMPL_VAR NAME="id" -->">
+<input type="hidden" name="id" value="<!-- TMPL_VAR NAME="id" -->"/>
<fieldset class="rows">
<legend>Edit SQL</legend>
<ol>
-<li><label for="reportname">Report Name:</label><input type="text" id="reportname" name="reportname" value="<!-- TMPL_VAR NAME="reportname" -->" ></li>
-<li><textarea id="sql" name="sql"><!-- TMPL_VAR NAME="sql" --></textarea></li>
+<li><label for="reportname">Report Name:</label><input type="text" id="reportname" name="reportname" value="<!-- TMPL_VAR NAME="reportname" -->" /></li>
+<li><label for="notes">Notes:</label><textarea id="notes" name="notes" cols="50" rows="2"><!-- TMPL_VAR NAME="notes" --></textarea></li>
+<li><textarea id="sql" name="sql" rows="10" cols="60"><!-- TMPL_VAR NAME="sql" --></textarea></li>
</ol>
</fieldset>
</div>
<script type="text/javascript">
//<![CDATA[
-function setObjects() {
- selectedColumnsObj=document.getElementById('selectedColumns');
- availableColumnsObj=document.getElementById('availableColumns');
-}
-setObjects();
-
function addColumn() {
- for (i=0;i<availableColumnsObj.length;i++) {
- if (availableColumnsObj.options[i].selected==true) {
- var newColumnObj=document.createElement("OPTION");
- newColumnObj.value=availableColumnsObj.options[i].value;
- newColumnObj.text=availableColumnsObj.options[i].text;
- selectedColumnsObj.appendChild(newColumnObj);
- newColumnObj.selected=true;
- }
- }
+ $("#availableColumns option:selected").clone().appendTo("#selectedColumns").attr("selected", "selected");
}
-
function delColumn() {
- for (i=0;i<=selectedColumnsObj.options.length;i++) {
- if (selectedColumnsObj.options.selectedIndex>=0)
- selectedColumnsObj.remove(selectedColumnsObj.options.selectedIndex)
- }
+ $("#selectedColumns option:selected").remove();
}
+$("#column_submit").submit(function() {
+ if ($("#selectedColumns option").size() < 1) {
+ alert(_("No columns selected!"));
+ return false;
+ }
+ $("#selectedColumns option").attr("selected", "selected"); // Select everything still in #selectedColumns
+ return true;
+});
//]]>
</script>
<!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->