Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
35446 197 d 9 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Use selectAllByItems() to avoid duplicate item fetch in checkfocusedModelInPartnerStock

- Pass pre-fetched items to tagListingRepository.selectAllByItems()
- Eliminates redundant itemRepository.selectAllByCatalogIds() call

🤖 Generated with Claude Code
 
35442 197 d 9 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Optimize checkfocusedModelInPartnerStock() - fix N+1 queries with batch fetching

- Reduced ~23,500 DB calls to ~12 batch queries
- Batch fetch customRetailers, inventory snapshots, GRN orders, items, tagListings upfront
- Fixed bug: partnerIdSalesHeadersMap.get(fofoStore.getId()) instead of get(fofoStore)

🤖 Generated with Claude Code
 
35424 198 d 9 h amit /trunk/ Fix order billing vs cancellation race condition with pessimistic locking

Problem:
- Concurrent billing and cancellation of the same order caused data inconsistency
- Money was refunded to wallet while order was also getting billed

Solution:
- Added pessimistic locking (SELECT FOR UPDATE) to prevent concurrent modifications
- Added validation methods to check order state before billing/cancellation
- Optimized billing method to reduce lock duration with pre-fetching

Changes:
- OrderRepository: Added selectByIdForUpdate, selectByOrderIdsForUpdate,
selectByInvoiceNumbersForUpdate, selectAllByTransactionIdForUpdate,
validateOrdersForBilling, validateOrderForRefund methods
- OrderRepositoryImpl: Implemented locking methods with PESSIMISTIC_WRITE
- TransactionServiceImpl: Updated billing methods with locking, fail-fast
validation, pre-fetching to avoid N+1 queries
- ScheduledTasks: Updated removePartialBillingForTransaction with locking
- TransactionRelatedTasks: Updated reverseRTO with locking
 
35393 200 d 3 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Fixed MongoDB close method  
35330 219 d 8 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Fixed loan issue  
35329 220 d 3 h ranu /trunk/ fix openinng stock  
35326 220 d 10 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Fixed Schedule Tasks  
35299 227 d 10 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Fixed Scheduled Task Logic  
35295 229 d 14 h amit /trunk/ Added reset logic  
35177 265 d 10 h amit /trunk/ Added SD Credit Scheduler  
35165 268 d 13 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Fixed system.exit(0)  
35160 268 d 15 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ Fixed SD Credit HardLimit Check  
35157 268 d 15 h amit /trunk/ Fixed SD Credit HardLimit Check  
35151 270 d 5 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ donotcommit  
35150 270 d 5 h vikas /trunk/ Oppo Sale Rewards Duration Wise  
35145 270 d 10 h amit /trunk/ Now minimum investment is changed dynamically based on total investment and limit utilized for retailers whose credit is marked as hard limit.  
35132 271 d 10 h amit /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ Added scheduled Tasks  
35115 273 d 9 h ranu /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ due date cross added all active loan and change title this mail  
35114 273 d 9 h ranu /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ due date cross added all active loan and change title this mail  
35113 273 d 9 h ranu /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ due date cross added all active loan and change title this mail  

Show All