fix for #422

[koha.git] / charges.pl

diff --git a/charges.pl b/charges.pl
index aee6563..9da30a9 100755 (executable)
--- a/charges.pl
+++ b/charges.pl
@@ -23,10 +23,18 @@
 
 use strict;
 use CGI;
+use C4::Context;
 use C4::Output;
 use C4::Database;
+use C4::Auth;
 
 my $input = new CGI;
+
+my $flagsrequired;
+$flagsrequired->{circulation}=1;
+my ($loggedinuser, $cookie, $sessionID) = checkauth($input, 0, $flagsrequired);
+
+
 print $input->header;
 my $type=$input->param('type');
 print startpage();
@@ -34,7 +42,7 @@ print startmenu('issue');
 print "Each box needs to be filled in with fine,time to start charging,charging cycle<br>
 eg 1,7,7 = $1 fine, after 7 days, every 7 days";
 
-my $dbh=C4Connect;
+my $dbh = C4::Context->dbh;
 my $query="Select description,categorycode from categories";
 my $sth=$dbh->prepare($query);
 $sth->execute;
@@ -58,13 +66,13 @@ $i=0;
 while (my $data=$sth->fetchrow_hashref){
   my @trow2;
   for ($i=0;$i<9;$i++){
-    $query="select * from categoryitem where categorycode='$trow3[$i]' and itemtype='$data->{'itemtype'}'";
+    $query="select * from categoryitem where categorycode=? and itemtype=?";
     my $sth2=$dbh->prepare($query);
-    $sth2->execute;
+    $sth2->execute($trow3[$i],$data->{'itemtype'});
     my $dat=$sth2->fetchrow_hashref;
     $sth2->finish;
     my $fine=$dat->{'fine'}+0;
-    $trow2[$i]="<input type=text name=\"$trow3[$i]$data->{'itemtype'}\" value=\"$fine,$dat->{'startcharge'},$dat->{'chargeperiod'}\" size=6>";
+    $trow2[$i]="<input type=text name=\"$trow3[$i]$data->{'itemtype'}\" value=\"$fine,$dat->{'firstremind'},$dat->{'chargeperiod'}\" size=6>";
   }
   print mktablerow(11,'white',$data->{'description'},@trow2);
 }