| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 35447 |
297 d 3 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fix N+1 query in refundDnAmount() - batch fetch TagListings |
|
| 35446 |
297 d 3 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 |
297 d 3 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 |
298 d 3 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 |
299 d 21 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Fixed MongoDB close method |
|
| 35330 |
319 d 2 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed loan issue |
|
| 35329 |
319 d 21 h |
ranu |
/trunk/ |
fix openinng stock |
|
| 35326 |
320 d 4 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed Schedule Tasks |
|
| 35299 |
327 d 4 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed Scheduled Task Logic |
|
| 35295 |
329 d 8 h |
amit |
/trunk/ |
Added reset logic |
|
| 35177 |
365 d 4 h |
amit |
/trunk/ |
Added SD Credit Scheduler |
|
| 35165 |
368 d 7 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Fixed system.exit(0) |
|
| 35160 |
368 d 9 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed SD Credit HardLimit Check |
|
| 35157 |
368 d 9 h |
amit |
/trunk/ |
Fixed SD Credit HardLimit Check |
|
| 35151 |
369 d 23 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
donotcommit |
|
| 35150 |
369 d 23 h |
vikas |
/trunk/ |
Oppo Sale Rewards Duration Wise |
|
| 35145 |
370 d 5 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 |
371 d 4 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Added scheduled Tasks |
|
| 35115 |
373 d 3 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 |
373 d 3 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
due date cross added all active loan and change title this mail |
|