SmartDukaan – /

Rev 37940 – feat(credit): consolidated Loan Default mail to Tarun Verma and Kamini ...

amit — Thu, 22 Oct 2026 19:24:04 +0530

amit – 2 file(s) modified
feat(credit): consolidated Loan Default mail to Tarun Verma and Kamini Sharma

- cron (blockDefaultedPartners): when it newly blocks partners, one mail listing them (partner, code, default pending, loans, oldest days, RBM L1, since) plus the total still on Loan Default
- --sendLoanDefaultBlockMails catch-up: one mail with the full current Loan Default list
- a mail failure never fails the cron
- RBM names built from first/last name without 'null' when one is missing
- a loan default only blocks SD Credit and never changes store status

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/SDCreditServiceImpl.java
~ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/transaction/SDCreditServiceLoanDefaultTest.java

Rev 37939 – Scheme and offer payouts skip SUSPENDED and CLOSED stores ...

amit — Thu, 22 Oct 2026 19:04:25 +0530

amit – 2 file(s) modified
Scheme and offer payouts skip SUSPENDED and CLOSED stores

- Activation special support (processActivation): payouts of suspended or closed stores stay pending,
paid only if the store is revived
- Offer rollout and payout preview (activation/tertiary and sell-in): suspended and closed stores are
dropped by store status, whatever the partner criteria

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/OfferServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/scheme/SchemeServiceImpl.java

Rev 37938 – Store status lifecycle: temporary activation expiry and weekly closure reminder ...

amit — Thu, 22 Oct 2026 18:08:10 +0530

amit – 3 file(s) modified
Store status lifecycle: temporary activation expiry and weekly closure reminder

- checkPartnerActiveStore returns expired temporary activations to their previous status
(the old job failed with a NullPointerException on permanently active stores)
- Mondays 09:00: stores suspended for more than 7 days mailed to Neeraj with the other closers in CC

~ /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

Rev 37937 – Store status lifecycle: web login, wallet guard and V2 endpoints ...

amit — Thu, 22 Oct 2026 18:08:08 +0530

amit – 6 file(s) modified
Store status lifecycle: web login, wallet guard and V2 endpoints

- Partner login and token detail refuse a SUSPENDED or CLOSED store (STORE_LOGIN_BLOCKED) with the reason;
token detail returns storeStatus
- PAUSED blocks partner wallet spends at checkout, insurance and clearance bid
- V2 retailer endpoints mirror the fofo ones through StoreStatusService

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/checkout/OrderController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/InsuranceController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/StoreController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/UserController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/fofo/V2FofoRetailerController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/V2InsuranceController.java

Rev 37936 – Store status lifecycle: fofo store pages and endpoints - ...

amit — Thu, 22 Oct 2026 18:08:06 +0530

amit – 6 file(s) modified
Store status lifecycle: fofo store pages and endpoints

- Pause / un-pause / suspend endpoints with a mandatory reason, status history; activate, temporary
activate and close go through StoreStatusService
- Active stores page lists ACTIVE + PAUSED with status badges; inactive page lists SUSPENDED + CLOSED;
buttons shown by the viewer's permissions
- LOI revival: a SUSPENDED store comes back on the same code; a CLOSED store gets a new code at store
creation (no longer reopened)
- JS version 447

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LoiFormController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/RetailerController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/retailer.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/inactive-stores.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/store-investment.vm

Rev 37935 – Store status lifecycle: ACTIVE / PAUSED / SUSPENDED / CLOSED ...

amit — Thu, 22 Oct 2026 18:07:55 +0530

amit – 24 file(s) modified
Store status lifecycle: ACTIVE / PAUSED / SUSPENDED / CLOSED with a status log

- fofo_store.store_status is the source of truth; active / closed are written in step for old readers
- StoreStatusService is the only writer: transition rules, permissions (pause: Tarun, Kamini, Sales L5+
for their partners; suspend / activate / temp: Tarun, Kamini, Neeraj, Accounts L4+; close: Tarun,
Kamini, Accounts L3+), mandatory reason, fofo.store_status_log row, status-change mail
- Closure only from SUSPENDED with a zero wallet and no open loan (limit blocks included)
- Revival: SUSPENDED comes back on the same store, CLOSED gets a new store; both kept in fofo.store_revival
- PAUSED blocks partner wallet spends (recharge, prebooking, insurance at sale)
- Temporary activation expiry and the weekly closure reminder
- selectInActiveStore renamed selectInactiveStores (SUSPENDED + CLOSED, uncached)

~ /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/StoreRevival.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/StoreStatusLog.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/fofo/StoreRevivalType.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/fofo/StoreStatus.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/fofo/StoreStatusAction.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/fofo/StoreStatusSource.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/CsServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/FofoStoreRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/FofoStoreRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/StoreRevivalRepository.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/StoreRevivalRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/StoreStatusLogRepository.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/StoreStatusLogRepositoryImpl.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/service/integrations/zest/InsuranceServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/inventory/PrebookingServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/recharge/RechargeServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/RetailerService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/RetailerServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/StoreAccess.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/StoreClosureService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/StoreStatusService.java

Rev 37934 – feat(catalog): brand identifier mandatory on item upload for flagged brands' ...

amit — Thu, 22 Oct 2026 15:18:39 +0530

amit – 2 file(s) modified
feat(catalog): brand identifier mandatory on item upload for flagged brands' smartphones

- catalog.brand_category.brand_identifier_required (mobile rows, category_id 3) maps to BrandCategory.brandIdentifierRequired
- ItemLoaderService rejects a category 10006 row with smartphone HSN (Item.SMART_PG) and blank Brand Identifier
when the brand's flag is set; feature phones (85171400), vendors 500/515 and Any Colour rows are exempt
- DDL + flags already applied on hadb1 2026-10-22: Samsung, Vivo, Oppo, Realme, Xiaomi, POCO, Motorola, Tecno

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/BrandCategory.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/ItemLoaderService.java

Rev 37933 – feat(credit): --sendLoanDefaultBlockMails one-shot catch-up mail for current loan-default blocks (needs ...

amit — Thu, 22 Oct 2026 15:00:13 +0530

amit – 2 file(s) modified
feat(credit): --sendLoanDefaultBlockMails one-shot catch-up mail for current loan-default blocks (needs dao r37930)

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

Rev 37932 – feat(credit): gateway status returns partner-safe statusDescription when SD Credit is ...

amit — Thu, 22 Oct 2026 15:00:12 +0530

amit – 1 file(s) modified
feat(credit): gateway status returns partner-safe statusDescription when SD Credit is inactive (needs dao r37930)

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/GatewayController.java

Rev 37931 – feat(credit): show partner-safe SD Credit inactive message on partner Wallet ...

amit — Thu, 22 Oct 2026 15:00:11 +0530

amit – 2 file(s) modified
feat(credit): show partner-safe SD Credit inactive message on partner Wallet page (needs dao r37930)

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/WalletController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/wallet-details.vm

Rev 37930 – feat(credit): mail Sales/RBM on every credit block/unblock; partner-safe inactive message ...

amit — Thu, 22 Oct 2026 15:00:04 +0530

amit – 4 file(s) modified
feat(credit): mail Sales/RBM on every credit block/unblock; partner-safe inactive message

- every credit_block_log entry (manual, cron 'system', gateway activation) mails the partner's active Sales L1+L2 and RBM L1 via mail_outbox: partner, status, reason, done by, time
- a mail failure never fails the block/unblock
- sendLoanDefaultBlockMails(): one-time catch-up mail for accounts already LOAN_DEFAULT
- getPartnerInactiveMessage(): loan default -> 'on hold due to payments overdue beyond 30 days', others generic; internal typed reason never exposed
- sddirect/summary (SDCreditResponseOut) now carries statusDescription when inactive

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/SDCreditResponseOut.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-dao/src/test/java/com/spice/profitmandi/service/transaction/SDCreditServiceLoanDefaultTest.java

Rev 37929 – chore(fofo): bump jsVersion to 446 for partner-credit-detail.js (r37927)

amit — Thu, 22 Oct 2026 12:42:58 +0530

amit – 1 file(s) modified
chore(fofo): bump jsVersion to 446 for partner-credit-detail.js (r37927)

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java

Rev 37928 – feat(credit): run loan-default credit block in notifyDefaultLoans cron (needs dao ...

amit — Thu, 22 Oct 2026 12:42:44 +0530

amit – 1 file(s) modified
feat(credit): run loan-default credit block in notifyDefaultLoans cron (needs dao r37926)

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

Rev 37927 – feat(credit): show active/inactive reason + logs popup; CEO-only reactivation of ...

amit — Thu, 22 Oct 2026 12:42:43 +0530

amit – 6 file(s) modified
feat(credit): show active/inactive reason + logs popup; CEO-only reactivation of loan default

- Partners Credit Detail: Active Status column (Active / Inactive - Awaiting Activation | Loan Default | Blocked) with Logs popup (reason + who)
- unblock and gateway Activate now require a reason; switchCreditGateway goes through the loan-default guard
- new sanctioned account starts as AWAITING_ACTIVATION
- needs dao r37926

~ /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-fofo/src/main/webapp/resources/js/partner-credit-detail.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/credit-block-logs.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-credit-detail-row.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-credit-detail.vm

Rev 37926 – feat(credit): deactivate credit on loan default; only the CEO can ...

amit — Thu, 22 Oct 2026 12:42:35 +0530

amit – 5 file(s) modified
feat(credit): deactivate credit on loan default; only the CEO can reactivate

- credit_account.inactive_reason: AWAITING_ACTIVATION / LOAN_DEFAULT / BLOCKED (internal only)
- blockDefaultedPartners(): defaulted loans (unpaid past 30 days) totalling >= Rs.25,000 -> inactive LOAN_DEFAULT, logged as 'system'
- repayment never reactivates; LOAN_DEFAULT can only be reactivated by tarun.verma (guard in activateCredit)
- a CEO reactivation covers existing defaults; a later default blocks again
- reason now mandatory on unblock/activate; updateRisk high-risk deactivation now records BLOCKED + log
- DDL: claude-data/sql-migrations/2026-10-22_credit_account_inactive_reason.sql (applied on hadb1)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/dtr/CreditAccount.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/dtr/CreditInactiveReason.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-dao/src/test/java/com/spice/profitmandi/service/transaction/SDCreditServiceLoanDefaultTest.java

Rev 37925 – fix(cron): stop subtracting a year from Realme activation date ...

amit — Thu, 22 Oct 2026 11:48:14 +0530

amit – 1 file(s) modified
fix(cron): stop subtracting a year from Realme activation date

Realme's expiryDate is the activation date (the phonecheck page shows it as
"Activation Date"). Since r37423 the job subtracted a year, storing every
cron-written Realme activation one year early.

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

Rev 37924 – Login Usertype Tracker

vikas — Wed, 21 Oct 2026 16:50:55 +0530

vikas – 2 file(s) modified
Login Usertype Tracker

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LoginController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/mobileapp.vm

Rev 37923 – feat: add Catalog_Id and HSN_Code columns to warehouse purchase invoices ...

amit — Wed, 21 Oct 2026 12:52:36 +0530

amit – 2 file(s) modified
feat: add Catalog_Id and HSN_Code columns to warehouse purchase invoices report

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/warehouse/WarehouseSupplierInvoice.java

Rev 37922 – feat: add catalog id and HSN code to PurchaseInvoiceModel

amit — Wed, 21 Oct 2026 12:52:35 +0530

amit – 1 file(s) modified
feat: add catalog id and HSN code to PurchaseInvoiceModel

~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/PurchaseInvoiceModel.java

Rev 37921 – loi bugs fixed

ranu — Mon, 19 Oct 2026 19:04:06 +0530

ranu – 2 file(s) modified
loi bugs fixed

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/loiForm/LoiFormServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LoiFormController.java

Rev 37920 – loi form submission

ranu — Mon, 19 Oct 2026 18:24:52 +0530

ranu – 1 file(s) modified
loi form submission

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/loiForm/LoiFormServiceImpl.java

Rev 37919 – commi tfile for offer radar send to all related department

ranu — Mon, 19 Oct 2026 18:02:51 +0530

ranu – 1 file(s) modified
commi tfile for offer radar send to all related department

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LoiFormController.java

Rev 37918 – Fixed mail sender everywhere

amit — Mon, 19 Oct 2026 17:53:58 +0530

amit – 1 file(s) modified
Fixed mail sender everywhere

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

Rev 37917 – commi tfile for offer radar send to all related department

ranu — Mon, 19 Oct 2026 13:48:11 +0530

ranu – 1 file(s) modified
commi tfile for offer radar send to all related department

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/onboarding/LoiAuditTrailRepositoryImpl.java

Rev 37916 – commi tfile for offer radar send to all related department

ranu — Mon, 19 Oct 2026 13:34:28 +0530

ranu – 1 file(s) modified
commi tfile for offer radar send to all related department

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/loiForm/LoiFormServiceImpl.java

Rev 37915 – fix(dao): add Lead.getDisplayLabel() required by fofo r37906 r37906 (BeatJourneyController, ...

amit — Mon, 19 Oct 2026 12:16:11 +0530

amit – 1 file(s) modified
fix(dao): add Lead.getDisplayLabel() required by fofo r37906

r37906 (BeatJourneyController, "Corrected PJP Data") calls
lead.getDisplayLabel() but the dao side was never committed, so fofo trunk
did not compile. Returns "Outlet (Contact)" per that commit's comment, the
single part if only one exists, or null so beat-journey.vm falls back to the
task name. @JsonIgnore keeps existing Lead JSON responses unchanged.
Reconstructed while the author is on leave.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/user/Lead.java

Rev 37914 – fix(web): todayOffers returns empty list when request has no user ...

amit — Mon, 19 Oct 2026 08:45:46 +0530

amit – 1 file(s) modified
fix(web): todayOffers returns empty list when request has no user token

userInfo is only set by AuthenticationInterceptor for a real JWT; requests
with no Auth-Token or a static token NPE'd. Treat them as no store.

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/TodayOfferController.java

Rev 37913 – fix(security): fofo /login no longer trusts a request email when ...

amit — Mon, 19 Oct 2026 08:45:45 +0530

amit – 2 file(s) modified
fix(security): fofo /login no longer trusts a request email when Google verification fails

LoginController.login fell back to emailId = emailIdOrMobileNumber whenever
googleTokenUtil.getEmailId(token) threw, so any bogus token plus any email
logged the caller in as that user. Verification failure now fails the login.
GoogleTokenUtil also requires tokeninfo aud == google.api.key (our web client
id, same value the login page uses) and email_verified == true.
Password login is unchanged.

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LoginController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/util/GoogleTokenUtil.java

Rev 37912 – docs(external-api): document color on SKU records

amit — Mon, 19 Oct 2026 08:45:09 +0530

amit – 1 file(s) modified
docs(external-api): document color on SKU records

~ /trunk/profitmandi-web/src/main/resources/external-api-docs.html

Rev 37911 – feat(external-api): restore color on SKU feeds Re-adds color to ...

amit — Mon, 19 Oct 2026 08:45:08 +0530

amit – 4 file(s) modified
feat(external-api): restore color on SKU feeds

Re-adds color to skuMaster, stock, catalogSkuMaster and catalogSkus
(reverses the r37295 removal). Value is catalog.item.color with the
legacy f_ prefix and surrounding spaces stripped; blank becomes null.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/external/CatalogSkuModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/external/StoreSkuModel.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/external/ExternalFeedRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/external/ExternalApiServiceImpl.java

Rev 37910 – fix(offers): use TxStartTrackingTransactionManager so cron reads respect the offer cache ...

amit — Mon, 19 Oct 2026 08:39:38 +0530

amit – 1 file(s) modified
fix(offers): use TxStartTrackingTransactionManager so cron reads respect the offer cache gate (dao r37907)

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

Rev 37909 – fix(offers): use TxStartTrackingTransactionManager; drop controller-side offer evictions (dao r37907)

amit — Mon, 19 Oct 2026 08:39:37 +0530

amit – 2 file(s) modified
fix(offers): use TxStartTrackingTransactionManager; drop controller-side offer evictions (dao r37907)

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/dao/config/WebDBContextConfigure.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/fofo/V2FofoOfferController.java

Rev 37908 – fix(offers): use TxStartTrackingTransactionManager; offer cache eviction moves into the service ...

amit — Mon, 19 Oct 2026 08:39:36 +0530

amit – 2 file(s) modified
fix(offers): use TxStartTrackingTransactionManager; offer cache eviction moves into the service (dao r37907)

Activate/publishAll no longer evict in the controller; Refresh Cache also clears per-offer caches.

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/dao/config/WebDBContextConfigure.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferController.java

Rev 37907 – fix(offers): stop stale offer rows being re-cached after an offer ...

amit — Mon, 19 Oct 2026 08:38:47 +0530

amit – 5 file(s) modified
fix(offers): stop stale offer rows being re-cached after an offer change

Readers whose transaction began before an offer write committed could cache
the old row (e.g. offer 10851 shown inactive on Offer History for 6h).
- OfferCacheGate: offer caches refuse fills from readers whose transaction
began before the last offer change (atomic Lua check-and-set)
- TxStartTrackingTransactionManager records each transaction's start time
- offer cache evictions run after the transaction completes, marking the change first
- activate/publishAll evict inside their REQUIRES_NEW transaction
- evictAllOfferCaches(YearMonth) for Refresh Cache; offer cache TTL 6h -> 1h

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/CacheConfig.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/OfferCacheGate.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/config/TxStartTrackingTransactionManager.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/OfferService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/offers/OfferServiceImpl.java

Rev 37906 – Corrected PJP Data

vikas — Fri, 16 Oct 2026 16:27:06 +0530

vikas – 2 file(s) modified
Corrected PJP Data

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/BeatJourneyController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/beat-journey.vm

Rev 37905 – commi tfile for offer radar send to all related department

ranu — Fri, 16 Oct 2026 15:03:03 +0530

ranu – 8 file(s) modified
commi tfile for offer radar send to all related department

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PoStockApprovalDigestServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/warehouse/PoStockApprovalServiceImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OfferRadarNotificationController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/emi-catalog-detail.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/emi-catalog-popup.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/warehouse-po-stock-approval-detail.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/warehouse-po-stock-approvals.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/warehouse-purchase-order-add-item.vm

Rev 37904 – fix(catalog): delist job treats an activated IMEI as sold ...

amit — Fri, 16 Oct 2026 13:03:49 +0530

amit – 2 file(s) modified
fix(catalog): delist job treats an activated IMEI as sold

- partner-stock guard in CatalogDelistServiceImpl ignores a unit whose IMEI is in
fofo.activated_imei with activation on/after the partner received it, even if
the partner never billed it (item 30834: 6 Vivo Y91i units at UPHRD130,
activated 2021, kept the listing alive)
- units activated before receipt (returns/demo) and non-serialized stock still count
- delist_inactive_listings_rolling_24m.sql mirrored

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/CatalogDelistServiceImpl.java
~ /trunk/profitmandi-dao/src/main/resources/sql/delist_inactive_listings_rolling_24m.sql

Rev 37903 – commi tfile for pine lab scrping emi plans

ranu — Fri, 16 Oct 2026 12:24:28 +0530

ranu – 3 file(s) modified
commi tfile for pine lab scrping emi plans

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/EmiCatalogController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/EmiCatalogImportService.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/emi-catalog.vm

Rev 37902 – pinelab emi offer publish

ranu — Fri, 16 Oct 2026 12:23:57 +0530

ranu – 2 file(s) modified
pinelab emi offer publish

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/EmiProductRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/EmiProductRepositoryImpl.java

Rev 37901 – pinelab emi offer publish

ranu — Thu, 15 Oct 2026 17:22:09 +0530

ranu – 1 file(s) modified
pinelab emi offer publish

+ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/services/EmiCatalogEnrichmentService.java