Subversion Repositories SmartDukaan

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

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
AddWalletRequest.java	35971	213 d 14 h	aman	Log	RSS
AgingSummary.java	35316	318 d 12 h	ranu	Log	RSS
CreditBlockedExceptionPartner.java	35292	327 d 15 h	amit	Log	RSS
CreditNote.java	36719	134 d 13 h	amit	Log	RSS
CreditNoteLine.java	36185	187 d 19 h	amit	Log	RSS
CreditNoteType.java	36498	153 d 17 h	amit	Log	RSS
CronBatch.java	36305	173 d 1 h	amit	Log	RSS
CronBatchItem.java	36305	173 d 1 h	amit	Log	RSS
EInvoiceDetails.java	36675	136 d 14 h	amit	Log	RSS
FofoBankDisbursement.java	34872	426 d 18 h	ranu	Log	RSS
FofoSidbiSanction.java	33354	881 d 20 h	amit.gupta	Log	RSS
FranchiseeBankAccount.java	36471	157 d 14 h	vikas	Log	RSS
HdfcPayment.java	36943	104 d 17 h	amit	Log	RSS
LineItem.java	33767	756 d 17 h	ranu	Log	RSS
LineItemImei.java	33023	953 d 15 h	amit.gupta	Log	RSS
LineItemImeiView.java	28825	1891 d 23 h	tejbeer	Log	RSS
Loan.java	36557	146 d 3 h	amit	Log	RSS
LoanAggregation.java	32172	1197 d 18 h	jai.hind	Log	RSS
LoanImei.java	36958	100 d 18 h	amit	Log	RSS
LoanStatement.java	36972	99 d 21 h	ranu	Log	RSS
LoanSummary.java	32172	1197 d 18 h	jai.hind	Log	RSS
ManualPaymentType.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
NotifyCancel.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
NotifyColorChange.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
NotifyItem.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
NotifyMessage.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
NotifyOrder.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
Order.java	37089	86 d 18 h	amit	Log	RSS
OrderStatus.java	30180	1675 d 18 h	manish	Log	RSS
OrderWalletAdjustment.java	36713	134 d 15 h	amit	Log	RSS
Organisation.java	32145	1213 d 21 h	tejbeer	Log	RSS
Payment.java	32603	1066 d 21 h	raveendra.bharati	Log	RSS
PendingRechargeCommission.java	23110	3208 d 15 h	ashik.ali	Log	RSS
PriceDrop.java	36999	98 d 16 h	amit	Log	RSS
PriceDropIMEI.java	36489	154 d 16 h	amit	Log	RSS
RazorPayTransaction.java	34860	428 d 14 h	ranu	Log	RSS
ReturnOrder.java	32724	1031 d 14 h	amit.gupta	Log	RSS
ReturnOrderInfo.java	36972	99 d 21 h	ranu	Log	RSS
Returnpickuprequest.java	32737	1028 d 19 h	amit.gupta	Log	RSS
ReturnTransaction.java	32724	1031 d 14 h	amit.gupta	Log	RSS
SanctionRequest.java	34355	556 d 16 h	ranu	Log	RSS
SDCreditRequirement.java	36557	146 d 3 h	amit	Log	RSS
Seller.java	32145	1213 d 21 h	tejbeer	Log	RSS
SellerWarehouse.java	36218	183 d 21 h	amit	Log	RSS
StateWiseLoanSummary.java	35335	311 d 14 h	ranu	Log	RSS
Transaction.java	34373	553 d 17 h	tejus.lohani	Log	RSS
TransactionApproval.java	35995	209 d 14 h	aman	Log	RSS
TransactionShipmentSequence.java	33741	761 d 19 h	amit.gupta	Log	RSS
UnsettledPayment.java	24089	2949 d 15 h	tejbeer	Log	RSS
UpiTransaction.java	34860	428 d 14 h	ranu	Log	RSS
UserWallet.java	33703	776 d 14 h	amit.gupta	Log	RSS
UserWalletHistory.java	36974	99 d 21 h	ranu	Log	RSS
WarehouseAddressMapping.java	32074	1225 d 22 h	tejbeer	Log	RSS
WarehouseAddressMaster.java	33741	761 d 19 h	amit.gupta	Log	RSS