Changes between Version 9 and Version 10 of App

Timestamp:

09/08/25 19:03:05 (11 hours ago)

Author:

163080

Comment:

--

App

@@ -1 @@
-= SQL Views =
+== SQL Views ==
 
 The application uses SQL VIEWs to simplify common queries and improve maintainability.
@@ -15 +15 @@
 }}}
 
-== v_client_financial_summary ==
+** v_client_financial_summary **
 
 '''Purpose''': Shows total amounts for each client with risk analysis
@@ -27 +27 @@
 }}}
 
-= API Integration =
+** API Integration **
 
 The views are used in API endpoints to provide simplified data access:
@@ -35 +35 @@
 src/app/api/invoices/totals/route.ts: Uses v_invoice_analytics view for invoice analytics
 
-= Benefits =
+** Benefits **
 
 '''Simpler queries''': No need to write complex JOINs every time
@@ -60 +60 @@
 - `src/app/api/invoices/route.ts`: For creating new invoices
 
-**Triggers**
+== Triggers ==
 
 The system implements a sophisticated trigger system for invoice management:
@@ -73 +73 @@
 The trigger is implemented in `sql/01_invoice_status_trigger.sql`.
 
-**Indexes**
+== Indexes ==
 
 Several optimized indexes are implemented for better query performance: