| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 38005 |
7 h 50 m |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/ |
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. |
|
| 38004 |
9 h 19 m |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/ |
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. |
|
| 38003 |
13 h 53 m |
vikas |
/trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ |
Filtered Active + Internal fofo stores |
|
| 38002 |
15 h 21 m |
vikas |
/trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/ |
Filtered Active + Internal fofo stores |
|
| 38001 |
23 h 45 m |
ranu |
/trunk/profitmandi-fofo/src/main/ |
diwali offer live |
|
| 38000 |
23 h 46 m |
ranu |
/trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/controller/scratch/ |
diwali online scratch offer, otp send to email |
|
| 37999 |
1 d 0 h |
ranu |
/trunk/profitmandi-fofo/src/main/ |
diwali offer live |
|
| 37998 |
1 d 0 h |
ranu |
/trunk/ |
diwali online scratch offer, otp send to email |
|
| 37997 |
1 d 8 h |
amit |
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/ |
fix(mail): rotate sdtech@smartdukaan.com Gmail app password
Old app password rejected with 535-5.7.8 BadCredentials since 2026-11-02 04:00;
all googleMailSender (smtp.gmail.com:465) mail failing. New password verified
(AUTH 235 Accepted) from the prod app server. |
|
| 37996 |
1 d 8 h |
amit |
/trunk/profitmandi-web/src/main/java/com/spice/profitmandi/web/config/ |
fix(mail): rotate sdtech@smartdukaan.com Gmail app password
Old app password rejected with 535-5.7.8 BadCredentials since 2026-11-02 04:00;
all googleMailSender (smtp.gmail.com:465) mail failing. New password verified
(AUTH 235 Accepted) from the prod app server. |
|
| 37995 |
1 d 8 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/ |
fix(mail): rotate sdtech@smartdukaan.com Gmail app password
Old app password rejected with 535-5.7.8 BadCredentials since 2026-11-02 04:00;
all googleMailSender (smtp.gmail.com:465) mail failing. New password verified
(AUTH 235 Accepted) from the prod app server. |
|
| 37994 |
1 d 11 h |
amit |
/trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ |
fix(credit-limit): settled SIDBI partner falls back to investment-based limit
A SIDBI partner with no unsettled sanction got a suggested limit of 0; it now gets the normal
investment-based limit, with the SIDBI unsettled amount as a floor only while a sanction is open. |
|
| 37993 |
1 d 11 h |
amit |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/ |
fix(sidbi): extend principal deduction schedule to 48 months and sum it correctly
Monthly SIDBI deductions crashed with IndexOutOfBounds once a sanction passed month 24, rolling back
the whole run (settled_amount frozen since 5 Apr 2026). Months 1-24 are kept; the remaining principal
is re-amortised over months 25-48 at 18% p.a. Deduction is now the running sum of months repaid
(was N x month-N value, which over-settled), and from month 48 the full loan is settled so settled_on is set. |
|
| 37992 |
2 d 7 h |
ranu |
/trunk/ |
rbm drr billed partner also coming |
|
| 37991 |
2 d 8 h |
vikas |
/trunk/ |
Extended name: use AuthUser.getFullName() everywhere employee names are shown |
|
| 37990 |
2 d 8 h |
vikas |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/model/ |
Added Extended Auth User Name |
|
| 37989 |
2 d 8 h |
vikas |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/auth/ |
Chola Integration |
|
| 37988 |
2 d 9 h |
vikas |
/trunk/ |
Added Extended Name of User |
|
| 37987 |
2 d 9 h |
ranu |
/trunk/ |
diwali online scratch offer, otp send to email |
|
| 37986 |
2 d 10 h |
amit |
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ |
feat(credit): wallet page passes default-loan count to the inactive message (needs dao commit of same change) |
|