From: Mischa POSLAWSKY Date: Tue, 20 Apr 2021 15:49:59 +0000 (+0200) Subject: issue/activity: ungrouped select, persistent titles X-Git-Tag: v5.3~24 X-Git-Url: http://git.shiar.nl/minimedit.git/commitdiff_plain/f73f2c6c223577ad3cc6e14c0e6ff1567c910eae issue/activity: ungrouped select, persistent titles Revert to author headers and simple chronological display. --- diff --git a/widget/issue/activity.php b/widget/issue/activity.php index f09cdc7..bb694c7 100644 --- a/widget/issue/activity.php +++ b/widget/issue/activity.php @@ -7,24 +7,20 @@ $cols = 'm.*, i.subject, i.updated, i.closed'; $sql = "SELECT $cols FROM messages m JOIN issues i ON i.id = issue"; $sql .= " WHERE message IS NOT NULL"; $sql .= " ORDER BY m.created DESC LIMIT $limit"; -$sql = "SELECT * FROM ($sql) x ORDER BY updated DESC, created, id"; # grouped issues $query = $Db->query($sql); print '
'; $group = NULL; while ($row = $query->fetch()) { + print '
'; if ($group !== $row->issue) { $group = $row->issue; - print '
'; printf('%s', $row->page, $row->subject); if ($row->closed) { print ' (opgelost)'; } - print '
'; } - print '
'; - printf("
%s
\n\t", $row->message); print ''; if ($row->author and $rowuser = new User("profile/{$row->author}")) { printf('%s ', $rowuser->html); @@ -33,6 +29,9 @@ while ($row = $query->fetch()) { showdate(preg_split('/\D/', $row->created)) ); print ""; + print ''; + print '
'; + print $row->message; print "
\n"; }