Subversion Repositories SmartDukaan

(root)//trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/ @ 22925 – Rev 37194

Rev 36999 | 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
CreditNoteLineRepository.java	34327	500 d 9 h	amit.gupta	Log	RSS
CreditNoteLineRepositoryImpl.java	34327	500 d 9 h	amit.gupta	Log	RSS
CreditNoteRepository.java	36769	59 d 10 h	amit	Log	RSS
CreditNoteRepositoryImpl.java	36769	59 d 10 h	amit	Log	RSS
CronBatchItemRepository.java	36351	101 d 14 h	amit	Log	RSS
CronBatchItemRepositoryImpl.java	36351	101 d 14 h	amit	Log	RSS
CronBatchRepository.java	36354	101 d 12 h	amit	Log	RSS
CronBatchRepositoryImpl.java	36354	101 d 12 h	amit	Log	RSS
EInvoiceDetailsRepository.java	34168	548 d 13 h	tejus.lohani	Log	RSS
EInvoiceDetailsRepositoryImpl.java	34168	548 d 13 h	tejus.lohani	Log	RSS
FofoSidbiSanctionRepository.java	33354	813 d 16 h	amit.gupta	Log	RSS
FofoSidbiSanctionRepositoryImpl.java	33354	813 d 16 h	amit.gupta	Log	RSS
HdfcPaymentRepository.java	36371	99 d 17 h	amit	Log	RSS
HdfcPaymentRepositoryImpl.java	36371	99 d 17 h	amit	Log	RSS
LineItemImeisRepository.java	33246	833 d 15 h	ranu	Log	RSS
LineItemImeisRepositoryImpl.java	33246	833 d 15 h	ranu	Log	RSS
LineItemRepository.java	33246	833 d 15 h	ranu	Log	RSS
LineItemRepositoryImpl.java	33246	833 d 15 h	ranu	Log	RSS
LoanImeiRepository.java	36958	32 d 13 h	amit	Log	RSS
LoanImeiRepositoryImpl.java	36958	32 d 13 h	amit	Log	RSS
LoanRepository.java	36958	32 d 13 h	amit	Log	RSS
LoanRepositoryImpl.java	36958	32 d 13 h	amit	Log	RSS
LoanStatementReportModel.java	34713	401 d 11 h	aman.kumar	Log	RSS
LoanStatementRepository.java	36972	31 d 16 h	ranu	Log	RSS
LoanStatementRepositoryImpl.java	36972	31 d 16 h	ranu	Log	RSS
NotifyCancelOrderRepository.java	33247	833 d 15 h	ranu	Log	RSS
NotifyCancelOrderRepositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS
NotifyColorChangeRepository.java	33247	833 d 15 h	ranu	Log	RSS
NotifyColorChangeRepositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS
NotifyItemRepository.java	33247	833 d 15 h	ranu	Log	RSS
NotifyItemRepositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS
NotifyMessageRepository.java	25066	2605 d 12 h	tejbeer	Log	RSS
NotifyMessageRepositoryImpl.java	25066	2605 d 12 h	tejbeer	Log	RSS
NotifyOrderRespository.java	33247	833 d 15 h	ranu	Log	RSS
NotifyOrderRespositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS
OrderRepository.java	37089	18 d 14 h	amit	Log	RSS
OrderRepositoryImpl.java	37089	18 d 14 h	amit	Log	RSS
OrderWalletAdjustmentRepository.java	36713	66 d 10 h	amit	Log	RSS
OrderWalletAdjustmentRepositoryImpl.java	36713	66 d 10 h	amit	Log	RSS
OrganisationRepository.java	28988	1809 d 17 h	amit.gupta	Log	RSS
OrganisationRepositoryImpl.java	28988	1809 d 17 h	amit.gupta	Log	RSS
PaymentRepository.java	29497	1738 d 15 h	amit.gupta	Log	RSS
PaymentRepositoryImpl.java	29497	1738 d 15 h	amit.gupta	Log	RSS
PendingRechargeCommissionRepository.java	23110	3140 d 11 h	ashik.ali	Log	RSS
PendingRechargeCommissionRepositoryImpl.java	23110	3140 d 11 h	ashik.ali	Log	RSS
PriceDropIMEIRepository.java	34256	516 d 18 h	ranu	Log	RSS
PriceDropIMEIRepositoryImpl.java	34256	516 d 18 h	ranu	Log	RSS
PriceDropRepository.java	36999	30 d 11 h	amit	Log	RSS
PriceDropRepositoryImpl.java	36999	30 d 11 h	amit	Log	RSS
ReturnOrderInfoRepository.java	36972	31 d 16 h	ranu	Log	RSS
ReturnOrderInfoRepositoryImpl.java	36972	31 d 16 h	ranu	Log	RSS
ReturnOrderRepository.java	32724	963 d 9 h	amit.gupta	Log	RSS
ReturnOrderRepositoryImpl.java	24773	2688 d 4 h	amit.gupta	Log	RSS
ReturnTransactionRepository.java	32724	963 d 9 h	amit.gupta	Log	RSS
ReturnTransactionRepositoryImpl.java	32724	963 d 9 h	amit.gupta	Log	RSS
SanctionRequestRepository.java	34355	488 d 11 h	ranu	Log	RSS
SanctionRequestRepositoryImpl.java	34355	488 d 11 h	ranu	Log	RSS
SDCreditRequirementRepository.java	36438	92 d 17 h	amit	Log	RSS
SDCreditRequirementRepositoryImpl.java	36438	92 d 17 h	amit	Log	RSS
SellerRepository.java	35717	173 d 5 h	amit	Log	RSS
SellerRepositoryImpl.java	35717	173 d 5 h	amit	Log	RSS
SellerWarehouseRepository.java	36541	79 d 11 h	amit	Log	RSS
SellerWarehouseRepositoryImpl.java	36541	79 d 11 h	amit	Log	RSS
StatementDetailModel.java	28539	1855 d 11 h	amit.gupta	Log	RSS
TransactionApprovalRepository.java	36519	82 d 13 h	aman	Log	RSS
TransactionApprovalRepositoryImpl.java	36518	82 d 13 h	aman	Log	RSS
TransactionRepository.java	36008	137 d 9 h	aman	Log	RSS
TransactionRepositoryImpl.java	36328	102 d 14 h	amit	Log	RSS
TransactionShipmentSequenceRepository.java	33741	693 d 15 h	amit.gupta	Log	RSS
TransactionShipmentSequenceRepositoryImpl.java	33741	693 d 15 h	amit.gupta	Log	RSS
UserWalletHistoryRepository.java	36972	31 d 16 h	ranu	Log	RSS
UserWalletHistoryRepositoryImpl.java	36972	31 d 16 h	ranu	Log	RSS
UserWalletRepository.java	36372	99 d 16 h	amit	Log	RSS
UserWalletRepositoryImpl.java	36372	99 d 16 h	amit	Log	RSS
WarehouseAddressMappingRepository.java	33247	833 d 15 h	ranu	Log	RSS
WarehouseAddressMappingRepositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS
WarehouseAddressMasterRepository.java	33247	833 d 15 h	ranu	Log	RSS
WarehouseAddressMasterRepositoryImpl.java	33247	833 d 15 h	ranu	Log	RSS