Bug 25184: (RM follow-up) Make DB update idempotent
[koha.git] / members / update-child.pl
blob42cfe27d80eaa47850b3aeba0832b3a3af589486
1 #!/usr/bin/perl
3 # Copyright 2000-2002 Katipo Communications
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>.
20 =head1 updatechild.pl
22 script to update a child member to (usually) an adult member category
24 - if called with op=multi, will return all available non child categories, for selection.
25 - if called with op=update, script will update member record via Koha::Patron->store.
27 =cut
29 use Modern::Perl;
30 use CGI qw ( -utf8 );
31 use C4::Context;
32 use C4::Auth;
33 use C4::Output;
34 use Koha::Patrons;
35 use Koha::Patron::Categories;
36 use Koha::Patrons;
38 # use Smart::Comments;
40 my $dbh = C4::Context->dbh;
41 my $input = new CGI;
43 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
45 template_name => "members/update-child.tt",
46 query => $input,
47 type => "intranet",
48 authnotrequired => 0,
49 flagsrequired => { borrowers => 'edit_borrowers' },
50 debug => 1,
54 my $borrowernumber = $input->param('borrowernumber');
55 my $catcode = $input->param('catcode');
56 my $cattype = $input->param('cattype');
57 my $op = $input->param('op');
59 my $logged_in_user = Koha::Patrons->find( $loggedinuser );
61 my $patron_categories = Koha::Patron::Categories->search_limited({ category_type => 'A' }, {order_by => ['categorycode']});
62 if ( $op eq 'multi' ) {
63 # FIXME - what are the possible upgrade paths? C -> A , C -> S ...
64 # currently just allowing C -> A
65 $template->param(
66 MULTI => 1,
67 borrowernumber => $borrowernumber,
68 patron_categories => $patron_categories,
70 output_html_with_http_headers $input, $cookie, $template->output;
72 elsif ( $op eq 'update' ) {
73 my $patron = Koha::Patrons->find( $borrowernumber );
74 output_and_exit_if_error( $input, $cookie, $template, { module => 'members', logged_in_user => $logged_in_user, current_patron => $patron } );
76 my $adult_category;
77 if ( $patron_categories->count == 1 ) {
78 $adult_category = $patron_categories->next;
79 } else {
80 $adult_category = $patron_categories->search({'me.categorycode' => $catcode })->next;
83 # Just in case someone is trying something bad
84 # But we should not hit that with a normal use of the interface
85 die "You are doing something wrong updating this child" unless $adult_category;
87 $_->delete() for $patron->guarantor_relationships();
89 $patron->categorycode($adult_category->categorycode);
90 $patron->store;
92 # FIXME We should not need that
93 # We could redirect with a friendly message
94 if ( $patron_categories->count > 1 ) {
95 $template->param(
96 SUCCESS => 1,
97 borrowernumber => $borrowernumber,
99 output_html_with_http_headers $input, $cookie, $template->output;
101 else {
102 print $input->redirect(
103 "/cgi-bin/koha/members/moremember.pl?borrowernumber=$borrowernumber"