3 #script to delete borrowers
13 use C4::Circulation::Circ2;
14 #use C4::Acquisitions;
21 $flagsrequired->{borrower}=1;
22 my ($loggedinuser, $cookie, $sessionID) = checkauth($input, 0, $flagsrequired);
26 #print $input->header;
27 my $member=$input->param('member');
29 $env{'nottodayissues'}=1;
31 $member2{'borrowernumber'}=$member;
32 my $issues=currentissues(\%env,\%member2);
34 foreach (sort keys %$issues) {
37 my ($bor,$flags)=getpatroninformation(\%env, $member,'');
39 my $query="Select * from borrowers where guarantor='$member'";
40 my $sth=$dbh->prepare($query);
42 my $data=$sth->fetchrow_hashref;
47 if ($i > 0 || $flags->{'CHARGES'} ne '' || $data ne ''){
49 print "<table border=1>";
51 print "<TR><TD>Items on Issue</td><td align=right>$i</td></tr>";
53 if ($flags->{'CHARGES'} ne ''){
54 print "<TR><TD>Charges</td><td>$flags->{'CHARGES'}->{'message'}</tr>";
57 print "<TR><TD>Guarantees</td></tr>";
63 print $input->redirect("/members/");
69 my $query="Select * from borrowers where borrowernumber='$member'";
70 my $sth=$dbh->prepare($query);
72 my @data=$sth->fetchrow_array;
74 $query="Insert into deletedborrowers values (";
75 foreach my $temp (@data){
76 $query=$query."'$temp',";
80 $sth=$dbh->prepare($query);
83 $query = "Delete from borrowers where borrowernumber='$member'";
84 $sth=$dbh->prepare($query);
87 $query="Delete from reserves where borrowernumber='$member'";
88 $sth=$dbh->prepare($query);