| Rev |
Age |
Author |
Path |
Log message |
Diff |
| 36803 |
3 h 0 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 |
4 h 3 m |
ranu |
/trunk/ |
some enhancement and bug fixes |
|
| 36801 |
5 h 15 m |
amit |
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ |
Fixed Stock Purchase sAle ageing days, added fields to mail |
|
| 36800 |
5 h 51 m |
ranu |
/trunk/profitmandi-fofo/src/main/ |
some enhancement and bug fixes |
|
| 36799 |
6 h 49 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 |
8 h 10 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 |
9 h 9 m |
ranu |
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ |
some enhancement and bug fixes |
|
| 36796 |
9 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 |
9 h 49 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 6 h |
aman |
/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/user/ |
Fix:Branding->Verification |
|
| 36793 |
3 d 2 h |
ranu |
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ |
some enhancement and bug fixes |
|
| 36792 |
3 d 4 h |
ranu |
/trunk/profitmandi-fofo/src/main/ |
some enhancement and bug fixes |
|
| 36791 |
3 d 9 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 9 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 11 h |
ranu |
/trunk/profitmandi-fofo/src/main/ |
some enhancement and bug fixes |
|
| 36788 |
3 d 11 h |
ranu |
/trunk/profitmandi-fofo/src/main/ |
some enhancement and bug fixes |
|
| 36787 |
3 d 12 h |
ranu |
/trunk/ |
some enhancement and bug fixes |
|
| 36786 |
4 d 5 h |
ranu |
/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/config/ |
some enhancement and bug fixes |
|
| 36785 |
4 d 5 h |
ranu |
/trunk/profitmandi-fofo/src/main/ |
some enhancement and bug fixes |
|
| 36784 |
4 d 6 h |
vikas |
/trunk/profitmandi-fofo/src/main/webapp/WEB-INF/views/ftl/ |
Location Tracking - From Punch IN |
|