[Koha-cvs] CVS: koha pay.pl,1.6,1.7

[Paul POULAIN]

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> &nbsp; </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)address@hidden;
!     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 => 
address@hidden,
!                                                       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)address@hidden;
!       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);
  }