3 # Copyright 2013 BibLibre
5 # This file is part of Koha
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
23 use C4::Auth qw( get_template_and_user haspermission get_user_subpermissions );
24 use C4::Output qw( output_with_http_headers );
25 use C4::Utils::DataTables qw( dt_get_params );
26 use C4::Utils::DataTables::Members qw( search );
27 use Koha::DateUtils qw( output_pref dt_from_string );
32 exit unless $input->param('template_path');
34 my ($template, $user, $cookie) = get_template_and_user({
35 template_name => scalar $input->param('template_path'),
38 flagsrequired => { borrowers => 'edit_borrowers' }
41 my $searchmember = $input->param('searchmember');
42 my $firstletter = $input->param('firstletter');
43 my $categorycode = $input->param('categorycode');
44 my $branchcode = $input->param('branchcode');
45 my $searchtype = $input->param('searchtype');
46 my $searchfieldstype = $input->param('searchfieldstype') || 'standard';
47 my $has_permission = $input->param('has_permission');
48 my $selection_type = $input->param('selection_type');
50 # variable information for DataTables (id)
51 my $sEcho = $input->param('sEcho');
53 my %dt_params = dt_get_params($input);
54 foreach (grep {$_ =~ /^mDataProp/} keys %dt_params) {
55 $dt_params{$_} =~ s/^dt_//;
59 # If the user filled a term, maybe it's a cardnumber.
60 # This cannot be the case if a first letter is given.
64 and $searchfieldstype eq 'standard' )
66 my $member = Koha::Patrons->find( { cardnumber => $searchmember } );
69 iTotalDisplayRecords => 1,
70 patrons => [ $member->unblessed ],
74 if ($has_permission) {
75 my ( $permission, $subpermission ) = split /\./, $has_permission;
76 $has_permission = {permission => $permission, subpermission => $subpermission};
79 # Perform the patrons search
80 $results = C4::Utils::DataTables::Members::search(
82 searchmember => $searchmember,
83 firstletter => $firstletter,
84 categorycode => $categorycode,
85 branchcode => $branchcode,
86 searchtype => $searchtype,
87 searchfieldstype => $searchfieldstype,
88 dt_params => \%dt_params,
89 ( $has_permission ? ( has_permission => $has_permission ) : () ),
95 iTotalRecords => $results->{iTotalRecords},
96 iTotalDisplayRecords => $results->{iTotalDisplayRecords},
97 aaData => $results->{patrons},
98 selection_type => $selection_type,
101 output_with_http_headers $input, $cookie, $template->output, 'json';
107 search - a search script for finding patrons
111 This script provides a service for template for patron search using DataTables
113 =head2 Performing a search
115 Call this script from a DataTables table my $searchmember = $input->param('searchmember');
116 All following params are optional:
117 searchmember => the search terms
118 firstletter => search patrons with surname begins with this pattern (currently only used for 1 letter)
119 categorycode and branchcode => search patrons belong to a given categorycode or a branchcode
120 searchtype: can be 'contain' or 'start_with'
121 searchfieldstype: Can be 'standard', 'email', 'borrowernumber', 'userid', 'phone' or 'address'
129 Copyright 2013 BibLibre
131 This file is part of Koha.
133 Koha is free software; you can redistribute it and/or modify it under the
134 terms of the GNU General Public License as published by the Free Software
135 Foundation; either version 2 of the License, or (at your option) any later
138 Koha is free software; you can redistribute it and/or modify it
139 under the terms of the GNU General Public License as published by
140 the Free Software Foundation; either version 3 of the License, or
141 (at your option) any later version.
143 Koha is distributed in the hope that it will be useful, but
144 WITHOUT ANY WARRANTY; without even the implied warranty of
145 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
146 GNU General Public License for more details.
148 You should have received a copy of the GNU General Public License
149 along with Koha; if not, see <http://www.gnu.org/licenses>.