(root)/trunk/profitmandi-dao/ – Rev 35537
Rev 35536 |
Rev 35547 |
Go to most recent revision |
Last modification |
Compare with Previous |
View Log
| RSS feed
Last modification
- Rev 35537 2026-01-08 23:58:50
- Author: amit
- Log message:
- Optimize getAllPartnerStats: combine 5 tertiary queries into 1 using CASE WHEN pattern
- Added PartnerTertiarySalesModel to hold combined tertiary data
- Added FofoOrder.selectPartnerTertiarySales named query using CASE WHEN
- Added selectPartnerTertiarySales() batch method in FofoOrderItemRepository
- Updated PartnerStatsServiceImpl to use single combined query
- Reduces 5 DB queries to 1 for tertiary sales data (lmtd, mtd, lms, today, last3days)