SmartDukaan – /trunk/profitmandi-cron/

Rev 35598 – Migrate from C3P0 to HikariCP connection pooling - Replace ...

amit — Tue, 27 Jan 2026 21:31:28 +0530

amit – 5 file(s) modified
Migrate from C3P0 to HikariCP connection pooling

- Replace C3P0 properties with HikariCP settings
- New settings: maximumPoolSize=20, minimumIdle=2, idleTimeout=30s, maxLifetime=30min

~ /trunk/profitmandi-cron/src/main/resources/META-INF/dev.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/env.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/prod.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/run.properties
~ /trunk/profitmandi-cron/src/main/resources/META-INF/staging.properties

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 35586 – Fix: Set HikariCP autoCommit=false to enable Hibernate dirty checking for ...

amit — Thu, 22 Jan 2026 22:34:43 +0530

amit – 1 file(s) modified
Fix: Set HikariCP autoCommit=false to enable Hibernate dirty checking for transaction management

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/config/DBConfig.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>

~ /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-cron/src/main/java/com/smartdukaan/cron/scheduled/TicketRelatedScheduledTask.java

Rev 35547 – Real-time Solr updates for TagListing changes - Add Spring ...

amit — Wed, 14 Jan 2026 16:05:06 +0530

amit – 23 file(s) modified
Real-time Solr updates for TagListing changes

- Add Spring ApplicationEvent for TagListing changes (price, status, create, delete)
- Add async listener for incremental Solr updates (updateSingleCatalog)
- Add failure tracking with solr_update_failures table for visibility
- Add admin dashboard API for tech team to retry failed updates
- Add auto-retry job every 5 minutes (max 3 retries)
- Add startup sync for consistency after restart
- Add isProd check to skip Solr updates in local/dev environment
- Inject event publisher in TagListing, PriceDrop, Indent controllers

+ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/SolrRetryJob.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/AsyncConfig.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/TagListing.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/solr
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/solr/SolrUpdateFailure.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/SolrStartupSync.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingChangedEvent.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingChangeListener.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/event/TagListingEventPublisher.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/TagListingRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr/SolrUpdateFailureRepository.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/solr/SolrUpdateFailureRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/solr/FofoSolr.java
+ /trunk/profitmandi-dao/src/main/resources/sql
+ /trunk/profitmandi-dao/src/main/resources/sql/solr_update_failures.sql
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/admin
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/admin/SolrFailureController.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/PriceDropController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/TagListingController.java

Rev 35532 – Added migration for 2 parties for gold

amit — Wed, 07 Jan 2026 10:26:16 +0530

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

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

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 35522 – Added migration for 2 parties for gold

amit — Tue, 06 Jan 2026 16:51:59 +0530

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

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledSkeleton.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 35520 – Fixed method Number to comma for Cr. Values

amit — Tue, 06 Jan 2026 16:36:33 +0530

amit – 1 file(s) modified
Fixed method Number to comma for Cr. Values

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.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 35361 – Feat:Trial user mails for pending Verification and store code

aman — Tue, 09 Dec 2025 18:48:49 +0530

aman – 1 file(s) modified
Feat:Trial user mails for pending Verification and store code

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

Rev 35358 – eol item remove from listing b2b (solr)

ranu — Tue, 09 Dec 2025 13:40:26 +0530

ranu – 2 file(s) modified
eol item remove from listing b2b (solr)

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasksTest.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/solr/FofoSolr.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

Rev 35329 – fix openinng stock

ranu — Thu, 27 Nov 2025 01:35:03 +0530

ranu – 4 file(s) modified
fix openinng stock

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/CurrentInventorySnapshot.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/CurrentInventorySnapshotRepositoryImpl.java

Rev 35326 – Fixed Schedule Tasks

amit — Wed, 26 Nov 2025 18:41:56 +0530

amit – 2 file(s) modified
Fixed Schedule Tasks

~ /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 35299 – Fixed Scheduled Task Logic

amit — Wed, 19 Nov 2025 18:20:53 +0530

amit – 2 file(s) modified
Fixed Scheduled Task Logic

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

Rev 35295 – Added reset logic

amit — Mon, 17 Nov 2025 14:45:45 +0530

amit – 3 file(s) modified
Added reset logic

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.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

Rev 35277 – Migrations

amit — Wed, 12 Nov 2025 17:38:23 +0530

amit – 1 file(s) modified
Migrations

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

Rev 35276 – Migrations

amit — Wed, 12 Nov 2025 17:14:55 +0530

amit – 1 file(s) modified
Migrations

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

Rev 35267 – without invoice cancel request

ranu — Mon, 10 Nov 2025 16:25:16 +0530

ranu – 2 file(s) modified
without invoice cancel request

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

Rev 35266 – without invoice cancel request

ranu — Mon, 10 Nov 2025 16:17:49 +0530

ranu – 2 file(s) modified
without invoice cancel request

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/Application.java
~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

Rev 35265 – Migrations

amit — Mon, 10 Nov 2025 16:08:18 +0530

amit – 1 file(s) modified
Migrations

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

Rev 35250 – Migrations

amit — Fri, 31 Oct 2025 18:16:31 +0530

amit – 2 file(s) modified
Migrations

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

Rev 35239 – bi report exception

ranu — Tue, 28 Oct 2025 13:44:30 +0530

ranu – 1 file(s) modified
bi report exception

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

Rev 35238 – bi report exception

ranu — Tue, 28 Oct 2025 13:39:51 +0530

ranu – 1 file(s) modified
bi report exception

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

Rev 35237 – bi report exception

ranu — Tue, 28 Oct 2025 13:22:53 +0530

ranu – 1 file(s) modified
bi report exception

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

Rev 35179 – Added SD Credit Scheduler

amit — Sun, 12 Oct 2025 19:01:13 +0530

amit – 1 file(s) modified
Added SD Credit Scheduler

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

Rev 35178 – Added SD Credit Scheduler

amit — Sun, 12 Oct 2025 18:59:17 +0530

amit – 1 file(s) modified
Added SD Credit Scheduler

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

Rev 35177 – Added SD Credit Scheduler

amit — Sun, 12 Oct 2025 18:55:25 +0530

amit – 4 file(s) modified
Added SD Credit Scheduler

~ /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/service/transaction/scheduled
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/scheduled/SDCreditScheduler.java

Rev 35165 – Fixed system.exit(0)

amit — Thu, 09 Oct 2025 15:59:38 +0530

amit – 2 file(s) modified
Fixed system.exit(0)

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

Rev 35161 – Fixed SD Credit HardLimit Check

amit — Thu, 09 Oct 2025 13:43:05 +0530

amit – 1 file(s) modified
Fixed SD Credit HardLimit Check

~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/migrations/RunOnceTasks.java

Rev 35160 – Fixed SD Credit HardLimit Check

amit — Thu, 09 Oct 2025 13:41:25 +0530

amit – 1 file(s) modified
Fixed SD Credit HardLimit Check

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