@@ -, +, @@
patron search.
---
C4/Utils/DataTables/Members.pm | 10 ++++
.../prog/en/modules/common/patron_search.tt | 52 +++++++++++++++++++
.../patroncards/tables/members_results.tt | 2 +
patroncards/add_user_search.pl | 8 ++-
svc/members/search | 4 ++
5 files changed, 75 insertions(+), 1 deletion(-)
--- a/C4/Utils/DataTables/Members.pm
+++ a/C4/Utils/DataTables/Members.pm
@@ -11,6 +11,8 @@ sub search {
my $firstletter = $params->{firstletter};
my $categorycode = $params->{categorycode};
my $branchcode = $params->{branchcode};
+ my $sort1 = $params->{sort1};
+ my $sort2 = $params->{sort2};
my $searchtype = $params->{searchtype} || 'contain';
my $searchfieldstype = $params->{searchfieldstype} || 'standard';
my $has_permission = $params->{has_permission};
@@ -111,6 +113,14 @@ sub search {
push @where_strs, "borrowers.branchcode IN (" . join( ',', ('?') x @restricted_branchcodes ) . ")";
push @where_args, @restricted_branchcodes;
}
+ if(defined $sort1 and $sort1 ne '') {
+ push @where_strs, "borrowers.sort1 = ?";
+ push @where_args, $sort1;
+ }
+ if(defined $sort2 and $sort2 ne '') {
+ push @where_strs, "borrowers.sort2 = ?";
+ push @where_args, $sort2;
+ }
my $searchfields = {
standard => C4::Context->preference('DefaultPatronSearchFields') || 'surname,firstname,othernames,cardnumber,userid',
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/common/patron_search.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/common/patron_search.tt
@@ -42,6 +42,24 @@
[% END %]
+
+
+
+
+
+
+
+