From 005ca246a2ebc36f3e439002505125a0170a3aa0 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 19 Dec 2017 16:52:03 -0300
Subject: [PATCH] Bug 19843: (bug 15839 follow-up) Set reviews.datereviewed
 when the review is made

Caused by
  commit 092ae340cef375cc66c8511fd34c1a4eec9c7ba6
    Bug 15839: Koha::Reviews - Remove savereview

the datereviewed=now() part of the query has not been translated.

Test plan:
Add a review from the OPAC
Confirm that the reviews.datereviewd has been correctly set. Without
this patch it is set to NULL.

I have no idea how we could update existing data :-/

Signed-off-by: Owen Leonard <oleonard@myacpl.org>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
---
 opac/opac-review.pl | 1 +
 1 file changed, 1 insertion(+)

diff --git a/opac/opac-review.pl b/opac/opac-review.pl
index 39af047cfd..b4a26beb93 100755
--- a/opac/opac-review.pl
+++ b/opac/opac-review.pl
@@ -87,6 +87,7 @@ if( !@errors && defined $review ) {
                     {   biblionumber   => $biblionumber,
                         borrowernumber => $borrowernumber,
                         review         => $clean,
+                        datereviewed   => dt_from_string
                     }
                 )->store->reviewid;
             }
-- 
2.39.5