Changes between Initial Version and Version 1 of AdvancedReport10

Timestamp:

12/28/25 23:17:53 (6 days ago)

Author:

211101

Comment:

--

AdvancedReport10

@@ +1 @@
+===== Вкупно потрошено во тековниот месец за цел систем
+Вкупна сума на трошоци во тековниот месец
+{{{#!sql
+SELECT 
+    SUM(tb.spent_amount) AS total_spent
+FROM 
+    transaction_breakdown tb
+JOIN transaction t ON tb.transaction_id = t.transaction_id
+WHERE 
+    EXTRACT(MONTH FROM t.date) = EXTRACT(MONTH FROM CURRENT_DATE)
+    AND EXTRACT(YEAR FROM t.date) = EXTRACT(YEAR FROM CURRENT_DATE);
+}}}