Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ – Rev 37124

Rev 37055 | Last modification | Compare with Previous | View Log | RSS feed

Last modification

Rev 37089 2026-07-14 15:07:47
Author: amit
Log message:
Optimize partnerPerformance data access: fofoId-scoped + month-bucketed query variants

- Order: fofoId-scoped billing-avg named queries (replace all-partner scan+filter)
- MonthlyTarget: selectByDatesAndFofoId batches 7 per-month lookups into one
- SchemeInOut/OfferPayout: month-bucketed ...ByMonth earnings queries collapsing the
per-month loop; new MonthlyBrandIncomeModel / MonthlyOfferPayoutModel
All additive; existing shared queries and their callers unchanged.

Path	Last modification			Log	RSS
ActivatedImei.java	36972	17 d 16 h	ranu	Log	RSS
ActivityType.java	27140	2110 d 9 h	amit.gupta	Log	RSS
BadInventorySnapshot.java	31860	1176 d 14 h	tejbeer	Log	RSS
BrandWiseFollowUp.java	33618	723 d 9 h	tejus.lohani	Log	RSS
CatalogFavourite.java	31860	1176 d 14 h	tejbeer	Log	RSS
CurrentInventorySnapshot.java	36285	93 d 9 h	amit	Log	RSS
CurrentPartnerDailyInvestment.java	35848	143 d 13 h	amit	Log	RSS
Customer.java	34917	324 d 11 h	vikas	Log	RSS
CustomerAddress.java	34190	522 d 9 h	aman.kumar	Log	RSS
CustomerCreditNote.java	31860	1176 d 14 h	tejbeer	Log	RSS
CustomerReturnItem.java	31860	1176 d 14 h	tejbeer	Log	RSS
CustomerWallet.java	31860	1176 d 14 h	tejbeer	Log	RSS
CustomerWalletHistory.java	31863	1176 d 13 h	tejbeer	Log	RSS
DebitNote.java	36446	78 d 5 h	amit	Log	RSS
FinServiceDocument.java	36152	107 d 16 h	aman	Log	RSS
FinServiceRequest.java	36152	107 d 16 h	aman	Log	RSS
FinServiceTemplate.java	36152	107 d 16 h	aman	Log	RSS
FofoKyc.java	35279	248 d 10 h	amit	Log	RSS
FofoLineItem.java	31860	1176 d 14 h	tejbeer	Log	RSS
FofoNonSerializeSerial.java	32816	920 d 12 h	ranu	Log	RSS
FofoOpeningStock.java	37055	8 d 15 h	ranu	Log	RSS
FofoOrder.java	36586	61 d 16 h	aman	Log	RSS
FofoOrderItem.java	35651	165 d 10 h	aman	Log	RSS
FofoPartnerDocument.java	36471	75 d 9 h	vikas	Log	RSS
FofoPartnerPaymentOption.java	31860	1176 d 14 h	tejbeer	Log	RSS
FofoPayment.java	31860	1176 d 14 h	tejbeer	Log	RSS
FofoStockAllocation.java	24673	2689 d 14 h	amit.gupta	Log	RSS
FofoStore.java	36727	51 d 12 h	ranu	Log	RSS
FofoStoreGeofence.java	31860	1176 d 14 h	tejbeer	Log	RSS
HygieneData.java	32066	1146 d 17 h	tejbeer	Log	RSS
IciciPincodeMaster.java	34798	368 d 11 h	ranu	Log	RSS
IciciPincodeMasterRepository.java	34798	368 d 11 h	ranu	Log	RSS
IciciPincodeMasterRepositoryImpl.java	34798	368 d 11 h	ranu	Log	RSS
InActiveFofoStore.java	31860	1176 d 14 h	tejbeer	Log	RSS
Indent.java	31860	1176 d 14 h	tejbeer	Log	RSS
IndentItem.java	31860	1176 d 14 h	tejbeer	Log	RSS
InventoryItem.java	36518	68 d 13 h	aman	Log	RSS
InvoiceNumberGenerationSequence.java	31860	1176 d 14 h	tejbeer	Log	RSS
LiveDemoSerialNumber.java	31860	1176 d 14 h	tejbeer	Log	RSS
LoanTransaction.java	34213	514 d 15 h	ranu	Log	RSS
MonthlyPlanned.java	31860	1176 d 14 h	tejbeer	Log	RSS
MonthlyTarget.java	31860	1176 d 14 h	tejbeer	Log	RSS
Mou.java	31860	1176 d 14 h	tejbeer	Log	RSS
OfferPayout.java	37089	4 d 13 h	amit	Log	RSS
PartnerBrandService.java	31860	1176 d 14 h	tejbeer	Log	RSS
PartnerDailyInvestment.java	35849	143 d 12 h	amit	Log	RSS
PartnerDealerMapping.java	34099	558 d 13 h	tejus.lohani	Log	RSS
PartnerOnBoardingPanel.java	36524	68 d 10 h	aman	Log	RSS
PartnerOnboardingTrainingPanel.java	31860	1176 d 14 h	tejbeer	Log	RSS
PartnerProblem.java	31860	1176 d 14 h	tejbeer	Log	RSS
PartnerService.java	29798	1650 d 15 h	manish	Log	RSS
PartnerServiceComment.java	33618	723 d 9 h	tejus.lohani	Log	RSS
PartnerTarget.java	25432	2534 d 10 h	amit.gupta	Log	RSS
PartnerTargetDetails.java	31860	1176 d 14 h	tejbeer	Log	RSS
PartnerType.java	32003	1163 d 9 h	amit.gupta	Log	RSS
PartnerTypeChange.java	35509	199 d 12 h	amit	Log	RSS
PartnerTypeSource.java	35509	199 d 12 h	amit	Log	RSS
PartnerVerificationCheckboxes.java	35971	131 d 9 h	aman	Log	RSS
PartnerVerificationpanel.java	33884	634 d 18 h	tejus.lohani	Log	RSS
PaymentOption.java	33845	651 d 15 h	tejus.lohani	Log	RSS
PendingOrder.java	31860	1176 d 14 h	tejbeer	Log	RSS
PendingOrderItem.java	34902	330 d 9 h	vikas	Log	RSS
PendingOrderPlan.java	34287	495 d 9 h	vikas.jangra	Log	RSS
PincodePartner.java	31860	1176 d 14 h	tejbeer	Log	RSS
PineLabs.java	35394	214 d 3 h	amit	Log	RSS
PinelabsCustomer.java	35652	165 d 9 h	vikas	Log	RSS
PinelabsOrder.java	35652	165 d 9 h	vikas	Log	RSS
PinelabsPaymentMethod.java	35405	214 d 1 h	amit	Log	RSS
PinelabsRefund.java	35406	214 d 1 h	amit	Log	RSS
PlannedDetail.java	31860	1176 d 14 h	tejbeer	Log	RSS
PrebookingListing.java	31860	1176 d 14 h	tejbeer	Log	RSS
PrebookingOrder.java	35833	145 d 10 h	amit	Log	RSS
PrintResource.java	33501	750 d 8 h	ranu	Log	RSS
PrintResourceRegion.java	33443	765 d 13 h	ranu	Log	RSS
Purchase.java	31860	1176 d 14 h	tejbeer	Log	RSS
PurchaseReturnItem.java	36103	110 d 9 h	amit	Log	RSS
PurchaseReturnOrder.java	36446	78 d 5 h	amit	Log	RSS
RatingReminder.java	36287	93 d 9 h	ranu	Log	RSS
RazorPay.java	28367	1895 d 9 h	tejbeer	Log	RSS
RbmRating.java	36356	87 d 11 h	ranu	Log	RSS
RequestedHidAllocation.java	36894	26 d 13 h	amit	Log	RSS
RetailerContact.java	37001	16 d 10 h	ranu	Log	RSS
RetailerFilter.java	32044	1152 d 17 h	tejbeer	Log	RSS
SaleHeadDetails.java	24135	2843 d 17 h	govind	Log	RSS
SalesHead.java	24131	2844 d 15 h	govind	Log	RSS
SalesRating.java	36336	87 d 17 h	ranu	Log	RSS
SamsungException.java	33600	726 d 9 h	ranu	Log	RSS
SamsungPCM.java	31706	1225 d 11 h	amit.gupta	Log	RSS
ScanRecord.java	31860	1176 d 14 h	tejbeer	Log	RSS
SchemeInOut.java	37089	4 d 13 h	amit	Log	RSS
SchemeItem.java	36397	82 d 14 h	amit	Log	RSS
ServiceBrandsConfig.java	36364	86 d 14 h	amit	Log	RSS
SmartCartSuggestion.java	34941	318 d 17 h	ranu	Log	RSS
StockAllocation.java	24229	2800 d 9 h	amit.gupta	Log	RSS
SuggestedPo.java	31860	1176 d 14 h	tejbeer	Log	RSS
SuggestedPoDetail.java	31860	1176 d 14 h	tejbeer	Log	RSS
TrialBrandPotential.java	35337	228 d 11 h	aman	Log	RSS
TrialFeedbackForm.java	35337	228 d 11 h	aman	Log	RSS
TrialForm.java	35642	166 d 17 h	aman	Log	RSS
UpSaleAgentCollection.java	36649	56 d 15 h	vikas	Log	RSS
UpSaleCall.java	34134	549 d 16 h	ranu	Log	RSS
UpSaleOrder.java	33720	688 d 10 h	ranu	Log	RSS
UpsellCallDetail.java	36649	56 d 15 h	vikas	Log	RSS
UpsellRazorpayPaymentStatus.java	36649	56 d 15 h	vikas	Log	RSS