Subversion Repositories SmartDukaan

Rev

Show changed files | Directory listing | RSS feed

Filtering Options

Rev Age Author Path Log message Diff
36803 5 h 1 m amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Exclude loan legs from analysis-dashboard account-statement bodies

Match WalletController's running-balance filter: also exclude CREDIT_LIMIT,
CREDIT_UTILIZED, LOAN, LOAN_REPAYMENT (were only excluding PURCHASE +
CN_WALLET_REFERENCES) in /analysis/account/statement and the analysis-account
-statement views, so loan churn no longer distorts the running body.
 
36802 6 h 4 m ranu /trunk/ some enhancement and bug fixes  
36801 7 h 16 m amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Fixed Stock Purchase sAle ageing days, added fields to mail  
36800 7 h 52 m ranu /trunk/profitmandi-fofo/src/main/ some enhancement and bug fixes  
36799 8 h 50 m amit /trunk/profitmandi-fofo/src/main/ Add standalone Route Scheduling (PJP) analytics dashboard at /route-analytics, restricted to amit.gupta and tarun.verma  
36798 10 h 11 m amit /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/service/ Add RouteAnalyticsService for Beat Plan (PJP) analytics dashboard (read-only native SQL)  
36797 11 h 10 m ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ some enhancement and bug fixes  
36796 11 h 12 m amit /trunk/profitmandi-dao/src/main/resources/sql/ Add migration: void net-settled stranded status=0 orders

Captures the two ad-hoc cleanups run on hadb1 (the live DB): rejected-txn orders
the PO_REJECTED backfill missed (non-standard refund) -> PO_REJECTED(91), and
non-rejected status=0 orders whose wallet debit was reversed by a non-standard
entry -> refund_timestamp. Net-settled only; net-committed/awaiting-approval POs
left untouched. Temp-table form to avoid locking the live DB. Idempotent.
 
36795 11 h 50 m amit /trunk/profitmandi-dao/src/main/resources/sql/ Add pending-indent phantom-cleanup migrations (drafts + PAYMENT_FAILED)

selectPendingIndentWalletAmount counts any billing/refund-NULL order regardless
of status, so abandoned draft orders and old PAYMENT_FAILED orders inflated
partner 'unbilled PO' and broke finance reco.

- cleanup_abandoned_draft_orders.sql: 2019-21 never-submitted, wallet-never-debited
drafts (status=0, not rejected) -> PAYMENT_FAILED + refund_timestamp. ~1970 rows.
- cleanup_phantom_payment_failed.sql: 2017-19 PAYMENT_FAILED orders counted as
unbilled PO -> drop ONLY phantom (no-debit or net-settled) via refund_timestamp;
KEEP net-committed (real payable). Temp-table form to avoid locking the live DB.

Both data-only (no code), idempotent, ran on hadb1; pending prod + replicas.
 
36794 2 d 8 h aman /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/ Fix:Branding->Verification  
36793 3 d 4 h ranu /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ some enhancement and bug fixes  
36792 3 d 6 h ranu /trunk/profitmandi-fofo/src/main/ some enhancement and bug fixes  
36791 3 d 11 h amit /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ Mark rejected PO order rows on transaction rejection

In OrderController.updateApprovalStatus reject branch, after the wallet
refund and loan settlement, call cancelRejectedTransactionOrders so the
rejected PO's order rows move to PO_REJECTED and drop out of pending
indent. Previously they were left in status=0, permanently inflating the
partner's account-statement pending indent. Requires dao r36790.
 
36790 3 d 11 h amit /trunk/profitmandi-dao/src/main/ Add PO_REJECTED status and release rejected-PO orders from pending indent

Rejected bulk-PO approvals refunded the wallet but left order rows in
status=0 (PAYMENT_PENDING) with billing/refund NULL, so they were counted
by pending indent forever and inflated the account-statement closing
balance with no matching wallet liability.

- OrderStatus.PO_REJECTED(91) new terminal status for approval rejection
- OrderRepository.cancelRejectedTransactionOrders sets status + refund_timestamp
on a rejected transaction's still-pending orders (side-effect free: wallet
already refunded at txn level, these never-processed orders hold no reservation)
- backfill_po_rejected_orders.sql releases 485 historically-stranded orders
(Group A: wallet already refunded). Deploy code before running.
 
36789 3 d 13 h ranu /trunk/profitmandi-fofo/src/main/ some enhancement and bug fixes  
36788 3 d 13 h ranu /trunk/profitmandi-fofo/src/main/ some enhancement and bug fixes  
36787 3 d 14 h ranu /trunk/ some enhancement and bug fixes  
36786 4 d 7 h ranu /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/ some enhancement and bug fixes  
36785 4 d 7 h ranu /trunk/profitmandi-fofo/src/main/ some enhancement and bug fixes  
36784 4 d 8 h vikas /trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ Location Tracking - From Punch IN  

Show All