Bug 22521: Update fines handling to use accountline.status

[koha-equinox.git] / misc / cronjobs / staticfines.pl

diff --git a/misc/cronjobs/staticfines.pl b/misc/cronjobs/staticfines.pl
index 2a98fea..774c3b0 100755 (executable)
--- a/misc/cronjobs/staticfines.pl
+++ b/misc/cronjobs/staticfines.pl
@@ -229,8 +229,8 @@ for ( my $i = 0 ; $i < scalar(@$data) ; $i++ ) {
 
             my $desc        = "staticfine";
             my $query       = "INSERT INTO accountlines
-                        (borrowernumber,itemnumber,date,amount,description,accounttype,amountoutstanding)
-                                VALUES (?,?,now(),?,?,'F',?)";
+                        (borrowernumber,itemnumber,date,amount,description,accounttype,status,amountoutstanding)
+                                VALUES (?,?,now(),?,?,'OVERDUE','RETURNED',?)";
             my $sth2 = $dbh->prepare($query);
             $bigdebug and warn "query: $query\nw/ args: $borrowernumber, $itemnumber, $amount, $desc, $amount\n";
             $sth2->execute( $borrowernumber, $itemnumber, $amount, $desc, $amount );