SmartDukaan – /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36430 – Add fixStuckLimitBlocks remediation for stuck limit_block=1 loans (Apr 27-29). Calls ...

amit — Wed, 29 Apr 2026 22:38:27 +0530

amit – 1 file(s) modified
Add fixStuckLimitBlocks remediation for stuck limit_block=1 loans (Apr 27-29). Calls createLoanForBilling per invoice for each stuck limit block, creating actual loans and settling blocked limits. Validated locally: 59 fixes, 0 failures, all wallets net to zero.

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36420 – OkHttp→RestClient migration for IMEI activation services (Itel, Tecno, Vivo). Added ...

amit — Tue, 28 Apr 2026 18:18:07 +0530

amit – 8 file(s) modified
OkHttp→RestClient migration for IMEI activation services (Itel, Tecno, Vivo). Added test deps. Updated RunOnceTasks, ScheduledTasks, OrderTrackingService.

~ /trunk/profitmandi-cron/build.gradle
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/itelImeiActivation/ItelImeiActivationNewService.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/itelImeiActivation/ItelImeiActivationService.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/itelImeiActivation/TecnoImeiActivation.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ordertracking/OrderTrackingService.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/VivoImeiActivationService.java

Rev 36402 – Replace mailSender (SendGrid) with gmailRelaySender - SendGrid API key expired/revoked

amit — Mon, 27 Apr 2026 14:53:33 +0530

amit – 7 file(s) modified
Replace mailSender (SendGrid) with gmailRelaySender - SendGrid API key expired/revoked

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/OnBoardingRelatedSchelduleTask.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/razorpay/FetchPartnersDisbursementTask.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/Reconciliation.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasksTest.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/TicketRelatedScheduledTask.java

Rev 36303 – Feat:Separate partner name and code into different columns in Partner ...

aman — Fri, 17 Apr 2026 18:39:52 +0530

aman – 1 file(s) modified
Feat:Separate partner name and code into different columns in Partner Credit Report

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36289 – hadb1 perf: add SD_CREDIT_LOCK to prevent deadlock on sd_credit_requirement, sort ...

amit — Fri, 17 Apr 2026 12:38:49 +0530

amit – 1 file(s) modified
hadb1 perf: add SD_CREDIT_LOCK to prevent deadlock on sd_credit_requirement, sort updatePartnerLimit by fofoId

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36269 – consolidate email sent of l3 escaltion

ranu — Tue, 14 Apr 2026 16:22:07 +0530

ranu – 1 file(s) modified
consolidate email sent of l3 escaltion

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36253 – Separate secondary/tertiary IMEI activation crons for Vivo/Oppo/Realme, perf fixes: shared ...

amit — Sun, 12 Apr 2026 10:26:19 +0530

amit – 8 file(s) modified
Separate secondary/tertiary IMEI activation crons for Vivo/Oppo/Realme, perf fixes: shared saveActivation, Response leak fixes, /tmp cleanup, OpenCV static init, early break, remove class-level @Transactional from StandAlone

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/CheckOppoWarrantyTask.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/CheckRealmeWarrantyTask.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/OppoImeiActivationService.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/RealmeImeiActivationService.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/StandAlone.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/VivoImeiActivationService.java

Rev 36220 – Cron: add --genDNs CLI arg for monthly debit note generation. ...

amit — Wed, 08 Apr 2026 12:22:20 +0530

amit – 2 file(s) modified
Cron: add --genDNs CLI arg for monthly debit note generation. Use SDCreditServiceImpl.computeInterestStartDate for daily interest accrual (single source of truth, fixes off-by-one that delayed accrual by 1 day).

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36197 – Add --recoverCreditNote and --resendCNReport CLI args for credit note recovery ...

amit — Mon, 06 Apr 2026 19:23:44 +0530

amit – 2 file(s) modified
Add --recoverCreditNote and --resendCNReport CLI args for credit note recovery and report resend

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36188 – Revert rerenderCNs CLI option - downloadCN already re-renders on the ...

amit — Sat, 04 Apr 2026 15:17:09 +0530

amit – 2 file(s) modified
Revert rerenderCNs CLI option - downloadCN already re-renders on the fly

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36187 – Add --rerenderCNs CLI option to re-generate old CN PDFs with ...

amit — Sat, 04 Apr 2026 14:35:44 +0530

amit – 2 file(s) modified
Add --rerenderCNs CLI option to re-generate old CN PDFs with new format

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36046 – Clean up DC regeneration: revert to saveInvoice, remove debug logging

amit — Mon, 23 Mar 2026 18:58:35 +0530

amit – 1 file(s) modified
Clean up DC regeneration: revert to saveInvoice, remove debug logging

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36043 – Debug DC invoice regeneration: bypass saveInvoice, log title, print stack ...

amit — Mon, 23 Mar 2026 18:36:57 +0530

amit – 1 file(s) modified
Debug DC invoice regeneration: bypass saveInvoice, log title, print stack trace on failure

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36042 – Fix app config

amit — Mon, 23 Mar 2026 18:04:02 +0530

amit – 1 file(s) modified
Fix app config

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36039 – Add one-off task to regenerate 7 DC invoices for seller ...

amit — Mon, 23 Mar 2026 16:38:47 +0530

amit – 1 file(s) modified
Add one-off task to regenerate 7 DC invoices for seller 13 with correct Delivery Challan title

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 36034 – Removed cron optimized logic for smartdukaan

amit — Mon, 23 Mar 2026 13:47:28 +0530

amit – 1 file(s) modified
Removed cron optimized logic for smartdukaan

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35959 – Migrate SMTP calls to mailOutboxService in cron - mail outbox ...

amit — Sat, 07 Mar 2026 12:51:07 +0530

amit – 2 file(s) modified
Migrate SMTP calls to mailOutboxService in cron - mail outbox pattern

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ambreports/AbmReportSender.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35929 – Update Existing Shopify Product

vikas — Tue, 03 Mar 2026 01:30:05 +0530

vikas – 2 file(s) modified
Update Existing Shopify Product

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35928 – Update Existing Shopify Product

vikas — Tue, 03 Mar 2026 01:16:44 +0530

vikas – 2 file(s) modified
Update Existing Shopify Product

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifyProductSyncService.java

Rev 35915 – Notifications: use loan-level overdue/penalty rates instead of global constants

amit — Mon, 02 Mar 2026 12:45:10 +0530

amit – 1 file(s) modified
Notifications: use loan-level overdue/penalty rates instead of global constants

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35877 – Credit cron fixes: correct interest rates in notifications, show total+bifurcation ...

amit — Fri, 27 Feb 2026 18:43:58 +0530

amit – 1 file(s) modified
Credit cron fixes: correct interest rates in notifications, show total+bifurcation in messages, fix internal email text, filter limit blocks, limit WhatsApp to 2 per run, replace N+1 loan statement queries with loan fields, use selectAllBlockedLoans for fixBlockedCredit.

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35866 – Use Loan::isLimit instead of freeDays >= 365 in fixBlockedCredit

amit — Fri, 27 Feb 2026 13:06:44 +0530

amit – 1 file(s) modified
Use Loan::isLimit instead of freeDays >= 365 in fixBlockedCredit

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35848 – Refactor investment logic to use own investment (total - utilized), ...

amit — Wed, 25 Feb 2026 15:32:49 +0530

amit – 16 file(s) modified
Refactor investment logic to use own investment (total - utilized), remove minimumInvestmentOld, add OK_INVESTMENT_SHORT_PERCENTAGE constant, update thresholds CUTOFF_INVESTMENT=10 MIN_INVESTMENT_PERCENTAGE=5

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/InvestmentRelatedTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/CurrentPartnerDailyInvestment.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/FofoStore.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/PartnerDailyInvestment.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/SchemeRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/FofoUser.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerStatsServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PerformanceController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/SchemeController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/SDCreditController.java

Rev 35811 – Centralize credit/loan summary: CreditSummary DTO, bulk query, fix stale utilization, ...

amit — Fri, 20 Feb 2026 22:53:12 +0530

amit – 16 file(s) modified
Centralize credit/loan summary: CreditSummary DTO, bulk query, fix stale utilization, re-enable overdue check, fix interestPaid bug, optimize fresh money (3 queries vs 21), remove dead code

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/BulkCreditSummary.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/CreditSummary.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/LoanRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/LoanRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/UserWalletHistoryRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/UserWalletHistoryRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PartnerPendingTasksController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/SDCreditController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/WalletController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/GatewayController.java

Rev 35803 – Support WebApplicationType.NONE for non-web cron runs, add sendCreditNote log line

amit — Thu, 19 Feb 2026 19:49:00 +0530

amit – 2 file(s) modified
Support WebApplicationType.NONE for non-web cron runs, add sendCreditNote log line

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35788 – Schedule Shopify Product Sync

vikas — Wed, 18 Feb 2026 17:44:37 +0530

vikas – 7 file(s) modified
Schedule Shopify Product Sync

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/InsurancePlanFetcher.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifyProductMapper.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifyProductSyncService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/shopify/ShopifySyncResultModel.java

Rev 35666 – Fetch PineLabs Offers Daily by Items

vikas — Fri, 06 Feb 2026 15:51:48 +0530

vikas – 2 file(s) modified
Fetch PineLabs Offers Daily by Items

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35591 – Fix:Remove Account team from default partner and partner credit report ...

aman — Tue, 27 Jan 2026 13:01:45 +0530

aman – 1 file(s) modified
Fix:Remove Account team from default partner and partner credit report and only send to neeraj sir

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35568 – Refactor ticket scheduled tasks: fix bugs, add test mode, improve ...

amit — Sat, 17 Jan 2026 12:06:59 +0530

amit – 4 file(s) modified
Refactor ticket scheduled tasks: fix bugs, add test mode, improve performance

Bug fixes:
- Remove break statement in alertforTicket that stopped after first user
- Remove duplicate ticketClosed() method (used 7 calendar days vs 8 working days)
- Update Application.java CLI handler to use refactored escalateTicket()

New features:
- Add email test mode: redirect all emails to tester via config
- ticket.email.testMode.enabled=true/false
- ticket.email.testMode.recipient=tester@email.com
- Add configurable auto-escalation: ticket.autoEscalation.enabled
- Working days calculation using WorkingDaysService (excludes Sun + holidays)

Performance improvements:
- Batch fetch ticketSubCategoryMap once per job, not per email
- All repository calls moved outside loops (N+1 query fix)

Escalation thresholds updated:
- L1 -> L2: 3 working days
- L2 -> L3: 3 working days
- L3 -> Final: 2 working days

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>

Rev 35531 – Add manual partner type upgrade detection in rolloutMarginForStoreOnMonth - ...

amit — Wed, 07 Jan 2026 10:15:29 +0530

amit – 1 file(s) modified
Add manual partner type upgrade detection in rolloutMarginForStoreOnMonth

- Check if there's a MANUAL partner type change on day 1 of the month
- If manual upgrade detected, proceed with margin rollout for all orders in that month
- Existing calculated upgrade logic remains unchanged

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35530 – Added migration for 2 parties for gold

amit — Wed, 07 Jan 2026 09:44:31 +0530

amit – 1 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35524 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 17:36:52 +0530

amit – 2 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35521 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 16:49:46 +0530

amit – 2 file(s) modified
Added migration for 2 parties for gold

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35461 – Fix LockAcquisitionException: Use bulk partner type fetch in ScheduledTasks ...

amit — Sun, 21 Dec 2025 03:22:46 +0530

amit – 1 file(s) modified
Fix LockAcquisitionException: Use bulk partner type fetch in ScheduledTasks

Use getTypesForFofoIds() bulk method in rollOutUpgardedMargins to avoid N+1 queries

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35447 – Fix N+1 query in refundDnAmount() - batch fetch TagListings

amit — Fri, 19 Dec 2025 20:01:24 +0530

amit – 1 file(s) modified
Fix N+1 query in refundDnAmount() - batch fetch TagListings

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35446 – Use selectAllByItems() to avoid duplicate item fetch in checkfocusedModelInPartnerStock ...

amit — Fri, 19 Dec 2025 19:46:14 +0530

amit – 1 file(s) modified
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

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35442 – Optimize checkfocusedModelInPartnerStock() - fix N+1 queries with batch fetching ...

amit — Fri, 19 Dec 2025 19:19:59 +0530

amit – 1 file(s) modified
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

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java

Rev 35424 – Fix order billing vs cancellation race condition with pessimistic locking ...

amit — Thu, 18 Dec 2025 19:12:51 +0530

amit – 5 file(s) modified
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

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/TransactionRelatedTasks.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/TransactionServiceImpl.java

Rev 35393 – Fixed MongoDB close method

amit — Wed, 17 Dec 2025 01:33:43 +0530

amit – 4 file(s) modified
Fixed MongoDB close method

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/config/DBConfig.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/TicketRelatedScheduledTask.java

Rev 35330 – Fixed loan issue

amit — Thu, 27 Nov 2025 20:20:39 +0530

amit – 1 file(s) modified
Fixed loan issue

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java