'Toegewezen aan', 'subject' => 'Onderwerp', ]; 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)) { if (preg_match('(^image/)', $_FILES['image']['type'])) { $html .= sprintf('

', $result); } else { $html .= sprintf('

Bijgevoegd bestand: %s

', $result, basename($result) ); } } } $query = $Db->set('comments', [ 'page' => $Page->link, '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; } } $target = "/{$Page->link}/$newcomment#$newcomment"; abort($target, ($Page->api ? 200 : 303) . ' reply success'); $_POST['reply'] = NULL; } catch (Exception $e) { if ($Page->api) { abort(ucfirst($e->getMessage()), '500 reply error'); } 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->link]); print '

', $row->id); printf('%s %s', $rowuser->html, showdate(preg_split('/\D/', $row->created)) ); if ($html = $row->message) { $html = preg_replace('/(?<= 2 ? 'loading="lazy" ' : '', $html, -1, $found); $imagecount += $found; printf("
\n%s
\n", $html); } if ($changes = json_decode($row->journal)) { 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 "
'; print '
'; if (isset($Issue) and $User->admin("edit {$Page->link}")) { print '
'; printf( '%s: ' . ''."\n", 'assign', $journalcol['assign'], htmlspecialchars($Issue->assign ?? '') ); printf( '' . '' . ' %s'."\n", 'status', 'resolved', isset($Issue->closed) ? ' checked' : '', 'Gesloten' ); print "
\n"; } if (isset($Issue)) { printf( '
%s: ' . '
'."\n", 'image', 'Beeldmateriaal', ' type="file" accept="image/*"' ); } printf('%s'."\n", 'reply', "Bericht van {$User->login}", '' ); print ''."\n"; print "
"; print ''; print "

\n\n";