Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/ – Rev 35537

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)

Path	Last modification			Log	RSS
authentication/	35458	214 d 1 h	amit	Log	RSS
catalog/	35458	214 d 1 h	amit	Log	RSS
indent/	23509	3030 d 14 h	amit.gupta	Log	RSS
integrations/	35501	204 d 9 h	ranu	Log	RSS
inventory/	35440	215 d 3 h	amit	Log	RSS
offers/	35501	204 d 9 h	ranu	Log	RSS
order/	35493	209 d 23 h	amit	Log	RSS
page/	34859	350 d 4 h	vikas	Log	RSS
pricecircular/	35394	217 d 20 h	amit	Log	RSS
pricing/	35187	282 d 3 h	amit	Log	RSS
recharge/	35458	214 d 1 h	amit	Log	RSS
reportico/	33973	608 d 3 h	tejus.lohani	Log	RSS
scheme/	35493	209 d 23 h	amit	Log	RSS
serviceConfig/	35337	232 d 4 h	aman	Log	RSS
SshServer/	33973	608 d 3 h	tejus.lohani	Log	RSS
tag/	33247	823 d 8 h	ranu	Log	RSS
transaction/	35495	209 d 23 h	amit	Log	RSS
user/	35485	211 d 10 h	aman	Log	RSS
wallet/	34966	321 d 3 h	amit	Log	RSS
warehouse/	35394	217 d 20 h	amit	Log	RSS
whatsapp/	32854	918 d 4 h	amit.gupta	Log	RSS
AdminUser.java	35483	212 d 7 h	amit	Log	RSS
AuthService.java	34794	372 d 11 h	vikas.jangra	Log	RSS
AuthServiceImpl.java	35198	281 d 2 h	ranu	Log	RSS
ChartService.java	30220	1576 d 10 h	amit.gupta	Log	RSS
ChartServiceImpl.java	30220	1576 d 10 h	amit.gupta	Log	RSS
CustomerService.java	34190	526 d 2 h	aman.kumar	Log	RSS
CustomerServiceImpl.java	34190	526 d 2 h	aman.kumar	Log	RSS
EmailService.java	28377	1897 d 3 h	tejbeer	Log	RSS
FofoUser.java	35285	250 d 10 h	aman	Log	RSS
LogisticsService.java	34373	475 d 5 h	tejus.lohani	Log	RSS
LogisticsServiceImpl.java	34373	475 d 5 h	tejus.lohani	Log	RSS
NotificationService.java	35504	204 d 8 h	vikas	Log	RSS
NotificationServiceImpl.java	35504	204 d 8 h	vikas	Log	RSS
PartnerCollectionService.java	33248	823 d 8 h	ranu	Log	RSS
PartnerCollectionServiceImpl.java	33840	656 d 9 h	ranu	Log	RSS
PartnerInvestmentService.java	35536	195 d 5 h	amit	Log	RSS
PartnerInvestmentServiceImpl.java	35536	195 d 5 h	amit	Log	RSS
PartnerStatsService.java	35537	194 d 22 h	amit	Log	RSS
PartnerStatsServiceImpl.java	35537	194 d 22 h	amit	Log	RSS
PerformanceService.java	32044	1156 d 11 h	tejbeer	Log	RSS
PerformanceServiceImpl.java	34729	389 d 8 h	amit.gupta	Log	RSS
PostOfficeService.java	33128	853 d 10 h	amit.gupta	Log	RSS
PostOfficeServiceImpl.java	33128	853 d 10 h	amit.gupta	Log	RSS
PurchaseInvoiceService.java	32724	953 d 2 h	amit.gupta	Log	RSS
RbmTargetService.java	35453	214 d 7 h	amit	Log	RSS
RbmTargetServiceImpl.java	35454	214 d 6 h	amit	Log	RSS
SellerService.java	31007	1385 d 1 h	amit.gupta	Log	RSS
SellerServiceImpl.java	32383	1057 d 5 h	amit.gupta	Log	RSS