|
Line 0
Link Here
|
| 0 |
- |
1 |
#!/usr/bin/perl |
|
|
2 |
|
| 3 |
use strict; |
| 4 |
use C4::Context; |
| 5 |
|
| 6 |
my $dbh = C4::Context->dbh(); |
| 7 |
my $DEBUG = 1; |
| 8 |
|
| 9 |
my $sth = $dbh->prepare("SELECT COUNT(*) AS amount FROM borrowers WHERE dateexpiry < NOW() AND lost <> 1"); |
| 10 |
$sth->execute; |
| 11 |
my $row = $sth->fetchrow_hashref(); |
| 12 |
|
| 13 |
# Output for email only if borrowers need changing |
| 14 |
if ($row->{'amount'}) { |
| 15 |
$DEBUG && print $row->{'amount'} . " borrowers to be changed"; |
| 16 |
} |
| 17 |
$sth->finish(); |
| 18 |
|
| 19 |
$sth = $dbh->prepare("UPDATE borrowers SET lost = 1 WHERE dateexpiry < NOW() AND lost <> 1"); |
| 20 |
|
| 21 |
$sth->execute; |
| 22 |
|
| 23 |
$sth->finish; |
| 24 |
$dbh->disconnect; |
| 25 |
|