X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/fac6ba761f971deb77a5686ead99ec6534f931d2..2ffefa0117565475a16a12fef01c8b6fb83824bd:/widget/reply.php?ds=inline
diff --git a/widget/reply.php b/widget/reply.php
index ab04137..53fe34f 100644
--- a/widget/reply.php
+++ b/widget/reply.php
@@ -2,7 +2,9 @@
global $User, $Db, $Issue;
require_once 'database.inc.php';
-print '
Reacties
'."\n";
+$journalcol = [
+ 'assign' => 'Toegewezen aan',
+];
if ($_POST) {
try {
@@ -20,7 +22,7 @@ if ($_POST) {
if (isset($Issue)) {
$row = [];
- foreach (['assign'] as $col) {
+ foreach (array_keys($journalcol) as $col) {
if (!isset($_POST[$col])) continue;
$row[$col] = $_POST[$col] ?: NULL;
}
@@ -54,7 +56,8 @@ if ($_POST) {
}
}
-$query = $Db->query('SELECT * FROM comments WHERE page = ? ORDER BY created', [$Page]);
+$cols = '*, (SELECT json_agg(journal.*) FROM journal WHERE comment_id = comments.id) AS journal';
+$query = $Db->query("SELECT $cols FROM comments WHERE page = ? ORDER BY created", [$Page]);
print '';
@@ -65,6 +68,27 @@ while ($row = $query->fetch()) {
$rowuser->html, showdate(preg_split('/\D/', $row->created))
);
printf("%s
\n", $row->message);
+ if ($changes = json_decode($row->journal)) {
+ print '';
+ foreach ($changes as $change) {
+ print '- ';
+ if ($change->col == 'closed') {
+ printf('%s', isset($change->value) ? 'Gesloten' : 'Heropend');
+ }
+ else {
+ printf("%s %s",
+ $journalcol[$change->col], sprintf(
+ !isset($change->old_value) ? 'gewijzigd naar
%2$s
' :
+ (!isset($change->value) ? 'verwijderd (%s)' :
+ 'gewijzigd van %s
naar %s
'),
+ $change->old_value, $change->value
+ )
+ );
+ }
+ print " \n";
+ }
+ print "
\n";
+ }
print "\n";
}
@@ -77,7 +101,7 @@ if ($User) {
' '
. ''."\n",
'assign',
- 'Toegewezen aan',
+ $journalcol['assign'],
htmlspecialchars($Issue->assign ?? '')
);
printf(