[Koha-cvs] CVS: koha stats2.pl,1.3,1.4
Andrew Arensburger
arensb at users.sourceforge.net
Sun Oct 13 09:35:25 CEST 2002
Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv4572
Modified Files:
stats2.pl
Log Message:
Added magic RCS comment.
Removed trailing whitespace.
Index: stats2.pl
===================================================================
RCS file: /cvsroot/koha/koha/stats2.pl,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** stats2.pl 5 Oct 2002 09:46:43 -0000 1.3
--- stats2.pl 13 Oct 2002 07:35:23 -0000 1.4
***************
*** 1,4 ****
--- 1,6 ----
#!/usr/bin/perl
+ # $Id$
+
#written 14/1/2000
#script to display reports
***************
*** 61,69 ****
my $dbh = C4::Context->dbh;
! my $query="select *
from accountlines,accountoffsets,borrowers where
accountlines.borrowernumber=accountoffsets.borrowernumber and
(accountlines.accountno=accountoffsets.accountno or accountlines.accountno
! =accountoffsets.offsetaccount) and accountlines.timestamp >=20000621000000
and borrowers.borrowernumber=accountlines.borrowernumber
group by accountlines.borrowernumber,accountlines.accountno";
--- 63,71 ----
my $dbh = C4::Context->dbh;
! my $query="select *
from accountlines,accountoffsets,borrowers where
accountlines.borrowernumber=accountoffsets.borrowernumber and
(accountlines.accountno=accountoffsets.accountno or accountlines.accountno
! =accountoffsets.offsetaccount) and accountlines.timestamp >=20000621000000
and borrowers.borrowernumber=accountlines.borrowernumber
group by accountlines.borrowernumber,accountlines.accountno";
More information about the Koha-cvs
mailing list