---
.../prog/en/modules/reports/borrowers_stats.tmpl | 6 +++---
reports/borrowers_stats.pl | 2 +-
2 files changed, 4 insertions(+), 4 deletions(-)
diff --git
a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_stats.tmpl
b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_stats.tmpl
index e2155d8..ba246ae 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_stats.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/reports/borrowers_stats.tmpl
@@ -221,7 +221,7 @@
</td>
</tr>
<!-- TMPL_IF name="SORT1_LOOP" -->
- <tr class="highlight">
+ <tr<!-- TMPL_UNLESS NAME="SORT1_LOOP" -->
class="highlight"<!-- /TMPL_UNLESS -->>
<td>Sort1</td>
<td><input type="radio" name="Line"
value="sort1" /></td>
<td><input type="radio" name="Column"
value="sort1" /></td>
@@ -229,14 +229,14 @@
<select id="sort1" size="1"
name="Filter">
<option value=""/>
<!-- TMPL_LOOP NAME="SORT1_LOOP" -->
- <option value="<!-- TMPL_VAR
NAME="authorized_value" -->"><!-- TMPL_VAR NAME="lib" --></option>
+ <option value="<!-- TMPL_VAR
NAME="value" -->"><!-- TMPL_VAR NAME="value" --></option>
<!-- /TMPL_LOOP -->
</select>
</td>
</tr>
<!-- /TMPL_IF -->
<!-- TMPL_IF name="SORT2_LOOP" -->
- <tr<!-- TMPL_UNLESS NAME="SORT1_LOOP" -->
class="highlight"<!-- /TMPL_UNLESS -->>
+ <tr<!-- TMPL_UNLESS NAME="SORT2_LOOP" -->
class="highlight"<!-- /TMPL_UNLESS -->>
<td>Sort2</td>
<td><input type="radio" name="Line"
value="sort2" /></td>
<td><input type="radio" name="Column"
value="sort2" /></td>
diff --git a/reports/borrowers_stats.pl b/reports/borrowers_stats.pl
index b225fdb..ed062cb 100755
--- a/reports/borrowers_stats.pl
+++ b/reports/borrowers_stats.pl
@@ -119,7 +119,7 @@ if ($do_it) {
$req = $dbh->prepare("SELECT DISTINCTROW zipcode FROM borrowers WHERE
zipcode IS NOT NULL AND zipcode <> '' ORDER BY zipcode");
$req->execute;
$template->param( ZIP_LOOP => $req->fetchall_arrayref({}));
- $req = $dbh->prepare("SELECT authorised_value,lib FROM
authorised_values WHERE category='Bsort1' ORDER BY lib");
+ $req = $dbh->prepare("SELECT DISTINCTROW sort1 AS value FROM borrowers
WHERE sort1 IS NOT NULL AND sort1 <> '' ORDER BY sort1 LIMIT 200");
$req->execute;
$template->param( SORT1_LOOP => $req->fetchall_arrayref({}));
$req = $dbh->prepare("SELECT DISTINCTROW sort2 AS value FROM borrowers
WHERE sort2 IS NOT NULL AND sort2 <> '' ORDER BY sort2 LIMIT 200");
--
1.5.6
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha.org/mailman/listinfo/koha-patches
