SmartDukaan – /

Rev 38040 – fix(wod): add Store.line1/Store.line2 prefill sources Line-type fields (e.g. Address ...

amit — Sat, 14 Nov 2026 11:41:23 +0530

amit – 2 file(s) modified
fix(wod): add Store.line1/Store.line2 prefill sources

Line-type fields (e.g. Address Line 1) got the full store address. Add line sources from the same store
address (default address, else LOI billing address) and drop the PartnerOnBoardingPanel.address alias:
all templates were migrated to Store.address on 2026-11-14.

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/FinServiceController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/fin-service/wod-template-edit.vm

Rev 38039 – Phase 1 partner-app tracking: /mobileapp opens partner apps via PartnerAppLauncher ...

amit — Sat, 14 Nov 2026 11:33:57 +0530

amit – 1 file(s) modified
Phase 1 partner-app tracking: /mobileapp opens partner apps via PartnerAppLauncher (staff recorded in token + user_action_audit) instead of web /user/admin

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

Rev 38038 – Phase 1 partner-app tracking: PartnerAppLauncher (store check, access check, launch ...

amit — Sat, 14 Nov 2026 11:33:32 +0530

amit – 6 file(s) modified
Phase 1 partner-app tracking: PartnerAppLauncher (store check, access check, launch audit, token) + PartnerAccessService; JWTUtil.createLaunchToken (partner token + staff claims, 12h)

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/authentication/JWTUtil.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/partnerapp
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/partnerapp/PartnerAccessService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/partnerapp/PartnerAppLauncher.java
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/partnerapp
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/partnerapp/PartnerAppLauncherTest.java

Rev 38037 – Phase 1 partner-app tracking: RequestClientInfo reads client IP (X-Real-IP first) ...

amit — Sat, 14 Nov 2026 11:33:14 +0530

amit – 4 file(s) modified
Phase 1 partner-app tracking: RequestClientInfo reads client IP (X-Real-IP first) and user agent into ClientInfo

+ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/web/util/RequestClientInfo.java
+ /trunk/profitmandi-common/src/test/java/com/spice/profitmandi/common/web
+ /trunk/profitmandi-common/src/test/java/com/spice/profitmandi/common/web/util
+ /trunk/profitmandi-common/src/test/java/com/spice/profitmandi/common/web/util/RequestClientInfoTest.java

Rev 38036 – /app/update: offer the APK only to older builds The ...

amit — Sat, 14 Nov 2026 11:16:13 +0530

amit – 1 file(s) modified
/app/update: offer the APK only to older builds

The check was version == B2B_APP_VERSION (101), so every newer shell (the current build is 122)
was told an update is available, and Classic's "Update App" would download an older APK.
Now updateAvailable = version < B2B_APP_VERSION. /v2/app/update delegates here.

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

Rev 38035 – fix(wod): drop PartnerOnBoardingPanel.address use in dormant V2 WOD controller

amit — Sat, 14 Nov 2026 11:00:25 +0530

amit – 1 file(s) modified
fix(wod): drop PartnerOnBoardingPanel.address use in dormant V2 WOD controller

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

Rev 38034 – fix(wod): prefill one store address; add full-name source - ...

amit — Sat, 14 Nov 2026 11:00:24 +0530

amit – 3 file(s) modified
fix(wod): prefill one store address; add full-name source

- Address fields use the partner's default address (user.user.default_address_id) instead of the newest
user.address row (differed for 379 active stores); LOI billing address as fallback.
- Address text no longer repeats city/state already present in line 2.
- New prefill sources Store.address and LoiForm.fullName (first + last); PartnerOnBoardingPanel.address
kept as an alias until templates are migrated.
- Stop writing partner_onboarding_panel.address from the edit and design-TAT saves (payloads never sent it).

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/FinServiceController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/PartnerOnBoardingPanelController.java
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/fin-service/wod-template-edit.vm

Rev 38033 – fix(onboarding): remove unused PartnerOnBoardingPanel.address mapping Column never held data ...

amit — Sat, 14 Nov 2026 11:00:15 +0530

amit – 1 file(s) modified
fix(onboarding): remove unused PartnerOnBoardingPanel.address mapping

Column never held data (0 of 2,026 rows). Store address single source = user default address,
LOI billing address as fallback. Column drop: claude-data/sql-migrations/wod_store_address_single_source_20261114.sql
(run after deploy).

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/PartnerOnBoardingPanel.java

Rev 38032 – fix(onboarding): drop dead address field from panel request models ...

amit — Sat, 14 Nov 2026 11:00:14 +0530

amit – 2 file(s) modified
fix(onboarding): drop dead address field from panel request models

CreatePartnerOnBoardingPanel / CreatePartnerOnBoardingDesignTat carried an address no form ever sent;
the edit and design-TAT saves copied that null onto partner_onboarding_panel.address.

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

Rev 38031 – Phase 0 partner-app tracking: JWTUtil reads staff claims (authUserId/email/launchId) without ...

amit — Sat, 14 Nov 2026 10:45:59 +0530

amit – 13 file(s) modified
Phase 0 partner-app tracking: JWTUtil reads staff claims (authUserId/email/launchId) without impersonation flag; user_action_audit entity + ActionAuditService (no callers yet)

+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/user/UserActionAudit.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/audit
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/enumuration/audit/AuditAction.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/user/UserActionAuditRepository.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/user/UserActionAuditRepositoryImpl.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/audit
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/audit/ActionAuditService.java
+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/audit/ActionAuditWriter.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/authentication/JWTUtil.java
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/audit
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/audit/ActionAuditServiceTest.java
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/authentication
+ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/authentication/JWTUtilStaffClaimsTest.java

Rev 38030 – Phase 0 partner-app tracking: Actor/ClientInfo models, UserInfo.launchId, LAUNCH_ID claim constant ...

amit — Sat, 14 Nov 2026 10:45:44 +0530

amit – 6 file(s) modified
Phase 0 partner-app tracking: Actor/ClientInfo models, UserInfo.launchId, LAUNCH_ID claim constant (no callers yet)

+ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/Actor.java
+ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ClientInfo.java
~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/ProfitMandiConstants.java
~ /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/model/UserInfo.java
+ /trunk/profitmandi-common/src/test/java/com/spice/profitmandi/common/model
+ /trunk/profitmandi-common/src/test/java/com/spice/profitmandi/common/model/ActorClientInfoTest.java

Rev 38029 – fix(credit): Credit Details status filter emptied after revisiting the page; ...

amit — Fri, 13 Nov 2026 19:07:28 +0530

amit – 2 file(s) modified
fix(credit): Credit Details status filter emptied after revisiting the page; shorter cleared label

- The page fragment is re-injected on every visit and each load pushed another DataTables search function
bound to that load's table; stale copies AND-filtered rows away (e.g. 'Loan Default - cleared' showed nothing
for partners who repaid after an earlier visit). Remove the earlier copy before adding, and read the row from
the table being drawn (settings.aoData) instead of a captured instance.
- Green line now reads just 'Default cleared.'

~ /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 38028 – fix(credit): clearer Loan Default messaging on Credit Details - ...

amit — Fri, 13 Nov 2026 18:16:33 +0530

amit – 3 file(s) modified
fix(credit): clearer Loan Default messaging on Credit Details

- Block reason shown grey as history: 'Blocked <date> by <who>: <reason>'
- Loan Default with no defaulted dues shows green 'Default cleared. Can be unblocked.'
- Amber 'Also overdue: <amount> on N loan(s), becomes default on <date>' for loans past due but not yet defaulted
- Filter option renamed 'Loan Default - cleared'
Needs dao r38027.

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/WalletController.java
~ /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 38027 – feat(credit): overdue (not yet defaulted) dues for the Credit Details ...

amit — Fri, 13 Nov 2026 18:16:32 +0530

amit – 4 file(s) modified
feat(credit): overdue (not yet defaulted) dues for the Credit Details screen

- SDCreditService.getOverdueDuesByFofo: principal + interest on Loan.isOverdue loans, with the earliest default date
- LoanDefaultDues carries defaultsOn; dues calculation shared between defaulted and overdue loans
- Tests for overdue amount and default date

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/LoanDefaultDues.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/SDCreditServiceDefaultDuesTest.java

Rev 38026 – feat(credit): Credit Details status filter, block reason and default dues ...

amit — Fri, 13 Nov 2026 17:52:43 +0530

amit – 3 file(s) modified
feat(credit): Credit Details status filter, block reason and default dues

- Status filter on /getCreditDetail (Active, Loan Default, Loan Default - nothing due, Blocked, Awaiting Activation)
- Latest block reason under the inactive label
- LOAN_DEFAULT rows show in red the principal + interest needed to close defaulted loans; nothing when 0
- Row redraw after block/unblock/activate carries the same details
Needs dao r38025.

Rev 38025 – feat(credit): default dues and latest block reason for the Credit ...

amit — Fri, 13 Nov 2026 17:52:37 +0530

amit – 6 file(s) modified
feat(credit): default dues and latest block reason for the Credit Details screen

- SDCreditService.getDefaultDuesByFofo: principal + interest needed to close every defaulted loan
(same isDefault() set as the LOAN_DEFAULT block; total from loan_statement as settleLoan reads it)
- SDCreditService.getLatestBlockLogs + CreditBlockLogRepository.selectByFofoIds (bulk, typed HQL)
- LoanDefaultDues model; SDCreditServiceDefaultDuesTest

+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/LoanDefaultDues.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/CreditBlockLogRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/dtr/CreditBlockLogRepositoryImpl.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/SDCreditServiceDefaultDuesTest.java

Rev 38024 – fix(cart): drop delisted or missing items from cart in getCartValidation ...

amit — Fri, 13 Nov 2026 13:22:27 +0530

amit – 1 file(s) modified
fix(cart): drop delisted or missing items from cart in getCartValidation

A line whose item is missing or whose tag_listing is inactive (active=0) is now
removed from the cart and reported as a PRODUCT_UNAVAILABLE cart message, so
createOrder (which rejects on any cart message) no longer bills a delisted item.
Runs before the carry bag allowance so removed phones earn no free bags.
Stock and the 400 max-qty cap are unchanged.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/cart/CartServiceImpl.java

Rev 38023 – visit history given on brand wise placement page

ranu — Fri, 13 Nov 2026 13:08:27 +0530

ranu – 3 file(s) modified
visit history given on brand wise placement page

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/price-circular.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm

Rev 38022 – call history given on brand wise placement page

ranu — Thu, 12 Nov 2026 19:45:25 +0530

ranu – 1 file(s) modified
call history given on brand wise placement page

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

Rev 38021 – call history given on brand wise placement page

ranu — Thu, 12 Nov 2026 19:43:47 +0530

ranu – 5 file(s) modified
call history given on brand wise placement page

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/AgentCallLogRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/cs/AgentCallLogRepositoryImpl.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/IndentController.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/price-circular.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/partner-stock.vm

Rev 38020 – diwali offer live

ranu — Thu, 12 Nov 2026 15:30:20 +0530

ranu – 2 file(s) modified
diwali offer live

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/OnlineScratchCouponService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/ScratchService.java

Rev 38019 – diwali offer live

ranu — Wed, 11 Nov 2026 16:45:45 +0530

ranu – 2 file(s) modified
diwali offer live

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/OnlineScratchCouponService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/ScratchService.java

Rev 38018 – diwali online scratch offer, otp send to email

ranu — Sun, 08 Nov 2026 16:39:52 +0530

ranu – 2 file(s) modified
diwali online scratch offer, otp send to email

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/OnlineScratchCouponService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/ScratchService.java

Rev 38017 – Hide switched-off payment options in partner app (web v2) ...

amit — Sun, 08 Nov 2026 00:27:42 +0530

amit – 2 file(s) modified
Hide switched-off payment options in partner app (web v2)

/v2/fofo/getPartnerServices listed every payment option and created a PENDING
partner_service row for each one missing, so switched-off IDFC (21) kept coming
back after r38012/r38013. Use selectAllActive there and in /userProfile, matching
the fofo screens.

~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/fofo/V2FofoPaymentOptionController.java
~ /trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/v2/controller/fofo/V2FofoServiceConfigController.java

Rev 38016 – Hot Deals admin UI rework + Brand Identifier CSV upload ...

amit — Sat, 07 Nov 2026 19:32:19 +0530

amit – 8 file(s) modified
Hot Deals admin UI rework + Brand Identifier CSV upload (needs dao r38015)

Hot Deals (Catalog > Hot Deals):
- every Hot Deal model listed, incl. ones with no attributes saved; stat cards + Needs attention filter
- OEM brand dropdown (form + per row), pre-filled from model name, required on save
- row save keeps the OEM model mapping; Clear button; Updated By column

Content page: Brand Identifier CSV (itemId,brandIdentifier) -> catalog.item.brand_identifier
- POST /catalog/brandIdentifier/upload?apply= : preview (NEW/REPLACE/UNCHANGED/ERROR) then apply; replaces existing values
- all-or-nothing; rejects unknown/duplicate items, blank or >100 chars, Hot Deal and Any Colour items; max 5000 rows
- GET /catalog/brandIdentifier/template.csv

jsVersion 453

~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/AppConfig.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ContentController.java
~ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/HotDealController.java
+ /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/service/BrandIdentifierUploadService.java
~ /trunk/profitmandi-fofo/src/main/webapp/resources/js/hot-deals.js
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/content.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/hot-deals-table.vm
~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/hot-deals.vm

Rev 38015 – Hot Deals admin: list every Hot Deal model (incl. ones ...

amit — Sat, 07 Nov 2026 19:32:07 +0530

amit – 6 file(s) modified
Hot Deals admin: list every Hot Deal model (incl. ones with no attributes row), needs-attention filter + stats, and OEM brand set on save

- ModelHotDealRepository: list/count driven from Catalog (brand = Hot Deal) LEFT JOIN model_hot_deal; needsAttentionOnly = no row or NULL oem_brand; countStats()
- ModelHotDealService: saveAttributes takes oemBrand (requested > stored > suggested from catalog.model_name); must be a brand master name, never Hot Deal; stored in master spelling. Root cause of Ai+ models missing from the partner-app brand filter (NULL oem_brand -> no oem_brand_s in Solr)
- oemBrandNames(), suggestOemBrand(), stats()
- ModelHotDeal: transient suggestedOemBrand, isSaved()
- Tests: 18 passing

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/catalog/ModelHotDeal.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/ModelHotDealRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/catalog/ModelHotDealRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/ModelHotDealService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/catalog/ModelHotDealServiceImpl.java
~ /trunk/profitmandi-dao/src/test/java/com/spice/profitmandi/service/catalog/ModelHotDealServiceImplTest.java

Rev 38014 – diwali offer live

ranu — Fri, 06 Nov 2026 18:27:15 +0530

ranu – 1 file(s) modified
diwali offer live

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

Rev 38013 – fix(finance): list only active payment options on finance-service screens ...

amit — Fri, 06 Nov 2026 18:03:29 +0530

amit – 2 file(s) modified
fix(finance): list only active payment options on finance-service screens

Uses PaymentOptionRepository.selectAllActive() (dao) for the finance-services grids,
partner finance-services page, add-partner service/brand-service dropdowns and the
partner payment-option profile, so switched-off options (e.g. IDFC id 21) are hidden
and no partner_service rows are created for them. createService saves the new
option as active.

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

Rev 38012 – fix(finance): list only active payment options on finance-service screens ...

amit — Fri, 06 Nov 2026 18:03:22 +0530

amit – 4 file(s) modified
fix(finance): list only active payment options on finance-service screens

Finance-service setup, grids, add-brand dropdown, partner payment-option page and
paper-finance lists (LOI form, WOD mapping report) used selectAll(), ignoring
payment_option.active. Switched-off options kept showing, and every finance-services
page open created a PENDING partner_service row for them (IDFC id 21, inactive since
2022, had 1,786). New PaymentOptionRepository.selectAllActive(); selectAllPaperFinanceOption
is active-only. Name lookups for existing payments/invoices still use selectAll().
Services created from the UI are now saved active (were saved active=0).

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PaymentOptionRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PaymentOptionRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/order/PaymentOptionServiceImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/serviceConfig/ServiceConfigServiceImpl.java

Rev 38011 – fix(credit-note): margin CN dry run must not consume CN/DN numbers ...

amit — Fri, 06 Nov 2026 16:19:36 +0530

amit – 1 file(s) modified
fix(credit-note): margin CN dry run must not consume CN/DN numbers or lock sellerwarehouse

The 06:00-on-1st monthlyMarginsCnDryRun (dryRun=true) bumped cn_sequence / fofo_dn_sequence for
every document it would issue and committed them, so each live run started after a burned block:
every gap Jul-Nov 2026 equals that month's live margin CN count per prefix (e.g. CN-NSDL13802..13976
never issued for Oct). It also held the sellerwarehouse rows billing locks.

- issueMarginsCNForPartner marks its REQUIRES_NEW transaction rollback-only when !runActual.
- Dry run reads sellerwarehouse without FOR UPDATE; live keeps selectByPrefixForUpdate.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/CreditNoteServiceImpl.java

Rev 38010 – fix(onboarding): retire previous brand commitments when a revival LOI completes ...

amit — Fri, 06 Nov 2026 15:53:49 +0530

amit – 3 file(s) modified
fix(onboarding): retire previous brand commitments when a revival LOI completes

A revival LOI completes on the store's original onboarding panel and its brand
commitments are attached to that panel, but the original LOI's commitments stayed
attached too. The panel then had two rows per re-committed brand and kept dropped
brands as committed, which broke /partnerDealerSubmit (toMap duplicate key) and
selectBrandCommitmentByOnboardingIdAndBrand (NonUniqueResult), and showed wrong
brands on the WOD finance mapping report.

createPartnerOnboardingPanel now deactivates and detaches (onBoardingId=0) every
other commitment on the panel before attaching the revival LOI's rows; loiId keeps
them tied to their own LOI. Adds LoiBrandCommitmentRepository.selectAllByOnboardingId.
Existing data (PBFZK1322, PBSMS1240, HRMWT1158) fixed by separate SQL.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/onboarding/LoiBrandCommitmentRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/onboarding/LoiBrandCommitmentRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/loiForm/LoiFormServiceImpl.java

Rev 38009 – chore(cron): drop CLI flags for removed one-time margin CN/DN remediation ...

amit — Thu, 05 Nov 2026 15:44:39 +0530

amit – 2 file(s) modified
chore(cron): drop CLI flags for removed one-time margin CN/DN remediation

Removes --corrMarginCNs, --genDNs, --genDNsForCNs, --cancelMarginDnIrns, --regenMarginIrns and
their ScheduledTasks wrappers; the CreditNoteService methods behind them were deleted in dao.

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

Rev 38008 – diwali offer live

ranu — Thu, 05 Nov 2026 15:30:49 +0530

ranu – 1 file(s) modified
diwali offer live

~ /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/order-details.vm

Rev 38007 – diwali offer live

ranu — Thu, 05 Nov 2026 13:39:16 +0530

ranu – 1 file(s) modified
diwali offer live

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

Rev 38006 – diwali online scratch offer, otp send to email

ranu — Thu, 05 Nov 2026 13:39:00 +0530

ranu – 1 file(s) modified
diwali online scratch offer, otp send to email

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

Rev 38005 – fix(credit-note): commit monthly margin CN run per partner; drop one-time ...

amit — Wed, 04 Nov 2026 19:25:46 +0530

amit – 6 file(s) modified
fix(credit-note): commit monthly margin CN run per partner; drop one-time CN/DN remediation

issueMonthlyMarginsCN ran as one transaction for the whole month (2026-11-04: 51 min, 1,441 docs,
a NIC IRN call per doc inside it). The cn_sequence/fofo_dn_sequence bump X-locked every
sellerwarehouse row it touched until commit, so billing's getInvoiceNumber (SELECT ... FOR UPDATE
on the same row) hit innodb_lock_wait_timeout.

- issueMonthlyMarginsCN is now a NOT_SUPPORTED orchestrator: loadMarginRunInput (REQUIRES_NEW
readOnly) -> issueMarginsCNForPartner per fofo (REQUIRES_NEW) -> queueMarginRunReports
(REQUIRES_NEW). Per-partner body unchanged; the partner mail stays in the partner txn.
- sellerwarehouse is read with new SellerWarehouseRepository.selectByPrefixForUpdate (the lock
billing takes) and prefixes are processed in sorted order.
- Removed one-time remediation tools, no live callers: issueCorrectiveMarginCNs (never ran live),
generateDebitNotesForCancelled x2 + processSingleCancelledCnTx (last ran 2026-05-09),
cancelMarginDnIrns + cancelSingleMarginDn, regenerateMarginIrns; repo
selectCancelledByMonth / selectByCreditNoteNumbers.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/CreditNoteRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/CreditNoteRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/SellerWarehouseRepository.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/SellerWarehouseRepositoryImpl.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/CreditNoteService.java
~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/CreditNoteServiceImpl.java

Rev 38004 – perf(onboarding): drop unused joins from WOD finance mapping report query ...

amit — Wed, 04 Nov 2026 17:56:36 +0530

amit – 1 file(s) modified
perf(onboarding): drop unused joins from WOD finance mapping report query

PartnerOnBoardingPanel.selectWodFinMapping joined store_timeline,
fofo_partner_payment_option and partner_service without selecting or filtering
on them. They only duplicated rows (12,895 -> 12,246 on the prod copy), which the
/wodFinMappingReport controller discarded via toMap keep-first. Page output is
identical (634 partners, 0 cell diffs). Pairs with index
partner_dealer_mapping(onboarding_id, brand) for the remaining full scan.

~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/PartnerOnBoardingPanel.java

Rev 38003 – Filtered Active + Internal fofo stores

vikas — Wed, 04 Nov 2026 13:22:09 +0530

vikas – 1 file(s) modified
Filtered Active + Internal fofo stores

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

Rev 38002 – Filtered Active + Internal fofo stores

vikas — Wed, 04 Nov 2026 11:54:50 +0530

vikas – 1 file(s) modified
Filtered Active + Internal fofo stores

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

Rev 38001 – diwali offer live

ranu — Wed, 04 Nov 2026 03:30:54 +0530

ranu – 4 file(s) modified
diwali offer live