Subversion Repositories SmartDukaan

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>