Bug 13897: Surround columns with backticks
[koha.git] / members / members-update.pl
blob84019f4e20a45b2211351d6ac4929b8306bb1d3c
1 #!/usr/bin/perl
3 # Parts Copyright Biblibre 2010
4 # This file is part of Koha.
6 # Koha is free software; you can redistribute it and/or modify it
7 # under the terms of the GNU General Public License as published by
8 # the Free Software Foundation; either version 3 of the License, or
9 # (at your option) any later version.
11 # Koha is distributed in the hope that it will be useful, but
12 # WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License
17 # along with Koha; if not, see <http://www.gnu.org/licenses>.
19 use Modern::Perl;
21 use CGI qw ( -utf8 );
23 use C4::Auth;
24 use C4::Output;
25 use C4::Context;
26 use C4::Members;
27 use Koha::Patron::Attribute::Types;
28 use Koha::Patron::Attributes;
29 use Koha::Patron::Modifications;
30 use Koha::Patrons;
32 use List::MoreUtils qw( uniq );
34 my $query = new CGI;
36 my ( $template, $loggedinuser, $cookie, $flags ) = get_template_and_user(
37 { template_name => "members/members-update.tt",
38 query => $query,
39 type => "intranet",
40 authnotrequired => 0,
41 flagsrequired => { borrowers => 'edit_borrowers' },
42 debug => 1,
46 my $branch
47 = ( C4::Context->preference("IndependentBranchesPatronModifications")
48 || C4::Context->preference("IndependentBranches") )
49 && !$flags->{'superlibrarian'}
50 ? C4::Context->userenv()->{'branch'}
51 : undef;
53 my $pending_modifications = Koha::Patron::Modifications->pending($branch);
55 my $borrowers;
56 foreach my $pm (@$pending_modifications) {
58 my @modified_atypes = uniq( map { $_->code } @{ $pm->{extended_attributes} } );
59 my $modified_attributes;
61 foreach my $type (@modified_atypes) {
62 my $type_obj = Koha::Patron::Attribute::Types->find($type);
63 my @before = Koha::Patron::Attributes->search(
64 { borrowernumber => $pm->{borrowernumber}, code => $type } );
65 my @after = grep { $_->code eq $type } @{ $pm->{extended_attributes} };
66 push @{$modified_attributes}, { type => $type_obj, before => \@before, after => \@after };
69 $borrowers->{ $pm->{borrowernumber} } = Koha::Patrons->find($pm->{borrowernumber})->unblessed;
70 $borrowers->{ $pm->{borrowernumber} }->{modified_attributes} = $modified_attributes;
73 $template->param(
74 PendingModifications => $pending_modifications,
75 borrowers => $borrowers
78 output_html_with_http_headers $query, $cookie, $template->output;