3 # Copyright 2013 BibLibre
5 # This file is part of Koha
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
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 );
31 exit unless $input->param('template_path');
33 my ($template, $user, $cookie) = get_template_and_user({
34 template_name => $input->param('template_path'),
38 flagsrequired => { borrowers => 1 }
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');
49 if ( $searchfieldstype eq "dateofbirth" ) {
50 $searchmember = output_pref({dt => dt_from_string($searchmember), dateformat => 'iso', dateonly => 1});
53 # variable information for DataTables (id)
54 my $sEcho = $input->param('sEcho');
56 my %dt_params = dt_get_params($input);
57 foreach (grep {$_ =~ /^mDataProp/} keys %dt_params) {
58 $dt_params{$_} =~ s/^dt_//;
62 # If the user filled a term, maybe it's a cardnumber.
63 # This cannot be the case if a first letter is given.
66 and $searchfieldstype eq 'standard' )
68 my $member = C4::Members::GetMember( cardnumber => $searchmember );
71 iTotalDisplayRecords => 1,
72 patrons => [ $member ],
76 # Perform the patrons search
77 $results = C4::Utils::DataTables::Members::search(
79 searchmember => $searchmember,
80 firstletter => $firstletter,
81 categorycode => $categorycode,
82 branchcode => $branchcode,
83 searchtype => $searchtype,
84 searchfieldstype => $searchfieldstype,
85 dt_params => \%dt_params,
89 # It is not recommanded to use the has_permission param if you use the pagination
90 # The filter is done AFTER requested the data
91 if ($has_permission) {
92 my ( $permission, $subpermission ) = split /\./, $has_permission;
93 my @patrons_with_permission;
94 for my $patron ( @{ $results->{patrons} } ) {
95 my $perms = haspermission( $patron->{userid} );
96 if ( $perms->{superlibrarian} == 1
97 or $perms->{$permission} == 1 )
99 push @patrons_with_permission, $patron;
103 if ($subpermission) {
104 my $subperms = get_user_subpermissions( $patron->{userid} );
105 push @patrons_with_permission, $patron
106 if $subperms->{$permission}->{$subpermission};
109 $results->{patrons} = \@patrons_with_permission;
110 $results->{iTotalDisplayRecords} = scalar( @patrons_with_permission );
115 iTotalRecords => $results->{iTotalRecords},
116 iTotalDisplayRecords => $results->{iTotalDisplayRecords},
117 aaData => $results->{patrons}
120 output_with_http_headers $input, $cookie, $template->output, 'json';
126 search - a search script for finding patrons
130 This script provides a service for template for patron search using DataTables
132 =head2 Performing a search
134 Call this script from a DataTables table my $searchmember = $input->param('searchmember');
135 All following params are optional:
136 searchmember => the search terms
137 firstletter => search patrons with surname begins with this pattern (currently only used for 1 letter)
138 categorycode and branchcode => search patrons belong to a given categorycode or a branchcode
139 searchtype: can be 'contain' or 'start_with'
140 searchfieldstype: Can be 'standard', 'email', 'borrowernumber', 'phone' or 'address'
148 Copyright 2013 BibLibre
150 This file is part of Koha.
152 Koha is free software; you can redistribute it and/or modify it under the
153 terms of the GNU General Public License as published by the Free Software
154 Foundation; either version 2 of the License, or (at your option) any later
157 Koha is distributed in the hope that it will be useful, but WITHOUT ANY
158 WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
159 A PARTICULAR PURPOSE. See the GNU General Public License for more details.
161 You should have received a copy of the GNU General Public License along
162 with Koha; if not, write to the Free Software Foundation, Inc.,
163 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.