'Toegewezen aan',
];
if ($_POST) {
require_once 'upload.inc.php';
try {
$html = messagehtml($_POST['reply']);
if ($_FILES and !empty($_FILES['image'])) {
$target = 'data/upload';
if (!file_exists($target)) {
throw new Exception("er is geen uploadmap aanwezig op $target");
}
$target .= '/' . $User->login;
if ($result = userupload($_FILES['image'], $target)) {
$html .= sprintf('
![](/thumb/640x/%s)
', $result);
}
}
$query = $Db->set('comments', [
'page' => $Page->handler,
'message' => $html,
'author' => $User->login,
]);
if (!$query->rowCount()) {
throw new Exception('Fout bij opslaan');
}
$newcomment = $Db->dbh->lastInsertId('comments_id_seq');
if (isset($Issue)) {
$row = [];
foreach (array_keys($journalcol) as $col) {
if (!isset($_POST[$col])) continue;
$row[$col] = $_POST[$col] ?: NULL;
}
if (isset($_POST['status'])) {
$reset = !empty($_POST['status']);
if (isset($Issue->closed) !== $reset) {
$row['closed'] = $reset ? ['now()'] : NULL;
}
}
$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,
]);
}
$Issue = $updated;
}
}
$_POST['reply'] = NULL;
}
catch (Exception $e) {
print "Antwoord niet opgeslagen: {$e->getMessage()}.
\n\n";
}
}
$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->handler]);
print '';
while ($row = $query->fetch()) {
$rowuser = new User("profile/{$row->author}");
print '- ';
printf('%s %s',
$rowuser->html, showdate(preg_split('/\D/', $row->created))
);
printf("
\n%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";
}
if ($User->login) {
print '- ';
print '
\n";
}
print "
\n\n";