WebSVN RSS feed – SmartDukaanSat, 20 Jun 2026 03:12:13 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fbackfill_po_rejected_orders.sql&max=40& Fri, 05 Jun 2026 13:01:11 +0530amit<div><strong>amit – 4 file(s) modified</strong><br/>Add PO_REJECTED status and release rejected-PO orders from pending indent<br /> <br /> Rejected bulk-PO approvals refunded the wallet but left order rows in<br /> status=0 (PAYMENT_PENDING) with billing/refund NULL, so they were counted<br /> by pending indent forever and inflated the account-statement closing<br /> balance with no matching wallet liability.<br /> <br /> - OrderStatus.PO_REJECTED(91) new terminal status for approval rejection<br /> - OrderRepository.cancelRejectedTransactionOrders sets status + refund_timestamp<br /> on a rejected transaction's still-pending orders (side-effect free: wallet<br /> already refunded at txn level, these never-processed orders hold no reservation)<br /> - backfill_po_rejected_orders.sql releases 485 historically-stranded orders<br /> (Group A: wallet already refunded). Deploy code before running.</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/in/shop2020/model/v1/order/OrderStatus.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/backfill_po_rejected_orders.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fbackfill_po_rejected_orders.sql&rev=36790https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fbackfill_po_rejected_orders.sql&rev=36790