WebSVN RSS feed – SmartDukaanWed, 07 Oct 2026 16:57:25 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_idx_order_grn_pending.sql&max=40& Fri, 11 Sep 2026 17:29:49 +0530amit<div><strong>amit – 17 file(s) modified</strong><br/>Serve partner investment from a 2-minute snapshot instead of a 3-hour cache<br /> <br /> getInvestment() was @Cacheable on a 3-hour Redis cache that addAmountToWallet<br /> evicted but consumeAmountFromWallet did not. A partner whose advance payment was<br /> swept straight to a loan had the money counted twice - once as a still-cached<br /> wallet balance, once as the reduced utilisation - overstating their credit limit<br /> by the payment x their tier until the cache expired.<br /> <br /> Replaced with fofo.partner_investment, refreshed every 2 minutes by<br /> PartnerInvestmentSweepService. Every coupled term is read in one pass, so wallet<br /> and utilisation (and in-stock and aged-Apple) can never come from different<br /> moments. A shorter TTL would only have made the error rarer - it scales with the<br /> payment, not the delay.<br /> <br /> - PartnerInvestment entity/repository + partner_investment_snapshot.sql<br /> - PartnerInvestmentSweepService: 9 batched reads, stores base_value for change<br /> detection, refreshes aged-Apple for partners whose stock moved intra-day<br /> - getInvestment/getInvestmentsForFofoStores both read the snapshot, so the two<br /> paths no longer disagree; live compute retained as fallback<br /> - selectActivatedStockAmountByFofoIds: batches an N+1 that cost 233ms x 1690<br /> partners (6.6 min -> 1.0 s)<br /> - getFirstBillingDates: batches another N+1 (4.6 s -> 0.67 s)<br /> - selectPendingGrnOrders(List) now applies the same SD_START_DATE floor as the<br /> single-partner overload; the two were reporting different GRN-pending<br /> - selectPartnerStockValueMap takes excludeActivated: an activated Apple handset<br /> held past the aging window was added once to in-stock and subtracted twice<br /> (activated stock, then the aged haircut). 90 units, 24 partners, Rs 65.19 lakh<br /> double-deducted. Live-demo passes false - no overlap there.<br /> - applyManualAdjustment: routes the two hand-rolled admin wallet adjustments<br /> through WalletServiceImpl so they take the FOR UPDATE lock<br /> - add_idx_order_grn_pending.sql: covering index, GRN query 1320ms -> 514ms</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/InventoryItem.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/fofo/PartnerInvestment.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/transaction/Order.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/InventoryItemRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/InventoryItemRepositoryImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PartnerInvestmentRepository.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/fofo/PartnerInvestmentRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/TransactionRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/TransactionRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/inventory/InventoryServiceImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentServiceImpl.java<br />+ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/PartnerInvestmentSweepService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/wallet/WalletService.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/wallet/WalletServiceImpl.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/add_idx_order_grn_pending.sql<br />+ /trunk/profitmandi-dao/src/main/resources/sql/partner_investment_snapshot.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_idx_order_grn_pending.sql&rev=37588https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fadd_idx_order_grn_pending.sql&rev=37588