Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ – Rev 35476

Last modification

Rev 35476 2025-12-22 01:48:18
Author: amit
Log message:
Optimize Aging.15DaysOurStock query for better performance

- Restructured query to start from invoice table with sargable date filter
- Changed DATEDIFF(now(), inv.invoiceDate) > 15 to inv.invoiceDate < DATE_SUB(CURDATE(), INTERVAL 15 DAY)
- Reordered JOINs for better query execution plan
- Allows MySQL to use index on invoiceDate for initial filtering

🤖 Generated with [Claude Code](https://claude.com/claude-code)

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

Path	Last modification			Log	RSS
affiliate/	34907	409 d 2 h	aman	Log	RSS
hdfc/	34329	567 d 2 h	aman.kumar	Log	RSS
loan/	34453	534 d 22 h	amit.gupta	Log	RSS
pendingOrder/	33436	855 d 6 h	ranu	Log	RSS
purchaseSaleRatio/	35062	380 d 18 h	amit	Log	RSS
scratch/	34474	532 d 22 h	aman.kumar	Log	RSS
thriwe/	32367	1140 d 19 h	tejbeer	Log	RSS
transaction/	34373	554 d 1 h	tejus.lohani	Log	RSS
warehouse/	34973	396 d 0 h	aman	Log	RSS
AccountStatementModel.java	28537	1924 d 2 h	amit.gupta	Log	RSS
ActivationBrandModel.java	29578	1792 d 5 h	tejbeer	Log	RSS
ActivationImeiUpdationModel.java	35466	292 d 5 h	amit	Log	RSS
ActivationItemDetailModel.java	29578	1792 d 5 h	tejbeer	Log	RSS
ActivationYearMonthModel.java	29578	1792 d 5 h	tejbeer	Log	RSS
ActivityMediaModel.java	32923	976 d 5 h	ranu	Log	RSS
AddCartRequest.java	26607	2346 d 3 h	amit.gupta	Log	RSS
AddPaymentRequest.java	32166	1205 d 1 h	amit.gupta	Log	RSS
AddPaymentResponse.java	25982	2496 d 1 h	amit.gupta	Log	RSS
AllPurchaseInventoryModel.java	30051	1693 d 3 h	manish	Log	RSS
AmountModel.java	32021	1241 d 1 h	amit.gupta	Log	RSS
AuthIdPartnerCountModel.java	33803	744 d 1 h	amit.gupta	Log	RSS
AuthUserPartnerMapModel.java	34082	651 d 4 h	ranu	Log	RSS
BilledOrderListModel.java	32609	1067 d 0 h	raveendra.bharati	Log	RSS
BillingDaysAvg.java	32044	1235 d 7 h	tejbeer	Log	RSS
BIRetailerModel.java	34915	407 d 5 h	ranu	Log	RSS
BiSecondaryModel.java	34619	498 d 22 h	ranu	Log	RSS
BrandAmountModel.java	29707	1753 d 5 h	tejbeer	Log	RSS
BrandAuthUserPOModel.java	35155	365 d 18 h	ranu	Log	RSS
BrandCountByStatus.java	34813	445 d 0 h	aman	Log	RSS
BrandItemWisePartnerSaleModel.java	35064	379 d 22 h	aman	Log	RSS
BrandItemWiseTertiaryModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
BrandRegionMappingModel.java	31816	1276 d 0 h	tejbeer	Log	RSS
BrandRegionModel.java	27893	2045 d 7 h	tejbeer	Log	RSS
BrandRegionPOModel.java	29969	1702 d 21 h	amit.gupta	Log	RSS
BrandWiseActivatedModel.java	28827	1892 d 8 h	tejbeer	Log	RSS
BrandWiseModel.java	28451	1952 d 23 h	tejbeer	Log	RSS
BrandWisePartnerSaleModel.java	35312	319 d 3 h	aman	Log	RSS
BrandWiseReturnInfo.java	34730	468 d 0 h	ranu	Log	RSS
BrandWiseTertiaryModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
BrandWiseUnbilledActivateStockModel.java	27676	2088 d 0 h	tejbeer	Log	RSS
CartItem.java	34902	412 d 22 h	vikas	Log	RSS
CartItemResponseModel.java	34884	417 d 5 h	vikas	Log	RSS
CartMessage.java	34186	605 d 0 h	vikas.jangra	Log	RSS
CartResponse.java	34186	605 d 0 h	vikas.jangra	Log	RSS
CategorisedCatalogListModel.java	34422	542 d 3 h	ranu	Log	RSS
ChartLeadModel.java	29272	1844 d 23 h	manish	Log	RSS
ClickToCallRequestModel.java	33585	814 d 3 h	ranu	Log	RSS
CollectionSummary.java	30158	1676 d 6 h	manish	Log	RSS
ContentDocsModel.java	33536	826 d 6 h	tejus.lohani	Log	RSS
ContentPojo.java	35346	307 d 22 h	ranu	Log	RSS
CreateLeacdActivityRequest.java	32472	1114 d 2 h	tejbeer	Log	RSS
CreateOfferRequest.java	35394	296 d 16 h	amit	Log	RSS
CreatePositionModel.java	31762	1289 d 2 h	tejbeer	Log	RSS
CreateRefferalRequest.java	35079	378 d 5 h	vikas	Log	RSS
CreateSchemeRequest.java	31170	1421 d 0 h	amit.gupta	Log	RSS
CreateWarehousePurchaseOrderModel.java	32825	1002 d 1 h	amit.gupta	Log	RSS
CurrentAvailableAndPurchaseQtyModel.java	34256	585 d 7 h	ranu	Log	RSS
CustomCustomerOffer.java	29707	1753 d 5 h	tejbeer	Log	RSS
CustomerOfferItemModel.java	34516	525 d 22 h	ranu	Log	RSS
CustomerOfferModel.java	31147	1425 d 1 h	tejbeer	Log	RSS
CustomerOrderAndInsuranceDetails.java	33436	855 d 6 h	ranu	Log	RSS
CustomerOrderDetail.java	29707	1753 d 5 h	tejbeer	Log	RSS
CustomPriceModel.java	29707	1753 d 5 h	tejbeer	Log	RSS
DailyStatementModel.java	30936	1491 d 2 h	tejbeer	Log	RSS
DataLeadModel.java	30771	1525 d 2 h	amit.gupta	Log	RSS
DateRangeModel.java	33136	932 d 2 h	amit.gupta	Log	RSS
DateWiseSoldCatalogQtyModel.java	34412	545 d 23 h	ranu	Log	RSS
DelayBillingModel.java	29347	1829 d 23 h	tejbeer	Log	RSS
DelayDayModel.java	29250	1849 d 0 h	tejbeer	Log	RSS
DispatchNotificationModel.java	32884	989 d 3 h	amit.gupta	Log	RSS
EligibleRewardItemsModel.java	35152	366 d 17 h	vikas	Log	RSS
EmployeeAttendanceModel.java	27498	2122 d 5 h	tejbeer	Log	RSS
ExpertReviewPojo.java	21545	3425 d 4 h	ashik.ali	Log	RSS
FinanceServiceFollowUpDateModel.java	29798	1733 d 4 h	manish	Log	RSS
FinanceServicesModel.java	29798	1733 d 4 h	manish	Log	RSS
FocoSaleReportModel.java	30158	1676 d 6 h	manish	Log	RSS
FocoSchemeOutReportModel.java	30158	1676 d 6 h	manish	Log	RSS
FofoAbmReportingModel.java	34905	409 d 5 h	ranu	Log	RSS
FofoFirstBillingModel.java	30674	1564 d 2 h	amit.gupta	Log	RSS
FofoForm.java	22183	3356 d 0 h	ashik.ali	Log	RSS
FofoIdCatalogQtyModel.java	28474	1945 d 20 h	tejbeer	Log	RSS
FofoIdItemDetailModel.java	28053	2034 d 6 h	tejbeer	Log	RSS
FofoIdQtyModel.java	28020	2038 d 7 h	tejbeer	Log	RSS
FofoInvestmentModel.java	34641	493 d 3 h	ranu	Log	RSS
FofoRBMReportingModel.java	33161	925 d 5 h	ranu	Log	RSS
FofoReportingModel.java	30003	1698 d 22 h	tejbeer	Log	RSS
GstAddressModel.java	33507	832 d 0 h	tejus.lohani	Log	RSS
HeaderInfoPojo.java	21545	3425 d 4 h	ashik.ali	Log	RSS
HidAllocationModel.java	34256	585 d 7 h	ranu	Log	RSS
ImeiActivationTimestampModel.java	30449	1603 d 2 h	amit.gupta	Log	RSS
ImeiInoviceModel.java	30698	1550 d 22 h	amit.gupta	Log	RSS
ImeiWiseIncomePairAndMapModel.java	32232	1171 d 22 h	amit.gupta	Log	RSS
InStockAccessoriesTvFofoIdModel.java	30003	1698 d 22 h	tejbeer	Log	RSS
InStockBrandFofoIdModel.java	30003	1698 d 22 h	tejbeer	Log	RSS
InStockBrandItemModel.java	27660	2089 d 23 h	tejbeer	Log	RSS
InStockBrandModel.java	27640	2094 d 0 h	tejbeer	Log	RSS
InStockCatalogItemModel.java	28590	1915 d 4 h	tejbeer	Log	RSS
InStockItemDetailModel.java	34495	528 d 18 h	ranu	Log	RSS
InventoryItemSaleModel.java	31146	1425 d 2 h	amit.gupta	Log	RSS
InvoiceWarehouseInfo.java	23615	3082 d 8 h	amit.gupta	Log	RSS
ItemCriteriaPayout.java	33745	762 d 0 h	amit.gupta	Log	RSS
ItemIdSum.java	23504	3111 d 5 h	ashik.ali	Log	RSS
ItemIdTypeQuantity.java	24267	2863 d 22 h	amit.gupta	Log	RSS
ItemLedgerRow.java	22522	3293 d 5 h	ashik.ali	Log	RSS
ItemPurchaseSummaryModel.java	33306	890 d 4 h	amit.gupta	Log	RSS
ItemTypeParams.java	27124	2193 d 23 h	amit.gupta	Log	RSS
ItemWiseCustomerOfferSummaryModel.java	34788	453 d 2 h	ranu	Log	RSS
ItemWisePurchaseModel.java	32246	1169 d 6 h	tejbeer	Log	RSS
ItemWiseTertiaryModel.java	27586	2103 d 23 h	tejbeer	Log	RSS
LastMonthBrandWiseIncomeModel.java	31286	1392 d 2 h	amit.gupta	Log	RSS
LastMonthCategoryUpgradeMargin.java	30051	1693 d 3 h	manish	Log	RSS
LastMonthCreditedIncomeModel.java	30051	1693 d 3 h	manish	Log	RSS
LastMonthFrontEndBrandWiseIncome.java	30238	1654 d 4 h	tejbeer	Log	RSS
LastMonthFrontEndImeiModel.java	32232	1171 d 22 h	amit.gupta	Log	RSS
LastMonthImeiModel.java	30237	1654 d 4 h	tejbeer	Log	RSS
LastSaleDateModel.java	32044	1235 d 7 h	tejbeer	Log	RSS
LeadBrandModel.java	31370	1379 d 2 h	tejbeer	Log	RSS
LeadDetailModel.java	31370	1379 d 2 h	tejbeer	Log	RSS
LeadStatusData.java	29272	1844 d 23 h	manish	Log	RSS
LimitedMasterDataPojo.java	21545	3425 d 4 h	ashik.ali	Log	RSS
LiveDemoOrderLineItemModel.java	33443	848 d 2 h	ranu	Log	RSS
LoanCountByFofoIdModel.java	33827	738 d 0 h	ranu	Log	RSS
LocationTrackingModel.java	35117	368 d 6 h	vikas	Log	RSS
LocationTrackingPathModel.java	35117	368 d 6 h	vikas	Log	RSS
LogisticsInfoPojo.java	21545	3425 d 4 h	ashik.ali	Log	RSS
LoiFormModel.java	33848	733 d 19 h	tejus.lohani	Log	RSS
MarginCalculatorModel.java	28493	1938 d 2 h	tejbeer	Log	RSS
MarkDeliveredModel.java	29250	1849 d 0 h	tejbeer	Log	RSS
MediaPojo.java	25380	2621 d 22 h	amit.gupta	Log	RSS
ModelWisePartnerPoModel.java	35174	362 d 22 h	ranu	Log	RSS
MonthlyTargetModel.java	31211	1410 d 5 h	tejbeer	Log	RSS
MonthSaleModel.java	28493	1938 d 2 h	tejbeer	Log	RSS
MTDAchievedTargetModel.java	34315	570 d 1 h	ranu	Log	RSS
NotEqualsModel.java	33045	949 d 5 h	amit.gupta	Log	RSS
OfferPayoutDumpReportModel.java	33010	954 d 23 h	shampa	Log	RSS
OfferRowModel.java	31778	1283 d 7 h	amit.gupta	Log	RSS
OfferSellinRowModel.java	32256	1166 d 15 h	tejbeer	Log	RSS
OnBoardingTimelineModel.java	28908	1884 d 6 h	tejbeer	Log	RSS
OpenPoItemModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
OpenPoModel.java	27739	2074 d 6 h	tejbeer	Log	RSS
Our15DaysOldAgingStock.java	35476	291 d 16 h	amit	Log	RSS
OurPurchaseItemModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
OurPurchaseModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
PartnerBillingSummaryModel.java	32906	980 d 22 h	amit.gupta	Log	RSS
PartnerBrandCommitmentModel.java	34168	617 d 2 h	tejus.lohani	Log	RSS
PartnerBrandLimit.java	30044	1694 d 7 h	tejbeer	Log	RSS
PartnerCollectionAchievementModel.java	30330	1631 d 0 h	tejbeer	Log	RSS
PartnerCollectionPlanModel.java	30812	1521 d 4 h	tejbeer	Log	RSS
PartnerCollectionRemarkModel.java	33041	951 d 1 h	ranu	Log	RSS
PartnerCommittment.java	30330	1631 d 0 h	tejbeer	Log	RSS
PartnerDealerMappingReportModel.java	34099	641 d 3 h	tejus.lohani	Log	RSS
PartnerDetailModel.java	32432	1121 d 6 h	amit.gupta	Log	RSS
PartnerMonthlySaleModel.java	32475	1114 d 1 h	amit.gupta	Log	RSS
PartnerOpeningStockByTodayModel.java	33873	723 d 17 h	ranu	Log	RSS
PartnerPendingIndentItemModel.java	27599	2101 d 6 h	tejbeer	Log	RSS
PartnerSecondaryModel.java	31540	1341 d 1 h	amit.gupta	Log	RSS
PartnerSecondaryPlanModel.java	30137	1678 d 18 h	tejbeer	Log	RSS
PartnerTargetAchievementModel.java	30416	1611 d 18 h	tejbeer	Log	RSS
PartnerTypeRegionBilledModel.java	31538	1341 d 2 h	amit.gupta	Log	RSS
PartnerTypeSecondaryModel.java	31538	1341 d 2 h	amit.gupta	Log	RSS
PartnerWiseActivatedNotBilledTotal.java	34641	493 d 3 h	ranu	Log	RSS
PaymentLinkDetailModel.java	33683	780 d 2 h	ranu	Log	RSS
PaymentOptionModel.java	28241	1999 d 6 h	amit.gupta	Log	RSS
PendingIndentReportModel.java	30158	1676 d 6 h	manish	Log	RSS
PendingPaymentUpgradeOfferModel.java	33838	736 d 6 h	ranu	Log	RSS
PoAndGrnPendingPartnerStockModel.java	33873	723 d 17 h	ranu	Log	RSS
PriceDropBrandModel.java	28641	1908 d 5 h	amit.gupta	Log	RSS
PriceDropReportModel.java	33143	931 d 3 h	tejus.lohani	Log	RSS
PriceDropWithDetailsByYearMonthModel.java	28455	1950 d 21 h	tejbeer	Log	RSS
PriceDropYearMonthModel.java	28443	1956 d 22 h	tejbeer	Log	RSS
PrintResourceModel.java	33501	832 d 22 h	ranu	Log	RSS
ProcessImeisModel.java	34210	597 d 23 h	tejus.lohani	Log	RSS
ProductPojo.java	22384	3321 d 10 h	amit.gupta	Log	RSS
ProviderDetailModel.java	29222	1851 d 2 h	tejbeer	Log	RSS
ProviderTatModel.java	29222	1851 d 2 h	tejbeer	Log	RSS
QtyAmountModel.java	35399	296 d 16 h	amit	Log	RSS
RbmAchievementsModel.java	34098	641 d 4 h	ranu	Log	RSS
RbmArrViewModel.java	34098	641 d 4 h	ranu	Log	RSS
RbmBilledFofoIdsModel.java	34146	627 d 6 h	ranu	Log	RSS
RBMPerformanceSummaryModel.java	32672	1044 d 6 h	amit.gupta	Log	RSS
RbMRatingModel.java	34276	581 d 2 h	ranu	Log	RSS
RbmTargetAndAchievementsModel.java	34098	641 d 4 h	ranu	Log	RSS
RbmTargetsModel.java	34098	641 d 4 h	ranu	Log	RSS
RbmWeeklyBillingModel.java	35453	293 d 3 h	amit	Log	RSS
RetailerFilterModel.java	32228	1173 d 1 h	amit.gupta	Log	RSS
RetailerFofoInterest.java	22496	3301 d 5 h	amit.gupta	Log	RSS
RetailerPeformanceFilterModel.java	32227	1173 d 1 h	amit.gupta	Log	RSS
ReturnOrderInfoModel.java	34464	533 d 4 h	ranu	Log	RSS
SaholicCISModel.java	34178	610 d 1 h	ranu	Log	RSS
SalesRatingModel.java	34322	568 d 22 h	ranu	Log	RSS
SamsungUpgradeOfferModel.java	29707	1753 d 5 h	tejbeer	Log	RSS
SanctionRequestModel.java	31020	1460 d 19 h	tejbeer	Log	RSS
SchemePayoutReportModel.java	33651	797 d 22 h	amit.gupta	Log	RSS
SdCreditRequirementModel.java	30859	1507 d 0 h	tejbeer	Log	RSS
SDCreditResponseOut.java	35087	377 d 22 h	amit	Log	RSS
SecondaeryOrderDateRange.java	27867	2047 d 19 h	tejbeer	Log	RSS
SecondaryOrderBilledLmsModel.java	28439	1960 d 23 h	tejbeer	Log	RSS
SecondaryOrderBillingModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
SecondaryOrderItemBillingModel.java	27749	2071 d 4 h	tejbeer	Log	RSS
SecondaryWarehouseWiseOrderBilllingModel.java	27867	2047 d 19 h	tejbeer	Log	RSS
SimpleCampaign.java	26369	2423 d 1 h	tejbeer	Log	RSS
SimpleCampaignParams.java	25374	2626 d 6 h	tejbeer	Log	RSS
SimpleItemType.java	26588	2353 d 22 h	tejbeer	Log	RSS
Sold15daysOldAgingModel.java	34098	641 d 4 h	ranu	Log	RSS
SoldAllCatalogitemQtyByPartnerModel.java	33873	723 d 17 h	ranu	Log	RSS
SoldCatalogsReportModel.java	34098	641 d 4 h	ranu	Log	RSS
SoldFocusedItemPartnerWiseModel.java	33873	723 d 17 h	ranu	Log	RSS
Specification.java	26498	2383 d 4 h	amit.gupta	Log	RSS
SpecificationGroup.java	21545	3425 d 4 h	ashik.ali	Log	RSS
StateGstRateModel.java	28507	1932 d 1 h	amit.gupta	Log	RSS
StoreTimelineModel.java	33879	721 d 3 h	tejus.lohani	Log	RSS
TargetModel.java	34428	541 d 22 h	ranu	Log	RSS
TargetSlab.java	27878	2047 d 2 h	amit.gupta	Log	RSS
TeamCommitmentModel.java	30771	1525 d 2 h	amit.gupta	Log	RSS
TicketListModel.java	33041	951 d 1 h	ranu	Log	RSS
TicketViewModel.java	32923	976 d 5 h	ranu	Log	RSS
TodayAchievedMovementModel.java	34098	641 d 4 h	ranu	Log	RSS
TotalTargetColectionModel.java	30808	1521 d 5 h	tejbeer	Log	RSS
UpgradeOfferItemDetailModel.java	29707	1753 d 5 h	tejbeer	Log	RSS
UpsellingReportModel.java	34134	632 d 5 h	ranu	Log	RSS
UserCart.java	21602	3417 d 6 h	ashik.ali	Log	RSS
UserVisitModel.java	31249	1397 d 6 h	tejbeer	Log	RSS
UserWalletCountVolumeModel.java	30003	1698 d 22 h	tejbeer	Log	RSS
VendorCatalogPricingModel.java	33465	840 d 5 h	ranu	Log	RSS
VendorDebitNoteModel.java	33729	765 d 2 h	ranu	Log	RSS
VendorPriceCircularModel.java	33729	765 d 2 h	ranu	Log	RSS
VerifiedB2CUsersModel.java	33305	890 d 6 h	ranu	Log	RSS
VideoUrlPojo.java	35346	307 d 22 h	ranu	Log	RSS
VideoUrlsContentPojo.java	35346	307 d 22 h	ranu	Log	RSS
VisitDescriptionModel.java	31249	1397 d 6 h	tejbeer	Log	RSS
VisitSummaryModel.java	31249	1397 d 6 h	tejbeer	Log	RSS
WalletMinMaxAmountModel.java	30003	1698 d 22 h	tejbeer	Log	RSS
WalletSummaryReportModel.java	30158	1676 d 6 h	manish	Log	RSS
WarehosueWiseItemStockAvailability.java	28056	2034 d 1 h	tejbeer	Log	RSS
WarehouseAmendPurchaseOrderModel.java	32145	1214 d 5 h	tejbeer	Log	RSS
WarehouseBrandItemUnbilledActivatedModel.java	27676	2088 d 0 h	tejbeer	Log	RSS
WarehouseBrandWiseItemActivatedModel.java	28827	1892 d 8 h	tejbeer	Log	RSS
WarehouseBrandWiseItemSaleModel.java	27676	2088 d 0 h	tejbeer	Log	RSS
WarehouseItemAgeingModel.java	35102	372 d 9 h	amit	Log	RSS
WarehouseMobileStockByMovementModel.java	34098	641 d 4 h	ranu	Log	RSS
WarehouseNewReceiveInvoiceModel.java	32311	1159 d 7 h	tejbeer	Log	RSS
WarehouseRbmTargetModel.java	33940	690 d 5 h	ranu	Log	RSS
WarehouseWalletAmountModel.java	31242	1400 d 0 h	amit.gupta	Log	RSS
WarehouseWiseActivatedModel.java	28827	1892 d 8 h	tejbeer	Log	RSS
WarehouseWiseBrandSaleModel.java	27676	2088 d 0 h	tejbeer	Log	RSS
WarehouseWiseBrandStockModel.java	27541	2113 d 0 h	tejbeer	Log	RSS
WarehouseWiseBrandUnbilledActivatedModel.java	27676	2088 d 0 h	tejbeer	Log	RSS
WarehouseWiseitemStockModel.java	35129	368 d 1 h	amit	Log	RSS
WarehouseWiseStockModel.java	27541	2113 d 0 h	tejbeer	Log	RSS
WodFinMappingModel.java	33887	716 d 5 h	tejus.lohani	Log	RSS