5 #script to delete items
10 # Copyright 2000-2002 Katipo Communications
12 # This file is part of Koha.
14 # Koha is free software; you can redistribute it and/or modify it under the
15 # terms of the GNU General Public License as published by the Free Software
16 # Foundation; either version 2 of the License, or (at your option) any later
19 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
20 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
21 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
23 # You should have received a copy of the GNU General Public License along with
24 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
25 # Suite 330, Boston, MA 02111-1307 USA
32 use C4::Interface::CGI::Output;
34 use C4::Circulation::Circ2;
41 $flagsrequired->{borrowers}=1;
42 my ($loggedinuser, $cookie, $sessionID) = checkauth($input, 0, $flagsrequired);
46 #print $input->header;
47 my $member=$input->param('member');
49 warn "user num".$member;
50 $env{'nottodayissues'}=1;
52 $member2{'borrowernumber'}=$member;
53 my $issues=currentissues(\%env,\%member2);
55 foreach (sort keys %$issues) {
58 my ($bor,$flags)=getpatroninformation(\%env, $member,'');
59 if (C4::Context->preference("IndependantBranches")) {
60 my $userenv = C4::Context->userenv;
61 unless ($userenv->{flags} == 1){
62 unless ($userenv->{'branch'} eq $bor->{'branchcode'}){
63 # warn "user ".$userenv->{'branch'} ."borrower :". $bor->{'branchcode'};
64 print $input->redirect("/cgi-bin/koha/members/moremember.pl?bornum=$member");
69 my $dbh = C4::Context->dbh;
70 my $sth=$dbh->prepare("Select * from borrowers where guarantorid=?");
71 $sth->execute($member);
72 my $data=$sth->fetchrow_hashref;
75 if ($i > 0 || $flags->{'CHARGES'} ne '' || $data ne ''){
76 my ($template, $borrowernumber, $cookie)
77 = get_template_and_user({template_name => "members/deletemem.tmpl",
81 flagsrequired => {borrower => 1},
84 # print $input->header;
85 $template->param(bornum => $member);
87 $template->param(ItemsOnIssues => $i);
89 if ($flags->{'CHARGES'} ne '') {
90 $template->param(charges => $flags->{'CHARGES'}->{'message'});
93 $template->param(guarantees => 1);
95 # print "<table border=1>";
97 # print "<TR><TD>Items on Issue</td><td align=right>$i</td></tr>";
99 # if ($flags->{'CHARGES'} ne ''){
100 # print "<TR><TD>Charges</td><td>$flags->{'CHARGES'}->{'message'}</tr>";
103 # print "<TR><TD>Guarantees</td></tr>";
106 output_html_with_http_headers $input, $cookie, $template->output;
110 print $input->redirect("/cgi-bin/koha/members/members-home.pl");
115 my $dbh = C4::Context->dbh;
116 my $sth=$dbh->prepare("Select * from borrowers where borrowernumber=?");
117 $sth->execute($member);
118 my @data=$sth->fetchrow_array;
120 $sth=$dbh->prepare("Insert into deletedborrowers values (".("?,"x(scalar(@data)-1))."?)");
121 $sth->execute(@data);
123 $sth=$dbh->prepare("Delete from borrowers where borrowernumber=?");
124 $sth->execute($member);
126 $sth=$dbh->prepare("Delete from reserves where borrowernumber=?");
127 $sth->execute($member);