View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0009613 | Taler | merchant backend | public | 2025-03-12 16:31 | 2025-03-27 17:09 |
| Reporter | Dana Dram | Assigned To | schanzen | ||
| Priority | high | Severity | feature | Reproducibility | always |
| Status | assigned | Resolution | open | ||
| Product Version | git (master) | ||||
| Target Version | 1.1 | ||||
| Summary | 0009613: View total revenue from Orders | ||||
| Description | Currently, there is no dedicated section in the backend merchant application that allows users to view the total revenue generated from orders. This lack of visibility makes it challenging for users to track their earnings efficiently and gain insights into their financial performance. The feature aims to address this gap by providing a centralized location where users can view the total amount of money earned from orders over a specific period. | ||||
| Steps To Reproduce | A dedicated section to the application where users can view the total revenue generated from orders will be very helpfull for the users. | ||||
| Tags | No tags attached. | ||||
| related to | 0009361 | feedback | Damian Pilka | transaction overviews for the merchants / Abrechnung für die Händler*innen |
|
|
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. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-03-12 16:31 | Dana Dram | New Issue | |
| 2025-03-12 16:31 | Dana Dram | Status | new => assigned |
| 2025-03-12 16:31 | Dana Dram | Assigned To | => Christian Grothoff |
| 2025-03-13 00:37 | Christian Grothoff | Note Added: 0024190 | |
| 2025-03-13 00:38 | Christian Grothoff | Severity | major => feature |
| 2025-03-13 00:38 | Christian Grothoff | Target Version | => 1.1 |
| 2025-03-13 14:41 | Christian Grothoff | Assigned To | Christian Grothoff => |
| 2025-03-13 14:41 | Christian Grothoff | Status | assigned => confirmed |
| 2025-03-13 14:41 | Christian Grothoff | Product Version | => git (master) |
| 2025-03-22 14:09 | Christian Grothoff | Category | mechant backend => merchant backend |
| 2025-03-23 15:42 | Christian Grothoff | Note Added: 0024288 | |
| 2025-03-23 15:43 | Christian Grothoff | Note Edited: 0024288 | |
| 2025-03-23 16:05 | Christian Grothoff | Note Added: 0024289 | |
| 2025-03-27 16:42 | Christian Grothoff | Relationship added | related to 0009361 |
| 2025-03-27 16:42 | Christian Grothoff | Note Added: 0024318 | |
| 2025-03-27 16:49 | schanzen | Assigned To | => schanzen |
| 2025-03-27 16:49 | schanzen | Status | confirmed => assigned |
| 2025-03-27 17:05 | schanzen | Note Added: 0024320 | |
| 2025-03-27 17:09 | Christian Grothoff | Note Added: 0024322 |
