Subversion Repositories SmartDukaan

Rev

Show changed files | Details | Compare with Previous | Blame | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36831 6 d 21 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Account statement: reconcile month-end scheme line to wallet net; exclude loan from statement

- Add a "Scheme adjustment (per wallet)" line at each month-end = wallet scheme net minus
margin CN total, so the running balance follows the actual wallet (source of truth)
instead of the CN gross. Surfaces scheme reversals (e.g. demo-convert) that margin CNs
miss, instead of burying them in the FLOAT DIFF / rounding line.
- Statement excludes loan/interest entirely (closing = wallet + pending indent): keep
CREDIT_LIMIT/CREDIT_UTILIZED/LOAN/LOAN_REPAYMENT legs in the body so it reconciles to the
loan-free closing; drop the INTEREST ACCRUED line and interestAccruedCost plumbing.
 
36801 9 d 18 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Stock Purchase sAle ageing days, added fields to mail  
36780 13 d 22 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Rename reco CSV column header In Transit -> Unbilled PO (label only; calculation unchanged)  
36776 13 d 23 h amit /trunk/profitmandi-fofo/src/main/ Remove redundant /account/closing-statements; repoint wallet-details closing button to /account/reco (now on the wallet+PI-loan model)  
36775 13 d 23 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Align /account/reco closing with individual account statement: closing = wallet + pending indent - loan outstanding; add Loan Outstanding column  
36772 14 d 16 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Account statement: per-CN scheme/margin lines + non-month-end raw-scheme fallback.

- Month-end: one 'Margin / Scheme Payout' line PER credit note (MARGINS net >=0 -> Credit Note (CN); CN_CANCELLATION or negative net -> Debit Note (DN), reducing the balance), referenced by CN number.
- Non-month-end statements: the trailing month's MARGINS CN isn't issued yet, so consolidate that month's raw scheme wallet entries into a single 'Margin / Scheme Payout' line placed at the end, just before the FLOAT DIFF. Keeps partial-period statements reconciling (verified AYAAN 01-15/04 float -1.97 vs 36,462 in the diff without it).
 
36769 14 d 17 h amit /trunk/ Account statement: select the month-end scheme/margin credit notes by margin_month instead of cn_date.

Added CreditNoteRepository.selectByMarginMonth(fofoId, YearMonth) - fofo-scoped, keyed on margin_month passed as a YearMonth so the generic repo matches it as a whole-month range (robust to the stored day). populateData now uses it for the month-end CN block. margin_month is the explicit margin-period field (always populated for MARGINS and CN_CANCELLATION; RETURNS have none and are naturally excluded, consistent with returns being sourced from returnorderinfo).
 
36755 15 d 22 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Account statement: relabel the reconciling line as 'FLOAT DIFF' (rounding/float only).

It is not pending indent or a cross-period movement - with clean data it is only a few rupees of float. A large value indicates a data issue (e.g. MARGINS CN not yet rolled out) and is surfaced by the existing reconciliation warning.
 
36754 15 d 23 h amit /trunk/ Account statement (Excel): reconcile running balance to net standing (wallet + pending indent - loan).

- populateData: categorised lines, scheme/margin shown as month-end MARGINS credit note (CN_CANCELLATION and negative-net CNs rendered as debit notes), interest-accrued line as the standing-moving loan cost, and a net-pending-indent/diff line that lands the running balance on closing.
- Returns shown individually from returnorderinfo (one credit line per return, against its invoice on refundedAt); billing-query RETURNED/RETURNS_CN suppressed to avoid double count.
- Exclude PURCHASE and CREDIT_LIMIT/CREDIT_UTILIZED (loan cash legs) from the wallet body.
- LoanStatementRepository.getInterestAccruedBetween; ReturnOrderInfoRepository.selectReturnsBetween.
 
36746 17 d 2 h amit /trunk/profitmandi-fofo/src/main/ Restore Total Payables and Credit Utilization fields on wallet statement dashboard (NPE-safe via creditSummary)  
36720 21 d 15 h amit /trunk/profitmandi-fofo/src/main/ Remove redundant credit section from wallet dashboard: fixes NPE for users without SD Credit, credit info already available in partner report  
36513 38 d 17 h amit /trunk/ Add running_balance to userwallethistory: persist wallet balance after each transaction for instant ledger display. Populate at all write paths (WalletService, adjustTransaction). Read directly in wallet statement template and CSV download. Includes backfill migration SQL. Renamed walletSummart to walletSummary.  
36500 40 d 17 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ l3 and avobe show all warehouse stock  
36401 51 d 21 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Replace mailSender (SendGrid) with gmailRelaySender - SendGrid API key expired/revoked  
36242 68 d 16 h aman /trunk/ Fix:Attachment is Full-stock payment approval ,Timeline ui graphical summary, wod initianl mail after store code creation  
36064 84 d 15 h aman /trunk/ Fix:FULL_Stock flow , fin service mark unapplicable ,send invoice to whatsapp by default, update contact list ,Training mail issue  
35971 100 d 16 h aman /trunk/ Feat : Loi 2.0 Enhancement and redesigning  
35811 117 d 13 h amit /trunk/ 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  
35572 150 d 11 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fix: Remove duplicate persist in wallet approval

The addWalletRequest status was already being updated in memory,
and the entity is managed by Hibernate session - no explicit persist needed.
 
35458 179 d 15 h amit /trunk/ Revert @Transactional(readOnly=true) - keep @Transactional only at Controller level

Changes:
- profitmandi-web: Controllers use @Transactional(rollbackFor = Throwable.class) at class level, removed method-level @Transactional(readOnly = true)
- profitmandi-fofo: Controllers use @Transactional(rollbackFor = Throwable.class) at class level, removed method-level @Transactional
- profitmandi-dao: Removed @Transactional from services/repositories

Exceptions (called from interceptors, need own transaction):
- RoleManager: @Transactional(readOnly = true) - called from interceptor for auth
- PartnerTypeChangeServiceImpl.getBestPartner(): @Transactional - called from JWTUtil via interceptor

Fixed javax.transaction.Transactional to org.springframework.transaction.annotation.Transactional
Fixed rollbackOn to rollbackFor for Spring compatibility
 
35197 246 d 16 h amit /trunk/ Fixed Add Wallet Request Logic  
34982 280 d 21 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Update  
34712 356 d 20 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ donotcommit  
34527 407 d 21 h tejus.lohani /trunk/ hdfc payment report and investometer in partner dashboard  
34441 422 d 23 h tejus.lohani /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ wallet statement download and account statement download problem fix  
34440 422 d 23 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ config  
34435 424 d 20 h tejus.lohani /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ upi payment capture details modification and remove admit check in wallet statement download and account statement download so that partner download his account and wallet statement  
34261 470 d 19 h tejus.lohani /trunk/ Give (a pending,approved,reject)add-wallet-req report  
34096 527 d 23 h aman.kumar /trunk/ Wallet-report changes and wallet-addn serchbydate option  
33861 616 d 21 h tejus.lohani /trunk/ check fullStockPayment and orderDispatch and auto mark billing and fullstock payment  
33696 664 d 1 h amit.gupta /trunk/ Added changes related to Narration and fixing loan creation while billing  
33449 733 d 22 h ranu /trunk/ add total due and utilization number on wallet  
33420 746 d 18 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed average credit days.  
33363 767 d 19 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Order quantity avai  
33362 767 d 19 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Order quantity avai  
33361 767 d 19 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Order quantity avai  
33360 767 d 19 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Order quantity avai  
33359 768 d 16 h amit.gupta /trunk/ Fixed Sanction as well as approval issue  
33354 768 d 22 h amit.gupta /trunk/ Enhanced Sidbi Sanctions  
33238 789 d 22 h amit.gupta /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed wallet statement changes