SmartDukaan – /

Rev 35508 – lead repo done

ranu — Wed, 31 Dec 2025 15:31:50 +0530

ranu – 2 file(s) modified
lead repo done

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepositoryImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java

Rev 35507 – lead repo done

ranu — Wed, 31 Dec 2025 15:14:50 +0530

ranu – 3 file(s) modified
lead repo done

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepositoryImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java

Rev 35506 – Shopify Apis: Sync Products and Orders

vikas — Tue, 30 Dec 2025 14:50:44 +0530

vikas – 2 file(s) modified
Shopify Apis: Sync Products and Orders

x /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ShopifyGraphQLService.java
+ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ShopifyGraphQLShopifyService.java (copied from /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/ShopifyGraphQLService.java@35505)

Rev 35505 – today offer modal done

ranu — Tue, 30 Dec 2025 13:31:18 +0530

ranu – 2 file(s) modified
today offer modal done

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/price-circular.js

Rev 35504 – Shopify Apis: Sync Products and Orders

vikas — Tue, 30 Dec 2025 13:29:39 +0530

vikas – 7 file(s) modified
Shopify Apis: Sync Products and Orders

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/NotificationService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/NotificationServiceImpl.java
x /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/controllers/FofoShopifyController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/controllers/ShopifyController.java
+ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/controllers/ShopifyProductsController.java (copied from /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/controllers/FofoShopifyController.java@35503)
+ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/models/ProductInputModel.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/shopify/services/FofoShopifyService.java

Rev 35503 – Shopify : Orders

vikas — Tue, 30 Dec 2025 13:28:11 +0530

vikas – 15 file(s) modified
Shopify : Orders

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ContentPojo.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/shopify
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/shopify/OrderResponseModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifyGraphQLService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifyService.java
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/shopify
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/shopify/ShopifyController.java
+ /trunk/profitmandi-fofo/src/main/webapp/resources/js/shopify
+ /trunk/profitmandi-fofo/src/main/webapp/resources/js/shopify/shopify.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/include-scripts.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/shopify
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/shopify/order-detail.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/shopify/orders.vm

Rev 35502 – today offer modal done

ranu — Tue, 30 Dec 2025 13:06:25 +0530

ranu – 4 file(s) modified
today offer modal done

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/price-circular.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm

Rev 35501 – today offer modal done

ranu — Tue, 30 Dec 2025 12:52:59 +0530

ranu – 30 file(s) modified
today offer modal done

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/Catalog.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/CatalogBrief.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerCriteriaPojo.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PayoutSlabModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/SchemeOfferModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/TodayCatalogOfferModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/TodayOfferGroupKey.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/TodayOfferModel.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/WebOfferModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CatalogRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CatalogRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CustomerOfferItemRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CustomerOfferItemRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/ItemCriteriaRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/ItemCriteriaRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/SchemeRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/SchemeRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/integrations/icicilombard/IciciLombardService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/TodayOfferService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/TodayOfferServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OrderController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/price-circular.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/dashboard1.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/today-fofo-offer.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/today-offer-list.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/today-offer.vm

Rev 35500 – Fix:Gst Validation

aman — Mon, 29 Dec 2025 18:23:54 +0530

aman – 1 file(s) modified
Fix:Gst Validation

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/TrialUserController.java

Rev 35499 – Fix:Trial Activation Mail, All trial user page and gst validation

aman — Mon, 29 Dec 2025 18:22:44 +0530

aman – 11 file(s) modified
Fix:Trial Activation Mail, All trial user page and gst validation

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/TrialForm.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/user/PrivateDealUserRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/user/PrivateDealUserRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/TrialServiceImpl.java
~ /trunk/profitmandi-dao/src/main/resources/trial-activation-email.vm
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/TrialController.java
~ /trunk/profitmandi-fofo/src/main/resources/META-INF/env.property
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/trial-form.js
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/all-trial-form.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/trial-form.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/trial-verified.vm

Rev 35498 – Laptop show on offer

ranu — Mon, 29 Dec 2025 16:01:20 +0530

ranu – 1 file(s) modified
Laptop show on offer

~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/scheme_offer.js

Rev 35497 – Laptop show on offer

ranu — Mon, 29 Dec 2025 15:53:21 +0530

ranu – 3 file(s) modified
Laptop show on offer

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/scheme_offer.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/scheme_offer.vm

Rev 35496 – given laptop in category

ranu — Mon, 29 Dec 2025 12:08:48 +0530

ranu – 1 file(s) modified
given laptop in category

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/scheme_offer.vm

Rev 35495 – Fresh money allowance feature for B2B orders with overdue loans ...

amit — Wed, 24 Dec 2025 23:20:45 +0530

amit – 5 file(s) modified
Fresh money allowance feature for B2B orders with overdue loans

- SDCreditServiceImpl: Added validateOverdueLoans() to check if partner can place order
- SDCreditServiceImpl: Added getAvailableFreshMoney() to calculate same-day fresh money
- SDCreditServiceImpl: Partners with overdue loans can now place orders using fresh money added same day
- OrderRepository: Added selectTodayOrdersExcludingRefund() for fresh money calculation
- UserWalletHistoryRepository: Added methods to get today's payments and refunds

Logic: Fresh money = (Today's PAYMENT_GATEWAY + AUTOMATED_ADVANCE deposits) - (Today's orders excluding refunded) + (Today's refunds)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/UserWalletHistoryRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/UserWalletHistoryRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditServiceImpl.java

Rev 35494 – N+1 query optimization for B2B order creation flow - ...

amit — Wed, 24 Dec 2025 23:10:37 +0530

amit – 1 file(s) modified
N+1 query optimization for B2B order creation flow

- OrderController: Pre-fetch items and tagListings before cart line loop
- OrderController: Reuse brand stock data for both limit checks (3 queries instead of 6)

Performance improvement: ~20-30 DB queries reduced per order

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/OrderController.java

Rev 35493 – N+1 query optimization for B2B order creation flow - ...

amit — Wed, 24 Dec 2025 23:10:03 +0530

amit – 11 file(s) modified
N+1 query optimization for B2B order creation flow

- OrderServiceImpl: Batch fetch PendingOrderItems before validation loop (line 402)
- OrderServiceImpl: Batch update opening stock using minusOpeningStockBatch
- OrderServiceImpl: Pre-fetch tagListings and GST rates before createAndGetFofoOrderItem loop
- OrderServiceImpl: Batch fetch PendingOrderItems for status update (line 719)
- CartServiceImpl: Pre-fetch items before getCartValidation loop
- SchemeServiceImpl: Batch fetch SchemeInOut records in processSchemeOut
- SmartCartService: Added minusOpeningStockBatch method for batch updates
- TagListingRepository: Added selectByItemIds batch method
- FofoOpeningStockRepository: Added findByFofoIdAndCatalogIds batch method
- PendingOrderItemRepository: Added selectByIds batch method

Performance improvement: ~70-100 DB queries reduced per order (10 items avg)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/CartServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/SmartCartServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/FofoOpeningStockRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PendingOrderItemRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PendingOrderItemRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/OrderServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/SchemeServiceImpl.java

Rev 35492 – givemn fin service access to alok

ranu — Wed, 24 Dec 2025 19:17:10 +0530

ranu – 1 file(s) modified
givemn fin service access to alok

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ServiceConfigContoller.java

Rev 35491 – out of stock allocation

ranu — Wed, 24 Dec 2025 16:10:46 +0530

ranu – 1 file(s) modified
out of stock allocation

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/FileUploaderController.java

Rev 35490 – given brandwise placement acesseries qty instead of value

ranu — Tue, 23 Dec 2025 19:39:53 +0530

ranu – 9 file(s) modified
given brandwise placement acesseries qty instead of value

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/CurrentInventorySnapshot.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/InStockAccessoriesTvQtyFofoIdModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm

Rev 35489 – Fix:Trial Activation Mail

aman — Tue, 23 Dec 2025 18:32:48 +0530

aman – 3 file(s) modified
Fix:Trial Activation Mail

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
~ /trunk/profitmandi-dao/src/main/resources/trial-activation-email.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/trial-verified.vm

Rev 35488 – place ment plan page show catalog status wise

ranu — Tue, 23 Dec 2025 16:24:09 +0530

ranu – 1 file(s) modified
place ment plan page show catalog status wise

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java

Rev 35487 – place ment plan page show catalog status wise

ranu — Tue, 23 Dec 2025 16:19:38 +0530

ranu – 5 file(s) modified
place ment plan page show catalog status wise

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/Catalog.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CatalogRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/CatalogRepositoryImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/placement-plan.js

Rev 35486 – Listing Error: List should not be empty

vikas — Tue, 23 Dec 2025 13:24:22 +0530

vikas – 1 file(s) modified
Listing Error: List should not be empty

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/DealsController.java

Rev 35485 – Fix:Trial Add required to assign asm and bm in trial ...

aman — Tue, 23 Dec 2025 11:26:17 +0530

aman – 3 file(s) modified
Fix:Trial Add required to assign asm and bm in trial form and also add tarun sir in bcc

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/TrialServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/StoreTimelineTatServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/trial-form.js

Rev 35484 – in brnd wise placement showed qty instead of stock value ...

ranu — Mon, 22 Dec 2025 18:51:50 +0530

ranu – 2 file(s) modified
in brnd wise placement showed qty instead of stock value as per tarun sir

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-brandwise-detail.vm

Rev 35483 – Default null partnerType to Rising Star (PartnerType.NEW) in PartnerDetailModel.getPartnerType()

amit — Mon, 22 Dec 2025 15:11:44 +0530

amit – 2 file(s) modified
Default null partnerType to Rising Star (PartnerType.NEW) in PartnerDetailModel.getPartnerType()

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/PartnerDetailModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java

Rev 35482 – Default null partnerType to Rising Star (PartnerType.NEW) in getAllStatePartnerType

amit — Mon, 22 Dec 2025 15:10:25 +0530

amit – 1 file(s) modified
Default null partnerType to Rising Star (PartnerType.NEW) in getAllStatePartnerType

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java

Rev 35481 – Fix NPE in getAllStatePartnerType - add null checks for PartnerDetailModel ...

amit — Mon, 22 Dec 2025 15:02:53 +0530

amit – 1 file(s) modified
Fix NPE in getAllStatePartnerType - add null checks for PartnerDetailModel and partnerType

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java

Rev 35480 – Fix NPE in getWarehousePartners when warehouseId=0 and show all partner ...

amit — Mon, 22 Dec 2025 14:49:11 +0530

amit – 2 file(s) modified
Fix NPE in getWarehousePartners when warehouseId=0 and show all partner stats; add stack trace logging to GlobalExceptionHandler

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/GlobalExceptionHandler.java

Rev 35479 – Optimize Aging.SoldAgingModel query and fix column mapping - Changed ...

amit — Mon, 22 Dec 2025 02:15:05 +0530

amit – 1 file(s) modified
Optimize Aging.SoldAgingModel query and fix column mapping

- Changed DATEDIFF(NOW(), inv.invoiceDate) > 15 to sargable condition
- Fixed trailing spaces in column names (SLOWMOVING_Billed, RUNNING_Billed, etc.)
- Enables index usage on invoiceDate column

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

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

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Sold15daysOldAgingModel.java

Rev 35478 – Fix Aging.15DaysOurStock query - remove invalid p.warehouseId column - ...

amit — Mon, 22 Dec 2025 02:07:32 +0530

amit – 1 file(s) modified
Fix Aging.15DaysOurStock query - remove invalid p.warehouseId column

- Removed po.warehouseId = p.warehouseId (purchase table has no warehouseId)
- The warehouseId match is already handled in ii2 join: ii2.physicalWarehouseId = po.warehouseId
- Verified results match original query exactly

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

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

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java

Rev 35477 – Fix FASTMOVING column name trailing space in SqlResultSetMapping - ...

amit — Mon, 22 Dec 2025 01:52:02 +0530

amit – 1 file(s) modified
Fix FASTMOVING column name trailing space in SqlResultSetMapping

- Removed trailing space from "FASTMOVING " to "FASTMOVING"
- This was causing SQLGrammarException: could not extract ResultSet

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

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

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java

Rev 35476 – Optimize Aging.15DaysOurStock query for better performance - Restructured query ...

amit — Mon, 22 Dec 2025 01:48:18 +0530

amit – 1 file(s) modified
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>

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java

Rev 35475 – Optimize selectTodayOrdersRBM: Replace derived table subquery with direct JOINs - ...

amit — Mon, 22 Dec 2025 01:09:25 +0530

amit – 1 file(s) modified
Optimize selectTodayOrdersRBM: Replace derived table subquery with direct JOINs - 33x faster (78s -> 2.3s)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java

Rev 35474 – Optimize selectTodayOrders query: Replace OR with UNION ALL to avoid ...

amit — Mon, 22 Dec 2025 00:57:15 +0530

amit – 2 file(s) modified
Optimize selectTodayOrders query: Replace OR with UNION ALL to avoid sort_union operation for today_po endpoint

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java

Rev 35473 – Optimize selectTodayOrdersRBM query: Replace OR with UNION ALL to avoid ...

amit — Mon, 22 Dec 2025 00:50:10 +0530

amit – 1 file(s) modified
Optimize selectTodayOrdersRBM query: Replace OR with UNION ALL to avoid sort_union operation and improve query performance

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java

Rev 35472 – Leads Follow ups

vikas — Sun, 21 Dec 2025 23:44:00 +0530

vikas – 1 file(s) modified
Leads Follow ups

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepositoryImpl.java

Rev 35471 – Leads Follow ups

vikas — Sun, 21 Dec 2025 22:09:06 +0530

vikas – 1 file(s) modified
Leads Follow ups

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepositoryImpl.java

Rev 35470 – Leads Follow ups

vikas — Sun, 21 Dec 2025 20:27:47 +0530

vikas – 1 file(s) modified
Leads Follow ups

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/LeadRepositoryImpl.java

Rev 35469 – Leads Follow ups

vikas — Sun, 21 Dec 2025 20:17:36 +0530

vikas – 1 file(s) modified
Leads Follow ups

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/LeadController.java