[Koha-cvs] CVS: koha overdue.pl,1.3,1.4
Andrew Arensburger
arensb at users.sourceforge.net
Sat Oct 5 11:46:20 CEST 2002
Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv19778
Modified Files:
overdue.pl
Log Message:
Merged with arensb-context branch: use C4::Context->dbh instead of
&C4Connect, and generally prefer C4::Context over C4::Database.
Index: overdue.pl
===================================================================
RCS file: /cvsroot/koha/koha/overdue.pl,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** overdue.pl 30 Sep 2002 14:16:34 -0000 1.3
--- overdue.pl 5 Oct 2002 09:46:18 -0000 1.4
***************
*** 20,26 ****
use strict;
use C4::Output;
use CGI;
- use C4::Database;
use HTML::Template;
--- 20,26 ----
use strict;
+ use C4::Context;
use C4::Output;
use CGI;
use HTML::Template;
***************
*** 47,51 ****
my $todaysdate = (1900+$datearr[5]).'-'.sprintf ("%0.2d", ($datearr[4]+1)).'-'.sprintf ("%0.2d", $datearr[3]);
! my $dbh=C4Connect;
my $query="select date_due,borrowernumber,itemnumber from issues where isnull(returndate) && date_due<'$todaysdate' order by date_due,borrowernumber";
--- 47,51 ----
my $todaysdate = (1900+$datearr[5]).'-'.sprintf ("%0.2d", ($datearr[4]+1)).'-'.sprintf ("%0.2d", $datearr[3]);
! my $dbh = C4::Context->dbh;
my $query="select date_due,borrowernumber,itemnumber from issues where isnull(returndate) && date_due<'$todaysdate' order by date_due,borrowernumber";
***************
*** 68,71 ****
--- 68,72 ----
$sth1->finish;
+ # FIXME - There's already a $query in this scope.
my $query="select biblionumber from items where itemnumber='$itemnum'";
my $sth2=$dbh->prepare($query);
***************
*** 75,78 ****
--- 76,80 ----
$sth2->finish;
+ # FIXME - There's already a $query in this scope.
my $query="select title,author from biblio where biblionumber='$biblionumber'";
my $sth3=$dbh->prepare($query);
***************
*** 95,99 ****
$sth->finish;
- $dbh->disconnect;
$template->param( startmenureport => join ('', startmenu('report')),
--- 97,100 ----
More information about the Koha-cvs
mailing list