X-Git-Url: http://git.shiar.net/minimedit.git/blobdiff_plain/fc5ac7212dade29d2d12ddad934c1dcfe4653794..e2e6d4c1c37aff2e6b50331cb31af9d59536624f:/widget/reply.php

diff --git a/widget/reply.php b/widget/reply.php
index 328a58f..9761cf2 100644
--- a/widget/reply.php
+++ b/widget/reply.php
@@ -2,8 +2,6 @@
 global $User, $Db, $Issue;
 require_once 'database.inc.php';
 
-print '<h3>Reacties</h3>'."\n";
-
 if ($_POST) {
 	try {
 		$html = nl2br(htmlspecialchars($_POST['reply']));
@@ -16,9 +14,10 @@ if ($_POST) {
 		if (!$query->rowCount()) {
 			throw new Exception('Fout bij opslaan');
 		}
+		$newcomment = $Db->dbh->lastInsertId('comments_id_seq');
 
 		if (isset($Issue)) {
-			$row = ['updated' => ['now()']];
+			$row = [];
 			foreach (['assign'] as $col) {
 				if (!isset($_POST[$col])) continue;
 				$row[$col] = $_POST[$col] ?: NULL;
@@ -29,7 +28,22 @@ if ($_POST) {
 					$row['closed'] = $reset ? ['now()'] : NULL;
 				}
 			}
-			$Db->set('issues', $row, ['id = ?', $Issue->id]);
+			$derived = ['updated' => ['now()']];
+			$filter = ['id = ? RETURNING *', $Issue->id];
+			$subquery = $Db->set('issues', $row + $derived, $filter);
+
+			if ($updated = $subquery->fetch()) {
+				foreach (array_keys($row) as $col) {
+					if ($updated->$col === $Issue->$col) continue; # unaltered
+					$Db->set('journal', [
+						'comment_id' => $newcomment,
+						'property'   => 'attr',
+						'col'        => $col,
+						'old_value'  => $Issue->$col,
+						'value'      => $updated->$col,
+					]);
+				}
+			}
 		}
 		$_POST['reply'] = NULL;
 	}