| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 35442 |
219 d 16 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 |
220 d 16 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 |
222 d 10 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Fixed MongoDB close method |
|
| 35361 |
229 d 16 h |
aman |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Feat:Trial user mails for pending Verification and store code |
|
| 35358 |
229 d 21 h |
ranu |
/trunk/ |
eol item remove from listing b2b (solr) |
|
| 35330 |
241 d 15 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed loan issue |
|
| 35329 |
242 d 10 h |
ranu |
/trunk/ |
fix openinng stock |
|
| 35326 |
242 d 16 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed Schedule Tasks |
|
| 35299 |
249 d 17 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Fixed Scheduled Task Logic |
|
| 35295 |
251 d 20 h |
amit |
/trunk/ |
Added reset logic |
|
| 35277 |
256 d 18 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Migrations |
|
| 35276 |
256 d 18 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Migrations |
|
| 35267 |
258 d 19 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
without invoice cancel request |
|
| 35266 |
258 d 19 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
without invoice cancel request |
|
| 35265 |
258 d 19 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
Migrations |
|
| 35250 |
268 d 17 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
Migrations |
|
| 35239 |
271 d 21 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
bi report exception |
|
| 35238 |
271 d 21 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
bi report exception |
|
| 35237 |
271 d 22 h |
ranu |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
bi report exception |
|
| 35179 |
287 d 16 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/ |
Added SD Credit Scheduler |
|