Changes between Initial Version and Version 1 of AdvancedReport14

Timestamp:

12/28/25 23:19:04 (5 days ago)

Author:

211101

Comment:

--

AdvancedReport14

@@ +1 @@
+===== Долг на кредитна картичка од минатиот месец за корисник
+Потрошено од сметки означени како „кредитна картичка“ за минатиот месец за еден корисник
+{{{#!sql
+SELECT 
+    SUM(tb.spent_amount) AS credit_card_debt
+FROM 
+    transaction_breakdown tb
+JOIN transaction_account ta ON tb.transaction_account_id = ta.transaction_account_id
+JOIN transaction t ON tb.transaction_id = t.transaction_id
+WHERE 
+    ta.user_id = 101 -- ID на конкретниот корисник
+    AND (ta.account_name ILIKE '%кредитна%' OR ta.account_name ILIKE '%credit%')
+    AND EXTRACT(MONTH FROM t.date) = EXTRACT(MONTH FROM CURRENT_DATE - INTERVAL '1 MONTH')
+    AND EXTRACT(YEAR FROM t.date) = EXTRACT(YEAR FROM CURRENT_DATE - INTERVAL '1 MONTH');
+}}}