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	22 d 15 h	amit	Log	RSS
ActivityType.java	27140	2036 d 14 h	amit.gupta	Log	RSS
BadInventorySnapshot.java	31860	1102 d 18 h	tejbeer	Log	RSS
BrandWiseFollowUp.java	33618	649 d 14 h	tejus.lohani	Log	RSS
CatalogFavourite.java	31860	1102 d 18 h	tejbeer	Log	RSS
CurrentInventorySnapshot.java	35490	133 d 13 h	ranu	Log	RSS
CurrentPartnerDailyInvestment.java	35848	69 d 17 h	amit	Log	RSS
Customer.java	34917	250 d 15 h	vikas	Log	RSS
CustomerAddress.java	34190	448 d 13 h	aman.kumar	Log	RSS
CustomerCreditNote.java	31860	1102 d 18 h	tejbeer	Log	RSS
CustomerReturnItem.java	31860	1102 d 18 h	tejbeer	Log	RSS
CustomerWallet.java	31860	1102 d 18 h	tejbeer	Log	RSS
CustomerWalletHistory.java	31863	1102 d 18 h	tejbeer	Log	RSS
DebitNote.java	31860	1102 d 18 h	tejbeer	Log	RSS
DigifyRetailer.java	31786	1125 d 21 h	tejbeer	Log	RSS
FinServiceDocument.java	36152	33 d 21 h	aman	Log	RSS
FinServiceRequest.java	36152	33 d 21 h	aman	Log	RSS
FinServiceTemplate.java	36152	33 d 21 h	aman	Log	RSS
FofoKyc.java	35279	174 d 15 h	amit	Log	RSS
FofoLineItem.java	31860	1102 d 18 h	tejbeer	Log	RSS
FofoNonSerializeSerial.java	32816	846 d 16 h	ranu	Log	RSS
FofoOpeningStock.java	36282	19 d 14 h	amit	Log	RSS
FofoOrder.java	35537	117 d 9 h	amit	Log	RSS
FofoOrderItem.java	35651	91 d 15 h	aman	Log	RSS
FofoPartnerPaymentOption.java	31860	1102 d 18 h	tejbeer	Log	RSS
FofoPayment.java	31860	1102 d 18 h	tejbeer	Log	RSS
FofoStockAllocation.java	24673	2615 d 19 h	amit.gupta	Log	RSS
FofoStore.java	36242	25 d 13 h	aman	Log	RSS
FofoStoreGeofence.java	31860	1102 d 18 h	tejbeer	Log	RSS
HygieneData.java	32066	1072 d 22 h	tejbeer	Log	RSS
IciciPincodeMaster.java	34798	294 d 16 h	ranu	Log	RSS
IciciPincodeMasterRepository.java	34798	294 d 16 h	ranu	Log	RSS
IciciPincodeMasterRepositoryImpl.java	34798	294 d 16 h	ranu	Log	RSS
InActiveFofoStore.java	31860	1102 d 18 h	tejbeer	Log	RSS
Indent.java	31860	1102 d 18 h	tejbeer	Log	RSS
IndentItem.java	31860	1102 d 18 h	tejbeer	Log	RSS
InventoryItem.java	35856	68 d 16 h	amit	Log	RSS
InvoiceNumberGenerationSequence.java	31860	1102 d 18 h	tejbeer	Log	RSS
LiveDemoSerialNumber.java	31860	1102 d 18 h	tejbeer	Log	RSS
LoanTransaction.java	34213	440 d 20 h	ranu	Log	RSS
MonthlyPlanned.java	31860	1102 d 18 h	tejbeer	Log	RSS
MonthlyTarget.java	31860	1102 d 18 h	tejbeer	Log	RSS
Mou.java	31860	1102 d 18 h	tejbeer	Log	RSS
OfferPayout.java	36184	31 d 19 h	amit	Log	RSS
PartnerBrandService.java	31860	1102 d 18 h	tejbeer	Log	RSS
PartnerDailyInvestment.java	35849	69 d 16 h	amit	Log	RSS
PartnerDealerMapping.java	34099	484 d 18 h	tejus.lohani	Log	RSS
PartnerOnBoardingPanel.java	34085	494 d 14 h	tejus.lohani	Log	RSS
PartnerOnboardingTrainingPanel.java	31860	1102 d 18 h	tejbeer	Log	RSS
PartnerProblem.java	31860	1102 d 18 h	tejbeer	Log	RSS
PartnerService.java	29798	1576 d 20 h	manish	Log	RSS
PartnerServiceComment.java	33618	649 d 14 h	tejus.lohani	Log	RSS
PartnerTarget.java	25432	2460 d 14 h	amit.gupta	Log	RSS
PartnerTargetDetails.java	31860	1102 d 18 h	tejbeer	Log	RSS
PartnerType.java	32003	1089 d 13 h	amit.gupta	Log	RSS
PartnerTypeChange.java	35509	125 d 17 h	amit	Log	RSS
PartnerTypeSource.java	35509	125 d 17 h	amit	Log	RSS
PartnerVerificationCheckboxes.java	35971	57 d 14 h	aman	Log	RSS
PartnerVerificationpanel.java	33884	560 d 22 h	tejus.lohani	Log	RSS
PaymentOption.java	33845	577 d 20 h	tejus.lohani	Log	RSS
PendingOrder.java	31860	1102 d 18 h	tejbeer	Log	RSS
PendingOrderItem.java	34902	256 d 13 h	vikas	Log	RSS
PendingOrderPlan.java	34287	421 d 14 h	vikas.jangra	Log	RSS
PincodePartner.java	31860	1102 d 18 h	tejbeer	Log	RSS
PineLabs.java	35394	140 d 7 h	amit	Log	RSS
PinelabsCustomer.java	35652	91 d 13 h	vikas	Log	RSS
PinelabsOrder.java	35652	91 d 13 h	vikas	Log	RSS
PinelabsPaymentMethod.java	35405	140 d 6 h	amit	Log	RSS
PinelabsRefund.java	35406	140 d 6 h	amit	Log	RSS
PlannedDetail.java	31860	1102 d 18 h	tejbeer	Log	RSS
PrebookingListing.java	31860	1102 d 18 h	tejbeer	Log	RSS
PrebookingOrder.java	35833	71 d 14 h	amit	Log	RSS
PrintResource.java	33501	676 d 13 h	ranu	Log	RSS
PrintResourceRegion.java	33443	691 d 17 h	ranu	Log	RSS
Purchase.java	31860	1102 d 18 h	tejbeer	Log	RSS
PurchaseReturnItem.java	36103	36 d 13 h	amit	Log	RSS
PurchaseReturnOrder.java	35997	52 d 13 h	amit	Log	RSS
RazorPay.java	28367	1821 d 14 h	tejbeer	Log	RSS
RbmRating.java	36101	36 d 15 h	ranu	Log	RSS
RequestedHidAllocation.java	34198	447 d 15 h	ranu	Log	RSS
RetailerContact.java	35648	91 d 21 h	ranu	Log	RSS
RetailerFilter.java	32044	1078 d 22 h	tejbeer	Log	RSS
SaleHeadDetails.java	24135	2769 d 21 h	govind	Log	RSS
SalesHead.java	24131	2770 d 20 h	govind	Log	RSS
SalesRating.java	34322	412 d 13 h	ranu	Log	RSS
SamsungException.java	33600	652 d 14 h	ranu	Log	RSS
SamsungPCM.java	31706	1151 d 16 h	amit.gupta	Log	RSS
ScanRecord.java	31860	1102 d 18 h	tejbeer	Log	RSS
SchemeInOut.java	36184	31 d 19 h	amit	Log	RSS
SchemeItem.java	34317	412 d 20 h	amit.gupta	Log	RSS
ServiceBrandsConfig.java	31860	1102 d 18 h	tejbeer	Log	RSS
SmartCartSuggestion.java	34941	244 d 22 h	ranu	Log	RSS
StockAllocation.java	24229	2726 d 14 h	amit.gupta	Log	RSS
SuggestedPo.java	31860	1102 d 18 h	tejbeer	Log	RSS
SuggestedPoDetail.java	31860	1102 d 18 h	tejbeer	Log	RSS
TrialBrandPotential.java	35337	154 d 15 h	aman	Log	RSS
TrialFeedbackForm.java	35337	154 d 15 h	aman	Log	RSS
TrialForm.java	35642	92 d 21 h	aman	Log	RSS
UpSaleAgentCollection.java	33715	614 d 22 h	ranu	Log	RSS
UpSaleCall.java	34134	475 d 20 h	ranu	Log	RSS
UpSaleOrder.java	33720	614 d 15 h	ranu	Log	RSS
UpsellCallDetail.java	33715	614 d 22 h	ranu	Log	RSS
UpsellRazorpayPaymentStatus.java	33715	614 d 22 h	ranu	Log	RSS