From 0ad8becf3282457e7dcd966cc7804c302c4bac09 Mon Sep 17 00:00:00 2001
From: rangi <rangi>
Date: Sun, 17 Mar 2002 02:31:02 +0000
Subject: [PATCH] tidied up, less hlt specific now

---
 misc/fines2.pl | 52 ++++++++++++++++++++++++++++++++++++++++++++------
 1 file changed, 46 insertions(+), 6 deletions(-)

diff --git a/misc/fines2.pl b/misc/fines2.pl
index 9025298c3f..dabb8c453d 100755
--- a/misc/fines2.pl
+++ b/misc/fines2.pl
@@ -2,7 +2,9 @@
 
 #script to keep total of number of issues;
 
-
+use C4::Database;
+use C4::Search;
+use C4::Circulation::Circ2;
 use C4::Circulation::Fines;
 use Date::Manip;
 
@@ -15,9 +17,9 @@ my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =localtime(time);
 $mon++;
 $year=$year+1900;
 my $date=Date_DaysSince1BC($mon,$mday,$year);
-#my $date=Date_DaysSince1BC(12,4,2000);
+#my $date=Date_DaysSince1BC(1,24,2002);
 my $bornum;
-
+#print $date;
 my $total=0;
 my $max=5;
 #my $bornum2=$data->[0]->{'borrowernumber'};
@@ -37,13 +39,51 @@ for (my $i=0;$i<$count;$i++){
     }
     if ($amount > 0){
       UpdateFine($data->[$i]->{'itemnumber'},$data->[$i]->{'borrowernumber'},$amount,$type,$due);
-      if ($amount ==5){
+#      if ($amount ==5){
 #	      marklost();
-      }
-      print "$printout\t$borrower->{'cardnumber'}\t$borrower->{'categorycode'}\t$borrower->{'firstname'}\t$borrower->{'surname'}\t$data->[$i]->{'date_due'}\t$type\t$difference\t$borrower->{'emailaddress'}\t$borrower->{'phone'}\t$borrower->{'streetaddress'}\t$borrower->{'city'}\t$amount\n";
+#      }
+       if ($borrower->{'categorycode'} eq 'C'){
+	 my $dbh=C4Connect;
+	 my $query="Select * from borrowers where borrowernumber='$borrower->{'guarantor'}'";
+	 my $sth=$dbh->prepare($query);
+	 $sth->execute;
+	 my $tdata=$sth->fetchrow_hashref;
+	 $sth->finish;
+	 $dbh->disconnect;
+	 $borrower->{'phone'}=$tdata->{'phone'};
+       }
+       print "$printout\t$borrower->{'cardnumber'}\t$borrower->{'categorycode'}\t$borrower->{'firstname'}\t$borrower->{'surname'}\t$data->[$i]->{'date_due'}\t$type\t$difference\t$borrower->{'emailaddress'}\t$borrower->{'phone'}\t$borrower->{'streetaddress'}\t$borrower->{'city'}\t$amount\n";
     } else {
 #      print "$borrower->{'cardnumber'}\t$borrower->{'categorycode'}\t0 fine\n";
     }
+    if ($difference >= 28){ 
+      my $borrower=BorType($data->[$i]->{'borrowernumber'});
+      if ($borrower->{'cardnumber'} ne ''){
+        my $cost=ReplacementCost($data->[$i]->{'itemnumber'});	
+	my $dbh=C4Connect;
+	my $env;
+	my $accountno=C4::Circulation::Circ2::getnextacctno($env,$data->[$i]->{'borrowernumber'},$dbh);
+	my $item=itemnodata($env,$dbh,$data->[$i]->{'itemnumber'});
+	if ($item->{'itemlost'} ne '1' && $item->{'itemlost'} ne '2' ){
+	  $item->{'title'}=~ s/\'/\\'/g;
+	  my $query="Insert into accountlines
+	  (borrowernumber,itemnumber,accountno,date,amount,
+	  description,accounttype,amountoutstanding) values
+	  ($data->[$i]->{'borrowernumber'},$data->[$i]->{'itemnumber'},
+	  '$accountno',now(),'$cost','Lost item $item->{'title'} $item->{'barcode'}','L','$cost')";
+	  my $sth=$dbh->prepare($query);
+	  $sth->execute;
+	  $sth->finish;
+	  $query="update items set itemlost=2 where itemnumber='$data->[$i]->{'itemnumber'}'";
+	  $sth=$dbh->prepare($query);
+	  $sth->execute;
+	  $sth->finish;
+	} else {
+	  
+	}
+	$dbh->disconnect;
+      }
+    }
 
   }
 }
-- 
2.39.5