SmartDukaan – /

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