Changes between Version 7 and Version 8 of App
- Timestamp:
- 09/04/25 23:43:30 (3 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
App
v7 v8 9 9 - **Usage**: Makes it easier to see which client each invoice belongs to without writing complex JOINs 10 10 11 ```sql 11 {{{ 12 12 SELECT * FROM invoice_summary WHERE invoice_status = 'PENDING'; 13 ``` 13 }}} 14 14 15 15 `client_totals` … … 19 19 - **Usage**: Provides a quick overview of each client's financial status 20 20 21 ```sql 21 {{{ 22 22 SELECT * FROM client_totals ORDER BY total_invoiced DESC; 23 ``` 23 }}} 24 24 25 25 API Integration … … 30 30 - `src/app/api/invoices/totals/route.ts`: Uses `invoice_summary` view for invoice analytics 31 31 32 ####Benefits32 Benefits 33 33 34 34 - **Simpler queries**: No need to write complex JOINs every time
