WebSVN RSS feed – SmartDukaanSat, 20 Jun 2026 01:30:04 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fcleanup_phantom_payment_failed.sql&max=40& Mon, 08 Jun 2026 13:06:28 +0530amit<div><strong>amit – 2 file(s) modified</strong><br/>Add pending-indent phantom-cleanup migrations (drafts + PAYMENT_FAILED)<br /> <br /> selectPendingIndentWalletAmount counts any billing/refund-NULL order regardless<br /> of status, so abandoned draft orders and old PAYMENT_FAILED orders inflated<br /> partner 'unbilled PO' and broke finance reco.<br /> <br /> - cleanup_abandoned_draft_orders.sql: 2019-21 never-submitted, wallet-never-debited<br /> drafts (status=0, not rejected) -> PAYMENT_FAILED + refund_timestamp. ~1970 rows.<br /> - cleanup_phantom_payment_failed.sql: 2017-19 PAYMENT_FAILED orders counted as<br /> unbilled PO -> drop ONLY phantom (no-debit or net-settled) via refund_timestamp;<br /> KEEP net-committed (real payable). Temp-table form to avoid locking the live DB.<br /> <br /> Both data-only (no code), idempotent, ran on hadb1; pending prod + replicas.</div>+ /trunk/profitmandi-dao/src/main/resources/sql/cleanup_abandoned_draft_orders.sql<br />+ /trunk/profitmandi-dao/src/main/resources/sql/cleanup_phantom_payment_failed.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fcleanup_phantom_payment_failed.sql&rev=36795https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fcleanup_phantom_payment_failed.sql&rev=36795