[Koha-cvs] CVS: koha pay.pl,1.6,1.7
Paul POULAIN
tipaul at users.sourceforge.net
Mon Oct 28 21:17:32 CET 2002
Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv13662
Modified Files:
pay.pl
Log Message:
templating pay.pl
Index: pay.pl
===================================================================
RCS file: /cvsroot/koha/koha/pay.pl,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -r1.6 -r1.7
*** pay.pl 13 Oct 2002 07:34:27 -0000 1.6
--- pay.pl 28 Oct 2002 20:17:27 -0000 1.7
***************
*** 31,34 ****
--- 31,35 ----
use C4::Accounts2;
use C4::Stats;
+ use HTML::Template;
my $input=new CGI;
***************
*** 37,41 ****
my $bornum=$input->param('bornum');
if ($bornum eq ''){
! $bornum=$input->param('bornum0');
}
#get borrower details
--- 38,42 ----
my $bornum=$input->param('bornum');
if ($bornum eq ''){
! $bornum=$input->param('bornum0');
}
#get borrower details
***************
*** 52,70 ****
my $check=0;
for (my $i=0;$i<@names;$i++){
! my$temp=$input->param($names[$i]);
! if ($temp eq 'wo'){
! $inp{$names[$i]}=$temp;
! $check=1;
! }
! if ($temp eq 'yes'){
! $user=~ s/Levin/C/i;
! $user=~ s/Foxton/F/i;
! $user=~ s/Shannon/S/i;
! my $amount=$input->param($names[$i+4]);
! my $bornum=$input->param($names[$i+5]);
! my $accountno=$input->param($names[$i+6]);
! makepayment($bornum,$accountno,$amount,$user);
! $check=2;
! }
}
my %env;
--- 53,71 ----
my $check=0;
for (my $i=0;$i<@names;$i++){
! my$temp=$input->param($names[$i]);
! if ($temp eq 'wo'){
! $inp{$names[$i]}=$temp;
! $check=1;
! }
! if ($temp eq 'yes'){
! $user=~ s/Levin/C/i;
! $user=~ s/Foxton/F/i;
! $user=~ s/Shannon/S/i;
! my $amount=$input->param($names[$i+4]);
! my $bornum=$input->param($names[$i+5]);
! my $accountno=$input->param($names[$i+6]);
! makepayment($bornum,$accountno,$amount,$user);
! $check=2;
! }
}
my %env;
***************
*** 76,208 ****
my $total=$input->param('total');
if ($check ==0){
! print $input->header;
! if ($total ne ''){
! recordpayment(\%env,$bornum,$total);
! }
! my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);
!
! print startpage();
! print startmenu('member');
! print <<printend
! <FONT SIZE=6><em>Pay Fines for $data->{'firstname'} $data->{'surname'}</em></FONT><P>
! <center>
! <p>
! <TABLE CELLSPACING=0 CELLPADDING=5 border=1 >
! <TR VALIGN=TOP>
! <td bgcolor="99cc33" background="/images/background-mem.gif" colspan=4><B>FINES & CHARGES</TD>
! <td bgcolor="99cc33" background="/images/background-mem.gif" colspan=4><B>AMOUNT OWING</TD>
! </TR>
! <form action=/cgi-bin/koha/pay.pl method=post>
! <input type=hidden name=bornum value=$bornum>
! printend
! ;
! for (my $i=0;$i<$numaccts;$i++){
! if ($accts->[$i]{'amountoutstanding'} > 0){
! $accts->[$i]{'amount'}+=0.00;
! $accts->[$i]{'amountoutstanding'}+=0.00;
! print <<printend
! <tr VALIGN=TOP >
! <TD><input type=radio name=payfine$i value=no checked>Unpaid
! <input type=radio name=payfine$i value=yes>Pay
! <input type=radio name=payfine$i value=wo>Writeoff
! <input type=hidden name=itemnumber$i value=$accts->[$i]{'itemnumber'}>
! <input type=hidden name=accounttype$i value=$accts->[$i]{'accounttype'}>
! <input type=hidden name=amount$i value=$accts->[$i]{'amount'}>
! <input type=hidden name=out$i value=$accts->[$i]{'amountoutstanding'}>
! <input type=hidden name=bornum$i value=$bornum>
! <input type=hidden name=accountno$i value=$accts->[$i]{'accountno'}>
! </td>
! <TD>$accts->[$i]{'description'} $accts->[$i]{'title'}</td>
! <TD>$accts->[$i]{'accounttype'}</td>
! <td>$accts->[$i]{'amount'}</td>
! <TD>$accts->[$i]{'amountoutstanding'}</td>
!
! </tr>
! printend
! ;
! }
! }
! print <<printend
! <tr VALIGN=TOP >
! <TD></td>
! <TD colspan=2><b>Total Due</b></td>
! <TD><b>$total</b></td>
! </tr>
! <tr VALIGN=TOP >
! <TD colspan=5 align=right>
! <INPUT TYPE="image" name="submit" VALUE="pay" height=42 WIDTH=187 BORDER=0 src="/images/pay-fines.gif"></td>
! </tr>
! </form>
! </table>
! <br clear=all>
! <p> </p>
!
! printend
! ;
! print endmenu('member');
! print endpage();
} else {
# my $quety=$input->query_string;
# print $input->redirect("/cgi-bin/koha/sec/writeoff.pl?$quety");
! my%inp;
! my @name=$input->param;
! for (my $i=0;$i<@name;$i++){
! my $test=$input->param($name[$i]);
! if ($test eq 'wo'){
! my $temp=$name[$i];
! $temp=~ s/payfine//;
! $inp{$name[$i]}=$temp;
! }
! }
! my $bornum;
! while ( my ($key, $value) = each %inp){
! # print $key,$value;
! my $accounttype=$input->param("accounttype$value");
! $bornum=$input->param("bornum$value");
! my $itemno=$input->param("itemnumber$value");
! my $amount=$input->param("amount$value");
! if ($accounttype eq 'Res'){
! my $accountno=$input->param("accountno$value");
! writeoff($bornum,$accountno,$itemno,$accounttype,$amount);
! } else {
! writeoff($bornum,'',$itemno,$accounttype,$amount);
}
! }
! $bornum=$input->param('bornum');
! print $input->redirect("/cgi-bin/koha/pay.pl?bornum=$bornum");
}
sub writeoff{
! my ($bornum,$accountnum,$itemnum,$accounttype,$amount)=@_;
! my $user=$input->remote_user;
! $user=~ s/Levin/C/;
! $user=~ s/Foxton/F/;
! $user=~ s/Shannon/S/;
! my $dbh = C4::Context->dbh;
! my $env;
! my $query="Update accountlines set amountoutstanding=0 where ";
! if ($accounttype eq 'Res'){
! $query.="accounttype='Res' and accountno='$accountnum' and borrowernumber='$bornum'";
! } else {
! $query.="accounttype='$accounttype' and itemnumber='$itemnum' and borrowernumber='$bornum'";
! }
! my $sth=$dbh->prepare($query);
! # print $query;
! $sth->execute;
! $sth->finish;
! $query="select max(accountno) from accountlines";
! $sth=$dbh->prepare($query);
! $sth->execute;
! my $account=$sth->fetchrow_hashref;
! $sth->finish;
! $account->{'max(accountno)'}++;
! $query="insert into accountlines (borrowernumber,accountno,itemnumber,date,amount,description,accounttype)
! values ('$bornum','$account->{'max(accountno)'}','$itemnum',now(),'$amount','Writeoff','W')";
! $sth=$dbh->prepare($query);
! $sth->execute;
! $sth->finish;
! # print $query;
! UpdateStats($env,$user,'writeoff',$amount,'','','',$bornum);
}
--- 77,173 ----
my $total=$input->param('total');
if ($check ==0){
! my $template = gettemplate("members/pay.tmpl");
! if ($total ne ''){
! recordpayment(\%env,$bornum,$total);
! }
! my ($numaccts,$accts,$total)=getboracctrecord('',\%bor);
!
! my @loop_pay;
! for (my $i=0;$i<$numaccts;$i++){
! if ($accts->[$i]{'amountoutstanding'} > 0){
! $accts->[$i]{'amount'}+=0.00;
! $accts->[$i]{'amountoutstanding'}+=0.00;
! my %line;
! $line{i}=$i;
! $line{itemnumber} = $accts->[$i]{'itemnumber'};
! $line{accounttype} = $accts->[$i]{'accounttype'};
! $line{amount} = $accts->[$i]{'amount'};
! $line{amountoutstanding} = $accts->[$i]{'amountoutstanding'};
! $line{bornum} = $bornum;
! $line{accountno} = $accts->[$i]{'accountno'};
! $line{description} = $accts->[$i]{'description'};
! $line{title} = $accts->[$i]{'title'};
! push(@loop_pay, \%line);
! }
! }
! $template->param(firstname => $data->{'firstname'},
! surname => $data->{'surname'},
! bornum => $bornum,
! loop_pay => \@loop_pay,
! total => $total);
! print "Content-Type: text/html\n\n", $template->output;
} else {
# my $quety=$input->query_string;
# print $input->redirect("/cgi-bin/koha/sec/writeoff.pl?$quety");
! my%inp;
! my @name=$input->param;
! for (my $i=0;$i<@name;$i++){
! my $test=$input->param($name[$i]);
! if ($test eq 'wo'){
! my $temp=$name[$i];
! $temp=~ s/payfine//;
! $inp{$name[$i]}=$temp;
! }
! }
! my $bornum;
! while ( my ($key, $value) = each %inp){
! # print $key,$value;
! my $accounttype=$input->param("accounttype$value");
! $bornum=$input->param("bornum$value");
! my $itemno=$input->param("itemnumber$value");
! my $amount=$input->param("amount$value");
! if ($accounttype eq 'Res'){
! my $accountno=$input->param("accountno$value");
! writeoff($bornum,$accountno,$itemno,$accounttype,$amount);
! } else {
! writeoff($bornum,'',$itemno,$accounttype,$amount);
! }
}
! $bornum=$input->param('bornum');
! print $input->redirect("/cgi-bin/koha/pay.pl?bornum=$bornum");
}
sub writeoff{
! my ($bornum,$accountnum,$itemnum,$accounttype,$amount)=@_;
! my $user=$input->remote_user;
! $user=~ s/Levin/C/;
! $user=~ s/Foxton/F/;
! $user=~ s/Shannon/S/;
! my $dbh = C4::Context->dbh;
! my $env;
! my $query="Update accountlines set amountoutstanding=0 where ";
! if ($accounttype eq 'Res'){
! $query.="accounttype='Res' and accountno='$accountnum' and borrowernumber='$bornum'";
! } else {
! $query.="accounttype='$accounttype' and itemnumber='$itemnum' and borrowernumber='$bornum'";
! }
! my $sth=$dbh->prepare($query);
! # print $query;
! $sth->execute;
! $sth->finish;
! $query="select max(accountno) from accountlines";
! $sth=$dbh->prepare($query);
! $sth->execute;
! my $account=$sth->fetchrow_hashref;
! $sth->finish;
! $account->{'max(accountno)'}++;
! $query="insert into accountlines (borrowernumber,accountno,itemnumber,date,amount,description,accounttype)
! values ('$bornum','$account->{'max(accountno)'}','$itemnum',now(),'$amount','Writeoff','W')";
! $sth=$dbh->prepare($query);
! $sth->execute;
! $sth->finish;
! # print $query;
! UpdateStats($env,$user,'writeoff',$amount,'','','',$bornum);
}
More information about the Koha-cvs
mailing list