Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java – Rev 35537
Rev 35184 | Compare with Previous | Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 35537 – 117 d 8 h
- 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)
