Subversion Repositories SmartDukaan

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

Last modification

Rev 36282 2026-04-16 19:24:59
Author: amit
Log message:
Optimize /partner/hidAllocation: replace N+1 getSpilitStock loop with batch call, add fofo_id filter to sales subquery, fix DATE() preventing index usage on create_timestamp

Path	Last modification			Log	RSS
ActivatedImei.java	36261	177 d 18 h	amit	Log	RSS
ActivityType.java	27140	2191 d 17 h	amit.gupta	Log	RSS
BadInventorySnapshot.java	31860	1257 d 21 h	tejbeer	Log	RSS
BrandWiseFollowUp.java	33618	804 d 17 h	tejus.lohani	Log	RSS
CatalogFavourite.java	31860	1257 d 21 h	tejbeer	Log	RSS
CurrentInventorySnapshot.java	35490	288 d 16 h	ranu	Log	RSS
CurrentPartnerDailyInvestment.java	35848	224 d 21 h	amit	Log	RSS
Customer.java	34917	405 d 18 h	vikas	Log	RSS
CustomerAddress.java	34190	603 d 16 h	aman.kumar	Log	RSS
CustomerCreditNote.java	31860	1257 d 21 h	tejbeer	Log	RSS
CustomerReturnItem.java	31860	1257 d 21 h	tejbeer	Log	RSS
CustomerWallet.java	31860	1257 d 21 h	tejbeer	Log	RSS
CustomerWalletHistory.java	31863	1257 d 21 h	tejbeer	Log	RSS
DebitNote.java	31860	1257 d 21 h	tejbeer	Log	RSS
DigifyRetailer.java	31786	1281 d 0 h	tejbeer	Log	RSS
FinServiceDocument.java	36152	189 d 0 h	aman	Log	RSS
FinServiceRequest.java	36152	189 d 0 h	aman	Log	RSS
FinServiceTemplate.java	36152	189 d 0 h	aman	Log	RSS
FofoKyc.java	35279	329 d 18 h	amit	Log	RSS
FofoLineItem.java	31860	1257 d 21 h	tejbeer	Log	RSS
FofoNonSerializeSerial.java	32816	1001 d 20 h	ranu	Log	RSS
FofoOpeningStock.java	36282	174 d 17 h	amit	Log	RSS
FofoOrder.java	35537	272 d 12 h	amit	Log	RSS
FofoOrderItem.java	35651	246 d 18 h	aman	Log	RSS
FofoPartnerPaymentOption.java	31860	1257 d 21 h	tejbeer	Log	RSS
FofoPayment.java	31860	1257 d 21 h	tejbeer	Log	RSS
FofoStockAllocation.java	24673	2770 d 22 h	amit.gupta	Log	RSS
FofoStore.java	36242	180 d 16 h	aman	Log	RSS
FofoStoreGeofence.java	31860	1257 d 21 h	tejbeer	Log	RSS
HygieneData.java	32066	1228 d 1 h	tejbeer	Log	RSS
IciciPincodeMaster.java	34798	449 d 19 h	ranu	Log	RSS
IciciPincodeMasterRepository.java	34798	449 d 19 h	ranu	Log	RSS
IciciPincodeMasterRepositoryImpl.java	34798	449 d 19 h	ranu	Log	RSS
InActiveFofoStore.java	31860	1257 d 21 h	tejbeer	Log	RSS
Indent.java	31860	1257 d 21 h	tejbeer	Log	RSS
IndentItem.java	31860	1257 d 21 h	tejbeer	Log	RSS
InventoryItem.java	35856	223 d 19 h	amit	Log	RSS
InvoiceNumberGenerationSequence.java	31860	1257 d 21 h	tejbeer	Log	RSS
LiveDemoSerialNumber.java	31860	1257 d 21 h	tejbeer	Log	RSS
LoanTransaction.java	34213	595 d 23 h	ranu	Log	RSS
MonthlyPlanned.java	31860	1257 d 21 h	tejbeer	Log	RSS
MonthlyTarget.java	31860	1257 d 21 h	tejbeer	Log	RSS
Mou.java	31860	1257 d 21 h	tejbeer	Log	RSS
OfferPayout.java	36184	186 d 22 h	amit	Log	RSS
PartnerBrandService.java	31860	1257 d 21 h	tejbeer	Log	RSS
PartnerDailyInvestment.java	35849	224 d 19 h	amit	Log	RSS
PartnerDealerMapping.java	34099	639 d 21 h	tejus.lohani	Log	RSS
PartnerOnBoardingPanel.java	34085	649 d 17 h	tejus.lohani	Log	RSS
PartnerOnboardingTrainingPanel.java	31860	1257 d 21 h	tejbeer	Log	RSS
PartnerProblem.java	31860	1257 d 21 h	tejbeer	Log	RSS
PartnerService.java	29798	1731 d 23 h	manish	Log	RSS
PartnerServiceComment.java	33618	804 d 17 h	tejus.lohani	Log	RSS
PartnerTarget.java	25432	2615 d 17 h	amit.gupta	Log	RSS
PartnerTargetDetails.java	31860	1257 d 21 h	tejbeer	Log	RSS
PartnerType.java	32003	1244 d 16 h	amit.gupta	Log	RSS
PartnerTypeChange.java	35509	280 d 20 h	amit	Log	RSS
PartnerTypeSource.java	35509	280 d 20 h	amit	Log	RSS
PartnerVerificationCheckboxes.java	35971	212 d 17 h	aman	Log	RSS
PartnerVerificationpanel.java	33884	716 d 1 h	tejus.lohani	Log	RSS
PaymentOption.java	33845	732 d 23 h	tejus.lohani	Log	RSS
PendingOrder.java	31860	1257 d 21 h	tejbeer	Log	RSS
PendingOrderItem.java	34902	411 d 16 h	vikas	Log	RSS
PendingOrderPlan.java	34287	576 d 17 h	vikas.jangra	Log	RSS
PincodePartner.java	31860	1257 d 21 h	tejbeer	Log	RSS
PineLabs.java	35394	295 d 11 h	amit	Log	RSS
PinelabsCustomer.java	35652	246 d 16 h	vikas	Log	RSS
PinelabsOrder.java	35652	246 d 16 h	vikas	Log	RSS
PinelabsPaymentMethod.java	35405	295 d 9 h	amit	Log	RSS
PinelabsRefund.java	35406	295 d 9 h	amit	Log	RSS
PlannedDetail.java	31860	1257 d 21 h	tejbeer	Log	RSS
PrebookingListing.java	31860	1257 d 21 h	tejbeer	Log	RSS
PrebookingOrder.java	35833	226 d 17 h	amit	Log	RSS
PrintResource.java	33501	831 d 16 h	ranu	Log	RSS
PrintResourceRegion.java	33443	846 d 20 h	ranu	Log	RSS
Purchase.java	31860	1257 d 21 h	tejbeer	Log	RSS
PurchaseReturnItem.java	36103	191 d 17 h	amit	Log	RSS
PurchaseReturnOrder.java	35997	207 d 17 h	amit	Log	RSS
RazorPay.java	28367	1976 d 17 h	tejbeer	Log	RSS
RbmRating.java	36101	191 d 18 h	ranu	Log	RSS
RequestedHidAllocation.java	34198	602 d 18 h	ranu	Log	RSS
RetailerContact.java	35648	247 d 0 h	ranu	Log	RSS
RetailerFilter.java	32044	1234 d 1 h	tejbeer	Log	RSS
SaleHeadDetails.java	24135	2925 d 0 h	govind	Log	RSS
SalesHead.java	24131	2925 d 23 h	govind	Log	RSS
SalesRating.java	34322	567 d 16 h	ranu	Log	RSS
SamsungException.java	33600	807 d 17 h	ranu	Log	RSS
SamsungPCM.java	31706	1306 d 19 h	amit.gupta	Log	RSS
ScanRecord.java	31860	1257 d 21 h	tejbeer	Log	RSS
SchemeInOut.java	36184	186 d 22 h	amit	Log	RSS
SchemeItem.java	34317	568 d 0 h	amit.gupta	Log	RSS
ServiceBrandsConfig.java	31860	1257 d 21 h	tejbeer	Log	RSS
SmartCartSuggestion.java	34941	400 d 1 h	ranu	Log	RSS
StockAllocation.java	24229	2881 d 17 h	amit.gupta	Log	RSS
SuggestedPo.java	31860	1257 d 21 h	tejbeer	Log	RSS
SuggestedPoDetail.java	31860	1257 d 21 h	tejbeer	Log	RSS
TrialBrandPotential.java	35337	309 d 18 h	aman	Log	RSS
TrialFeedbackForm.java	35337	309 d 18 h	aman	Log	RSS
TrialForm.java	35642	248 d 0 h	aman	Log	RSS
UpSaleAgentCollection.java	33715	770 d 1 h	ranu	Log	RSS
UpSaleCall.java	34134	630 d 23 h	ranu	Log	RSS
UpSaleOrder.java	33720	769 d 18 h	ranu	Log	RSS
UpsellCallDetail.java	33715	770 d 1 h	ranu	Log	RSS
UpsellRazorpayPaymentStatus.java	33715	770 d 1 h	ranu	Log	RSS