List active networks first

1 files changed, 42 insertions, 7 deletions

diff --git a/networks.c b/networks.c
index a81722c..ed19394 100644
--- a/networks.c
+++ b/networks.c
@@ -22,9 +22,25 @@
 #include "server.h"
 
 const char *NetworksQuery = SQL(
-	SELECT DISTINCT network
-	FROM contexts
-	ORDER BY network;
+	WITH recentEvents AS (
+		SELECT time, context
+		FROM events
+		ORDER BY event DESC
+		LIMIT 500 // TODO: Configurable.
+	), activeNetworks AS (
+		SELECT DISTINCT network
+		FROM contexts
+		JOIN recentEvents USING (context)
+		GROUP BY context
+		ORDER BY max(time) DESC
+	), allNetworks AS (
+		SELECT DISTINCT network
+		FROM contexts
+		ORDER BY network
+	)
+	SELECT network, 1 FROM activeNetworks
+	UNION ALL
+	SELECT network, 0 FROM allNetworks;
 );
 
 enum kcgi_err pageNetworks(struct kreq *req) {
@@ -35,22 +51,41 @@ enum kcgi_err pageNetworks(struct kreq *req) {
 	error = error
 		|| khttp_body(req)
 		|| khtml_open(&html, req, KHTML_PRETTY)
-		|| htmlHead(&html, "Networks")
+		|| htmlHead(&html, "Litterbox")
 		|| htmlNav(&html, NULL, NULL)
-		|| htmlSearch(&html, NULL, NULL)
-		|| khtml_elem(&html, KELEM_UL);
+		|| htmlSearch(&html, NULL, NULL);
 	if (error) return error;
 
+	enum State {
+		None,
+		Active,
+		Networks,
+	} state = None;
+	const char *Headings[] = { NULL, "Active", "Networks" };
+
 	int result;
 	while (SQLITE_ROW == (result = sqlite3_step(stmt.networks))) {
 		const char *network = (const char *)sqlite3_column_text(stmt.networks, 0);
+		bool active = sqlite3_column_int(stmt.networks, 1);
+
+		enum State prev = state;
+		state = (active ? Active : Networks);
+		if (state != prev) {
+			error = 0
+				|| khtml_closeelem(&html, 1)
+				|| khtml_elem(&html, KELEM_H2)
+				|| khtml_puts(&html, Headings[state])
+				|| khtml_closeelem(&html, 1)
+				|| khtml_elem(&html, KELEM_UL);
+			if (error) return error;
+		}
+
 		char *href = khttp_urlpart(
 			NULL, NULL, Pages[Contexts],
 			Keys[Network].name, network,
 			NULL
 		);
 		if (!href) err(EX_OSERR, "khttp_urlpart");
-
 		error = 0
 			|| khtml_elem(&html, KELEM_LI)
 			|| khtml_attr(&html, KELEM_A, KATTR_HREF, href, KATTR__MAX)