Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ – 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
ActivatedImei.java	35536	193 d 22 h	amit	Log	RSS
ActivityType.java	27140	2112 d 19 h	amit.gupta	Log	RSS
BadInventorySnapshot.java	31860	1179 d 0 h	tejbeer	Log	RSS
BrandWiseFollowUp.java	33618	725 d 19 h	tejus.lohani	Log	RSS
CatalogFavourite.java	31860	1179 d 0 h	tejbeer	Log	RSS
CurrentInventorySnapshot.java	35490	209 d 19 h	ranu	Log	RSS
CurrentPartnerDailyInvestment.java	31860	1179 d 0 h	tejbeer	Log	RSS
Customer.java	34917	326 d 21 h	vikas	Log	RSS
CustomerAddress.java	34190	524 d 19 h	aman.kumar	Log	RSS
CustomerCreditNote.java	31860	1179 d 0 h	tejbeer	Log	RSS
CustomerReturnItem.java	31860	1179 d 0 h	tejbeer	Log	RSS
CustomerWallet.java	31860	1179 d 0 h	tejbeer	Log	RSS
CustomerWalletHistory.java	31863	1178 d 23 h	tejbeer	Log	RSS
DebitNote.java	31860	1179 d 0 h	tejbeer	Log	RSS
DigifyRetailer.java	31786	1202 d 2 h	tejbeer	Log	RSS
FofoKyc.java	35279	250 d 20 h	amit	Log	RSS
FofoLineItem.java	31860	1179 d 0 h	tejbeer	Log	RSS
FofoNonSerializeSerial.java	32816	922 d 22 h	ranu	Log	RSS
FofoOpeningStock.java	34813	364 d 20 h	aman	Log	RSS
FofoOrder.java	35537	193 d 14 h	amit	Log	RSS
FofoOrderItem.java	35193	279 d 21 h	vikas	Log	RSS
FofoPartnerPaymentOption.java	31860	1179 d 0 h	tejbeer	Log	RSS
FofoPayment.java	31860	1179 d 0 h	tejbeer	Log	RSS
FofoStockAllocation.java	24673	2692 d 0 h	amit.gupta	Log	RSS
FofoStore.java	35463	212 d 10 h	amit	Log	RSS
FofoStoreGeofence.java	31860	1179 d 0 h	tejbeer	Log	RSS
HygieneData.java	32066	1149 d 3 h	tejbeer	Log	RSS
IciciPincodeMaster.java	34798	370 d 21 h	ranu	Log	RSS
IciciPincodeMasterRepository.java	34798	370 d 21 h	ranu	Log	RSS
IciciPincodeMasterRepositoryImpl.java	34798	370 d 21 h	ranu	Log	RSS
InActiveFofoStore.java	31860	1179 d 0 h	tejbeer	Log	RSS
Indent.java	31860	1179 d 0 h	tejbeer	Log	RSS
IndentItem.java	31860	1179 d 0 h	tejbeer	Log	RSS
InventoryItem.java	33306	810 d 1 h	amit.gupta	Log	RSS
InvoiceNumberGenerationSequence.java	31860	1179 d 0 h	tejbeer	Log	RSS
LiveDemoSerialNumber.java	31860	1179 d 0 h	tejbeer	Log	RSS
LoanTransaction.java	34213	517 d 1 h	ranu	Log	RSS
MonthlyPlanned.java	31860	1179 d 0 h	tejbeer	Log	RSS
MonthlyTarget.java	31860	1179 d 0 h	tejbeer	Log	RSS
Mou.java	31860	1179 d 0 h	tejbeer	Log	RSS
OfferPayout.java	34256	505 d 4 h	ranu	Log	RSS
PartnerBrandService.java	31860	1179 d 0 h	tejbeer	Log	RSS
PartnerDailyInvestment.java	35168	284 d 0 h	amit	Log	RSS
PartnerDealerMapping.java	34099	560 d 23 h	tejus.lohani	Log	RSS
PartnerOnBoardingPanel.java	34085	570 d 19 h	tejus.lohani	Log	RSS
PartnerOnboardingTrainingPanel.java	31860	1179 d 0 h	tejbeer	Log	RSS
PartnerProblem.java	31860	1179 d 0 h	tejbeer	Log	RSS
PartnerService.java	29798	1653 d 1 h	manish	Log	RSS
PartnerServiceComment.java	33618	725 d 19 h	tejus.lohani	Log	RSS
PartnerTarget.java	25432	2536 d 20 h	amit.gupta	Log	RSS
PartnerTargetDetails.java	31860	1179 d 0 h	tejbeer	Log	RSS
PartnerType.java	32003	1165 d 19 h	amit.gupta	Log	RSS
PartnerTypeChange.java	35509	201 d 22 h	amit	Log	RSS
PartnerTypeSource.java	35509	201 d 22 h	amit	Log	RSS
PartnerVerificationCheckboxes.java	31860	1179 d 0 h	tejbeer	Log	RSS
PartnerVerificationpanel.java	33884	637 d 4 h	tejus.lohani	Log	RSS
PaymentOption.java	33845	654 d 1 h	tejus.lohani	Log	RSS
PendingOrder.java	31860	1179 d 0 h	tejbeer	Log	RSS
PendingOrderItem.java	34902	332 d 19 h	vikas	Log	RSS
PendingOrderPlan.java	34287	497 d 19 h	vikas.jangra	Log	RSS
PincodePartner.java	31860	1179 d 0 h	tejbeer	Log	RSS
PineLabs.java	35394	216 d 13 h	amit	Log	RSS
PinelabsCustomer.java	35406	216 d 11 h	amit	Log	RSS
PinelabsOrder.java	35403	216 d 11 h	amit	Log	RSS
PinelabsPaymentMethod.java	35405	216 d 11 h	amit	Log	RSS
PinelabsRefund.java	35406	216 d 11 h	amit	Log	RSS
PlannedDetail.java	31860	1179 d 0 h	tejbeer	Log	RSS
PrebookingListing.java	31860	1179 d 0 h	tejbeer	Log	RSS
PrebookingOrder.java	31860	1179 d 0 h	tejbeer	Log	RSS
PrintResource.java	33501	752 d 18 h	ranu	Log	RSS
PrintResourceRegion.java	33443	767 d 23 h	ranu	Log	RSS
Purchase.java	31860	1179 d 0 h	tejbeer	Log	RSS
PurchaseReturnItem.java	34141	550 d 17 h	tejus.lohani	Log	RSS
RazorPay.java	28367	1897 d 19 h	tejbeer	Log	RSS
RbmRating.java	34322	488 d 19 h	ranu	Log	RSS
RequestedHidAllocation.java	34198	523 d 21 h	ranu	Log	RSS
RetailerContact.java	32795	928 d 15 h	amit.gupta	Log	RSS
RetailerFilter.java	32044	1155 d 3 h	tejbeer	Log	RSS
SaleHeadDetails.java	24135	2846 d 3 h	govind	Log	RSS
SalesHead.java	24131	2847 d 1 h	govind	Log	RSS
SalesRating.java	34322	488 d 19 h	ranu	Log	RSS
SamsungException.java	33600	728 d 19 h	ranu	Log	RSS
SamsungPCM.java	31706	1227 d 21 h	amit.gupta	Log	RSS
ScanRecord.java	31860	1179 d 0 h	tejbeer	Log	RSS
SchemeInOut.java	35378	220 d 19 h	amit	Log	RSS
SchemeItem.java	34317	489 d 2 h	amit.gupta	Log	RSS
ServiceBrandsConfig.java	31860	1179 d 0 h	tejbeer	Log	RSS
SmartCartSuggestion.java	34941	321 d 3 h	ranu	Log	RSS
StockAllocation.java	24229	2802 d 19 h	amit.gupta	Log	RSS
SuggestedPo.java	31860	1179 d 0 h	tejbeer	Log	RSS
SuggestedPoDetail.java	31860	1179 d 0 h	tejbeer	Log	RSS
TrialBrandPotential.java	35337	230 d 21 h	aman	Log	RSS
TrialFeedbackForm.java	35337	230 d 21 h	aman	Log	RSS
TrialForm.java	35499	203 d 20 h	aman	Log	RSS
UpSaleAgentCollection.java	33715	691 d 3 h	ranu	Log	RSS
UpSaleCall.java	34134	552 d 2 h	ranu	Log	RSS
UpSaleOrder.java	33720	690 d 20 h	ranu	Log	RSS
UpsellCallDetail.java	33715	691 d 3 h	ranu	Log	RSS
UpsellRazorpayPaymentStatus.java	33715	691 d 3 h	ranu	Log	RSS