| 35537 |
125 d 0 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
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) |
|
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerTertiarySalesModel.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoOrder.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepository.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOrderItemRepositoryImpl.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsService.java
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsServiceImpl.java
|