Subversion Repositories SmartDukaan

Last modification

• Rev 37592 2026-09-11 19:19:38
• Author: amit

• Log message:

  Fix live-demo deduction lost in the investment snapshot; maintain aged-Apple qty
  
  BUG FIX to r37588. InventoryService.getTotalAmountInStock() returns stock net of
  live-demo units held past 90 days, and both original investment paths assigned
  that netted value to inStockAmount - which is why
  PartnerDailyInvestment.getTotalInvestment() carries no separate demo term. The
  sweep stored the RAW snapshot sum and never applied the deduction, overstating
  investment for 328 partners by Rs 5.19 crore and their limits by roughly Rs 1.3
  crore. Maxwell validated clean earlier only because he holds no demo stock.
  
  Fixed by storing what is measured and deriving what is computed: the column is
  now in_stock_gross_amount and getNetInStockAmount() applies the haircut. The demo
  holding moves on its own daily clock, so storing the netted figure would have
  meant re-netting it in three places every time the haircut changed - the same
  'two things must move together' trap behind the original cache bug. Deriving it
  means a daily demo refresh flows through to stock and base with nothing to sync.
  
  Also:
  - aged_apple_qty stored on the snapshot and maintained on the same daily cycle as
  aged_apple_stock_amount, so the partner banner reads a saved count instead of
  running a count query per dashboard load, and count and value can never disagree
  - selectPartnerStockCountMap mirrors selectPartnerStockValueMap, including the
  activated exclusion
  - selectAgedAppleStock lists the units behind the haircut for the partner view
  - FofoUser exposes aged_apple_stock / aged_apple_qty
  - stock-moved detection compares GROSS: a demo unit crossing 90 days changes net
  stock but nothing physically moved, and that is the daily refresh's job
  
  Schema: partner_investment_snapshot.sql updated (in_stock_gross_amount,
  aged_apple_qty). Applied to prod - the table was empty, so it was dropped and
  recreated from the script.