addon.reports¶
Structured report queries. Covers running inventory totals, monthly inventory, MK daily, FBOL, per-account trucking and AI verification results. Which tables a report joins is what defines the report.
8 endpoints - system addon - module gate applies
What this module covers - Bookings, companies, commodity, loads, transloads, deliveries. Each report joins a different set of tables.
Endpoints¶
| Method | Path | What it does | Evidence |
|---|---|---|---|
| POST | /addons/ai-verifications/ingate-ticket/ai-extract |
Extract items from an inbound gate ticket with AI | handler ctcAiApiExtract() · calls api_catalog.php |
| GET | /addons/ai-verifications/(?P<id>\d+) |
Read one AI verification result in detail | handler ai_verification() · tables T_BOOKING, T_COMPANY, T_DELIVERY +3 more |
| GET | /bms/reports/account-trucking |
Read the trucking report per account | handler account_trucking_report() · tables T_COMPANY, T_DELIVERY, T_EQUIPMENT +3 more |
| GET | /reports/fbol |
Read the FBOL report | handler fbol_report() · tables T_BOOKING, T_COMPANY, T_DELIVERY +4 more |
| GET | /reports/inventory/accumulative |
Read the running inventory report | handler accumulative_inventory_report() · tables T_COMPANY, T_TRANSLOAD |
| GET | /reports/inventory/monthly |
Read the monthly inventory report | handler monthly_inventory_report() · tables T_COMPANY, T_TRANSLOAD |
| GET | /reports/mk/daily-commodity |
Read the MK daily commodity report | handler daily_commodity_report() · tables T_COMMODITY, T_LOAD, T_LOAD_ITEM |
| GET | /reports/mk/daily-dashboard |
Read the MK daily dashboard report | handler daily_dashboard() · tables T_COMMODITY, T_LOAD, T_LOAD_ITEM |
Topics this module shares with other modules¶
- AI item extraction - this topic is spread across 7 modules and 8 endpoints.
Tables this module reads¶
T_COMPANY (5x) · T_DELIVERY (3x) · T_EQUIPMENT (3x) · T_EQUIPMENT_LOAD (3x) · T_BOOKING (2x) · T_TRANSLOAD (2x) · T_COMMODITY (2x) · T_LOAD (2x) · T_LOAD_ITEM (2x) · T_FILE · T_TRANSACTION · T_TRANSACTION_LIST · T_EQUIPMENT_COMMODITY · T_USER
The description is a summary read off the route path, the handler, the tables it reaches and the screens that call it. Nothing is guessed without evidence: where the handler has to be read, it says so. The full evidence is on each endpoint page.