[Koha-cvs] CVS: koha/C4 Accounts.pm,1.11,1.12

[Mike Hansen]

Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1:/tmp/cvs-serv30464/koha/C4

Modified Files:
        Accounts.pm 
Log Message:


Index: Accounts.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Accounts.pm,v
retrieving revision 1.11
retrieving revision 1.12
diff -C2 -r1.11 -r1.12
*** Accounts.pm 7 Dec 2002 04:38:56 -0000       1.11
--- Accounts.pm 19 Feb 2003 01:33:52 -0000      1.12
***************
*** 62,69 ****
  @ISA = qw(Exporter);
  @EXPORT = qw(&checkaccount &reconcileaccount &getnextacctno);
- # FIXME - This is never used
- sub displayaccounts{
-   my ($env)address@hidden;
- }
  
  =item checkaccount
--- 62,65 ----
***************
*** 190,198 ****
       $usth->execute;
       $usth->finish;
       $updquery = "insert into accountoffsets
       (borrowernumber, accountno, offsetaccount,  offsetamount)
       values ($bornumber,$accdata->{'accountno'},$nextaccntno,$newamtos)";
!      # FIXME - There's already a $usth in this scope.
!      my $usth = $dbh->prepare($updquery);
  #     print $updquery
       $usth->execute;
--- 186,194 ----
       $usth->execute;
       $usth->finish;
+      
       $updquery = "insert into accountoffsets
       (borrowernumber, accountno, offsetaccount,  offsetamount)
       values ($bornumber,$accdata->{'accountno'},$nextaccntno,$newamtos)";
!      $usth = $dbh->prepare($updquery);
  #     print $updquery
       $usth->execute;
***************
*** 208,220 ****
    values ($bornumber,$nextaccntno,now(),0-$data,'Payment,thanks',
    'Pay',0-$amountleft)";
!   my $usth = $dbh->prepare($updquery);
    $usth->execute;
    $usth->finish;
    UpdateStats($env,'branch','payment',$data)
- #  $sth->finish;
- #  $query = "commit";
- #  $sth = $dbh->prepare;
- #  $sth->execute;
- #  $sth-finish;
  }
  
--- 204,211 ----
    values ($bornumber,$nextaccntno,now(),0-$data,'Payment,thanks',
    'Pay',0-$amountleft)";
!   $usth = $dbh->prepare($updquery);
    $usth->execute;
    $usth->finish;
    UpdateStats($env,'branch','payment',$data)
  }
  
***************
*** 235,243 ****
    my ($env,$bornumber,$dbh)address@hidden;
    my $nextaccntno = 1;
!   # FIXME - This could just be
!   #   SELECT max(accountno)+1 from accountlines;
!   my $query = "select * from accountlines
!   where (borrowernumber = '$bornumber')
!   order by accountno desc";
    my $sth = $dbh->prepare($query);
    $sth->execute;
--- 226,231 ----
    my ($env,$bornumber,$dbh)address@hidden;
    my $nextaccntno = 1;
!   
!   my $query = "select max(accountno)+1 from accountlines";
    my $sth = $dbh->prepare($query);
    $sth->execute;
***************
*** 246,250 ****
    }
    $sth->finish;
!   return($nextaccntno);
  }
  
--- 234,238 ----
    }
    $sth->finish;
!   return$nextaccntno;
  }