timekeeper

commit b5ad18773dae8601271d6d01ffa2a196a130b4fc
parent b9e8befe090f85d3280637499b5fce5994d944d6
Author: Jacob R. Edwards <jacob@jacobedwards.org>
Date:   Thu, 21 Mar 2024 08:04:02 -0700

Reverse sort by period in the get times statement

Now the most recent period is returned first which is probably how
the caller will want it to be returned, or at least the archive
page does.

Diffstat:
M
stmt.c
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/stmt.c b/stmt.c
@@ -70,7 +70,7 @@ struct sqlbox_pstmt pstmts[] = {
 	},
 	[StmtGetTimes] = { .stmt =
 		"SELECT period, start, startbreak, endbreak, end FROM times\n"
-		"	WHERE userid IS ? ORDER BY entry"
+		"	WHERE userid IS ? ORDER BY period DESC, entry"
 	},
 	[StmtGetTimePeriod] = { .stmt =
 		"SELECT period, start, startbreak, endbreak, end FROM times\n"