Bug 20629: (follow-up) fix reverse_col value

[koha.git] / members / guarantor_search.pl

diff --git a/members/guarantor_search.pl b/members/guarantor_search.pl
index 6211cee..0287047 100755 (executable)
--- a/members/guarantor_search.pl
+++ b/members/guarantor_search.pl
@@ -1,100 +1,57 @@
 #!/usr/bin/perl
 
-# script to find a guarantor
-
-# Copyright 2006 OUEST PROVENCE
-#
 # This file is part of Koha.
 #
-# Koha is free software; you can redistribute it and/or modify it under the
-# terms of the GNU General Public License as published by the Free Software
-# Foundation; either version 2 of the License, or (at your option) any later
-# version.
+# Copyright 2014 BibLibre
 #
-# Koha is distributed in the hope that it will be useful, but WITHOUT ANY
-# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
-# A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+# Koha is free software; you can redistribute it and/or modify it
+# under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 3 of the License, or
+# (at your option) any later version.
 #
-# You should have received a copy of the GNU General Public License along
-# with Koha; if not, write to the Free Software Foundation, Inc.,
-# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+# Koha is distributed in the hope that it will be useful, but
+# WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
 
 use Modern::Perl;
 
-use CGI;
-
+use CGI qw ( -utf8 );
 use C4::Auth;
 use C4::Output;
-use C4::Dates qw/format_date/;
 use C4::Members;
 
+use Koha::Patron::Categories;
+
 my $input = new CGI;
-my ( $template, $loggedinuser, $cookie );
 
-( $template, $loggedinuser, $cookie ) = get_template_and_user(
-    {
-        template_name   => "members/guarantor_search.tmpl",
+my $dbh = C4::Context->dbh;
+
+my ( $template, $loggedinuser, $cookie, $staff_flags ) = get_template_and_user(
+    {   template_name   => "common/patron_search.tt",
         query           => $input,
         type            => "intranet",
         authnotrequired => 0,
-        flagsrequired   => { borrowers => 1 },
-        debug           => 1,
+        flagsrequired   => { borrowers => 'edit_borrowers' },
     }
 );
 
-my $member        = $input->param('member');
-my $orderby       = $input->param('orderby');
-my $category_type = $input->param('category_type');
-
-$orderby = "surname,firstname" unless $orderby;
-$member =~ s/,//g;     #remove any commas from search string
-$member =~ s/\*/%/g;
-
-$template->param( results => $member );
+my $q = $input->param('q') || '';
+my $op = $input->param('op') || '';
 
-my $search_category = 'A';
-if ( $category_type eq 'P' ) {
-    $search_category = 'I';
-}
-
-my ( $count, $results );
-my @resultsdata;
-
-if ( $member ne '' ) {
-    $results =
-      Search( { '' => $member, category_type => $search_category }, $orderby );
-
-    $count = $results ? @$results : 0;
-
-    for ( my $i = 0 ; $i < $count ; $i++ ) {
-        my %row = (
-            count          => $i + 1,
-            borrowernumber => $results->[$i]{'borrowernumber'},
-            cardnumber     => $results->[$i]{'cardnumber'},
-            surname        => $results->[$i]{'surname'},
-            firstname      => $results->[$i]{'firstname'},
-            categorycode   => $results->[$i]{'categorycode'},
-            streetnumber   => $results->[$i]{'streetnumber'},
-            address        => $results->[$i]{'address'},
-            address2       => $results->[$i]{'address2'},
-            city           => $results->[$i]{'city'},
-            state          => $results->[$i]{'state'},
-            zipcode        => $results->[$i]{'zipcode'},
-            country        => $results->[$i]{'country'},
-            branchcode     => $results->[$i]{'branchcode'},
-            dateofbirth    => format_date( $results->[$i]{'dateofbirth'} ),
-            borrowernotes  => $results->[$i]{'borrowernotes'}
-        );
-
-        push( @resultsdata, \%row );
-    }
-}
+my $referer = $input->referer();
 
+my $patron_categories = Koha::Patron::Categories->search_limited;
 $template->param(
-    member        => $member,
-    numresults    => $count,
-    category_type => $category_type,
-    resultsloop   => \@resultsdata
+    view => ( $input->request_method() eq "GET" ) ? "show_form" : "show_results",
+    columns => ['cardnumber', 'name', 'dateofbirth', 'address', 'action' ],
+    json_template => 'members/tables/guarantor_search.tt',
+    selection_type => 'select',
+    alphabet        => ( C4::Context->preference('alphabet') || join ' ', 'A' .. 'Z' ),
+    categories      => $patron_categories,
+    aaSorting       => 1,
 );
-
-output_html_with_http_headers $input, $cookie, $template->output;
+output_html_with_http_headers( $input, $cookie, $template->output );