projects
/
koha_gimpoz
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Bug 5549 : replace curdate with now in a couple of sql lines
[koha_gimpoz]
/
C4
/
Members.pm
diff --git
a/C4/Members.pm
b/C4/Members.pm
index
434a018
..
1f0ac3f
100644
(file)
--- a/
C4/Members.pm
+++ b/
C4/Members.pm
@@
-642,7
+642,7
@@
sub IsMemberBlocked {
"SELECT COUNT(*) as latedocs
FROM issues
WHERE borrowernumber = ?
"SELECT COUNT(*) as latedocs
FROM issues
WHERE borrowernumber = ?
- AND date_due <
curdate
()"
+ AND date_due <
now
()"
);
$sth->execute($borrowernumber);
my $latedocs = $sth->fetchrow_hashref->{'latedocs'};
);
$sth->execute($borrowernumber);
my $latedocs = $sth->fetchrow_hashref->{'latedocs'};
@@
-680,7
+680,7
@@
sub GetMemberIssuesAndFines {
$sth = $dbh->prepare(
"SELECT COUNT(*) FROM issues
WHERE borrowernumber = ?
$sth = $dbh->prepare(
"SELECT COUNT(*) FROM issues
WHERE borrowernumber = ?
- AND date_due <
curdate
()"
+ AND date_due <
now
()"
);
$sth->execute($borrowernumber);
my $overdue_count = $sth->fetchrow_arrayref->[0];
);
$sth->execute($borrowernumber);
my $overdue_count = $sth->fetchrow_arrayref->[0];