Subversion Repositories SmartDukaan

Rev

Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35478 142 d 21 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ 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>		  
35477 142 d 22 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ 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>		  
35476 142 d 22 h amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ 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>		  
34098 492 d 10 h ranu /trunk/ eol-slow, slow-runn migartion  
34074 506 d 8 h ranu /trunk/ format done according to shankar sir on aging modal  
34068 510 d 0 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ warehouse invoice migration  
34058 513 d 6 h ranu /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ 15 days old sold aging model comiited  
34055 513 d 7 h ranu /trunk/ 15 days old sold aging model comiited