git.shiar.nl
/
minimedit.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
issue: header counting open and closed rows
[minimedit.git]
/
issue
/
index.php
diff --git
a/issue/index.php
b/issue/index.php
index 9a35df87f97546ae44a4007fef9888b55744d3b1..547547a5cd984a15d69e3a7439d2339a529e2eec 100644
(file)
--- a/
issue/index.php
+++ b/
issue/index.php
@@
-75,7
+75,7
@@
$sql = "SELECT $cols FROM issues i WHERE page = ?";
if (isset($_GET['open'])) {
$sql .= ' AND closed IS NULL';
}
if (isset($_GET['open'])) {
$sql .= ' AND closed IS NULL';
}
-$sql .= ' ORDER BY
closed IS NOT NULL,
updated DESC';
+$sql .= ' ORDER BY updated DESC';
$query = $Db->query($sql, [$Page->handler]);
if ($id == 'feed') {
$query = $Db->query($sql, [$Page->handler]);
if ($id == 'feed') {
@@
-83,6
+83,12
@@
if ($id == 'feed') {
}
ob_start();
}
ob_start();
+$stats = $Db->query(
+ "SELECT count(*) AS total, count(closed) AS closed FROM issues"
+)->fetch();
+printf("<h4>%d lopende zaken, %s opgelost</h4>\n",
+ $stats->total - $stats->closed, $stats->closed
+);
print '<ul>';
while ($row = $query->fetch()) {
printf('<li%s><div><a href="%s">',
print '<ul>';
while ($row = $query->fetch()) {
printf('<li%s><div><a href="%s">',