Bug 10021: Remove accountlines columns - DBIC Schema changes
[koha.git] / members / setstatus.pl
blobf00bcbaf4d1aa82fd86a80443fd677a9bb493808
1 #!/usr/bin/perl
3 #script to set or lift debarred status
4 #written 2/8/04
5 #by oleonard@athenscounty.lib.oh.us
8 # Copyright 2000-2002 Katipo Communications
9 # Parts copyright 2010 BibLibre
11 # This file is part of Koha.
13 # Koha is free software; you can redistribute it and/or modify it
14 # under the terms of the GNU General Public License as published by
15 # the Free Software Foundation; either version 3 of the License, or
16 # (at your option) any later version.
18 # Koha is distributed in the hope that it will be useful, but
19 # WITHOUT ANY WARRANTY; without even the implied warranty of
20 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 # GNU General Public License for more details.
23 # You should have received a copy of the GNU General Public License
24 # along with Koha; if not, see <http://www.gnu.org/licenses>.
26 use strict;
27 use warnings;
29 use CGI qw ( -utf8 );
30 use C4::Context;
31 use C4::Members;
32 use C4::Auth;
33 use Koha::Patrons;
36 my $input = new CGI;
38 checkauth($input, 0, { borrowers => 1 }, 'intranet');
40 my $destination = $input->param("destination") || '';
41 my $borrowernumber=$input->param('borrowernumber');
42 my $status = $input->param('status');
43 my $reregistration = $input->param('reregistration') || '';
45 my $dbh = C4::Context->dbh;
46 my $dateexpiry;
48 if ( $reregistration eq 'y' ) {
49 # re-reregistration function to automatic calcul of date expiry
50 $dateexpiry = Koha::Patrons->find( $borrowernumber )->renew_account;
51 } else {
52 my $sth = $dbh->prepare("UPDATE borrowers SET debarred = ?, debarredcomment = '' WHERE borrowernumber = ?");
53 $sth->execute( $status, $borrowernumber );
54 $sth->finish;
57 if($destination eq "circ"){
58 if($dateexpiry){
59 print $input->redirect("/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber&was_renewed=1");
60 } else {
61 print $input->redirect("/cgi-bin/koha/circ/circulation.pl?borrowernumber=$borrowernumber");
63 } else {
64 if($dateexpiry){
65 print $input->redirect("/cgi-bin/koha/members/moremember.pl?borrowernumber=$borrowernumber&was_renewed=1");
66 } else {
67 print $input->redirect("/cgi-bin/koha/members/moremember.pl?borrowernumber=$borrowernumber");