[Koha-cvs] CVS: koha overdue.pl,1.3,1.4

[Andrew Arensburger]

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 ----