3 #written 11/1/2000 by chris@katipo.co.nz
4 #script to write off accounts
11 #print $input->header;
16 my @name=$input->param;
17 for (my $i=0;$i<@name;$i++){
18 my $test=$input->param($name[$i]);
22 $inp{$name[$i]}=$temp;
26 while ( my ($key, $value) = each %inp){
28 my $accounttype=$input->param("accounttype$value");
29 $bornum=$input->param("bornum$value");
30 my $itemno=$input->param("itemnumber$value");
31 my $amount=$input->param("amount$value");
32 if ($accounttype eq 'Res'){
33 my $accountno=$input->param("accountno$value");
34 writeoff($bornum,$accountno,$itemno,$accounttype,$amount);
36 writeoff($bornum,'',$itemno,$accounttype,$amount);
39 #print $input->header;
40 $bornum=$input->param('bornum');
41 print $input->redirect("/cgi-bin/koha/pay.pl?bornum=$bornum");
43 #needs to be shifted to a module when time permits
45 my ($bornum,$accountnum,$itemnum,$accounttype,$amount)=@_;
47 my $query="Update accountlines set amountoutstanding=0 where ";
48 if ($accounttype eq 'Res'){
49 $query.="accounttype='Res' and accountno='$accountnum' and borrowernumber='$bornum'";
51 $query.="accounttype='$accounttype' and itemnumber='$itemnum' and borrowernumber='$bornum'";
53 my $sth=$dbh->prepare($query);
57 $query="select max(accountno) from accountlines";
58 $sth=$dbh->prepare($query);
60 my $account=$sth->fetchrow_hashref;
62 $account->{'max(accountno)'}++;
63 $query="insert into accountlines (borrowernumber,accountno,itemnumber,date,amount,description,accounttype)
64 values ('$bornum','$account->{'max(accountno)'}','$itemnum',now(),'$amount','Writeoff','W')";
65 $sth=$dbh->prepare($query);