| Indeed, we should add this. | |
| merchant-0014.sql now adds various tables for backend statistics, as well as triggers to automatically populate those. We still need to: 1) Enhance taler-merchant-dbinit with a "-g" (garbage-collect) option which runs the *_gc() stored procedures --- and periodically run that via a systemd timer to clean up (old) statistics, 2) Define and implement a REST API to expose the collected statistics (using the stored procedures to access the interval statistics, the bucket ones can be gotten directly via SELECT), 3) Show the statistics in the SPA. | |
| 937440b9..e4563c3f adds (1): -g option and timer job. | |
| taler-docs.git, commit 71782e169175c3741755455419ed9f252fbf7743, now has a REST API spec (vSTATISTICS) that should be implemented to expose transaction statistics to the SPA. | |
| MerchantStatisticAmountByBucket and MerchantStatisticAmountByInterval are undefined types in the REST API spec. | |
| I screwed up the syntax, fixed now. | |
| Implemented first draft. Please review commit and merge as convienient: https://git.gnunet.org/merchant.git/commit/?h=dev/schanzen/issue_9613&id=74a26f25e341dbfff1f07d86e14ea08ffb6c35b0 Things to review: SQL statements (especially for intervals, since those are pretty much untested) | |
| See feedback on Mattermost... | |
| I think you wanted to do a code review and then merge at some point. | |
| I've reviewed dev/schanzen/issue_9613 now, made a few minor bugfixes / stylefixes and merged into master in a single commit as 76419140..df28a7ea. Next up: SPA update to support showing the statistics. | |
| related to 0010487 | |
| A first draft of the UI attached. WIP https://git.gnunet.org/taler-typescript-core.git/log/?h=dev/schanzen/issue_9613 image.png (78,154 bytes) | |
| Great Thanks! Will a CSV (oder any other data) export be possible? | |
| I'd say lets first do the HTML tables and be sure that they contain what we want. After that, we can easily add CSV exports. | |
| First implementation landed in master 4578a1854..f7f07e78d, no tables yet. I have yet to think about how those should look like. | |
| Tables are in. Testing and UX improvement (and adding other stats etc) can begin I guess. Currently, stats are not on the front page but in its own page accessible from the side bar, but promotion to a landing page is trivial, when necessary. | |
| Attaching screenshots for reference/discussion displaying test data. 2025-11-24T22:25:35,088572823+09:00.png (89,096 bytes) 2025-11-24T22:25:46,839177883+09:00.png (33,386 bytes) 2025-11-24T22:26:00,521201280+09:00.png (67,378 bytes) 2025-11-24T22:26:27,664601343+09:00.png (77,196 bytes) 2025-11-24T22:26:37,938545769+09:00.png (32,205 bytes) | |
- Anonymous