setting $dbh->{AutoCommit} = 0, and adding a new --commit arg.
[koha.git] / members / setstatus.pl
blobc2b7a38857d94a9d4877dc63ff5fd13928dca01c
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
10 # This file is part of Koha.
12 # Koha is free software; you can redistribute it and/or modify it under the
13 # terms of the GNU General Public License as published by the Free Software
14 # Foundation; either version 2 of the License, or (at your option) any later
15 # version.
17 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
18 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
19 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
21 # You should have received a copy of the GNU General Public License along with
22 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
23 # Suite 330, Boston, MA 02111-1307 USA
25 use strict;
27 use CGI;
28 use C4::Context;
29 use C4::Members;
30 use C4::Auth;
33 my $input = new CGI;
35 my $flagsrequired;
36 $flagsrequired->{borrowers}=1;
37 my ($loggedinuser, $cookie, $sessionID) = checkauth($input, 0, $flagsrequired);
39 my $destination = $input->param("destination");
40 my $cardnumber = $input->param("cardnumber");
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 = ExtendMemberSubscriptionTo( $borrowernumber );
51 } else {
52 my $sth=$dbh->prepare("Update borrowers set debarred = ? 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?findborrower=$cardnumber&dateexpiry=$dateexpiry");
60 } else {
61 print $input->redirect("/cgi-bin/koha/circ/circulation.pl?findborrower=$cardnumber");
63 } else {
64 if($dateexpiry){
65 print $input->redirect("/cgi-bin/koha/members/moremember.pl?bornum=$borrowernumber&dateexpiry=$dateexpiry");
66 } else {
67 print $input->redirect("/cgi-bin/koha/members/moremember.pl?bornum=$borrowernumber");