SmartDukaan – /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.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 34098 – eol-slow, slow-runn migartion

ranu — Mon, 06 Jan 2025 13:36:24 +0530

ranu – 26 file(s) modified
eol-slow, slow-runn migartion

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/RbmAchievements.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/RbmTargets.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/inventory/CatalogMovingEnum.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/RbmAchievementsModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/RbmArrViewModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/RbmTargetAndAchievementsModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/RbmTargetsModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Sold15daysOldAgingModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/SoldCatalogsReportModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/TodayAchievedMovementModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/WarehouseMobileStockByMovementModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/RbmAchievementsRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/RbmTargetsRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/RbmTargetServiceImpl.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/IndentController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/InventoryController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/inventory.js
x /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/catagorised-catalog-list.vm
x /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/catagorised-catalog.vm
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/categoriesed-catalog-list.vm (copied from /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/catagorised-catalog-list.vm@34097)
+ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/categoriesed-catalog.vm (copied from /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/catagorised-catalog.vm@34097)
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-target-achievement.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-today-arr.vm

Rev 34074 – format done according to shankar sir on aging modal

ranu — Mon, 23 Dec 2024 14:56:48 +0530

ranu – 3 file(s) modified
format done according to shankar sir on aging modal

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Sold15daysOldAgingModel.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-today-arr.vm

Rev 34068 – warehouse invoice migration

ranu — Thu, 19 Dec 2024 23:06:36 +0530

ranu – 6 file(s) modified
warehouse invoice migration

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/BrandAgeingLimit.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/warehouse/WarehousePurchase.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Sold15daysOldAgingModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PurchaseOrderService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PurchaseOrderServiceImpl.java

Rev 34058 – 15 days old sold aging model comiited

ranu — Mon, 16 Dec 2024 17:44:18 +0530

ranu – 1 file(s) modified
15 days old sold aging model comiited

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

Rev 34055 – 15 days old sold aging model comiited

ranu — Mon, 16 Dec 2024 16:10:02 +0530

ranu – 9 file(s) modified
15 days old sold aging model comiited

+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Our15DaysOldAgingStock.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/Sold15daysOldAgingModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/TodayAchievedMovementModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/RbmTargetService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/RbmTargetServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/monitors/MonitorController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/rbm-today-arr.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/today_po_rbm.vm