[Koha-patches] [PATCH] Correction in Patron Statistics Report(Sort1 & Sort2 filter)

[Amit Gupta]

---
 .../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