Subversion Repositories SmartDukaan

Last modification

• Rev 37601 2026-09-12 14:51:19
• Author: amit

• Log message:

  Remove dead stock-ageing fields rootInvoiceDate and oldest/newest_invoice_date
  
  rootInvoiceDate on WarehouseInventoryItem had no writer anywhere in the codebase and
  was read only by ScheduledTasks.refreshSnapshotAgeing(), which therefore matched zero
  rows on every 30-minute run. oldest/newest_invoice_date on SaholicInventorySnapshot
  were written only by that task and read by nothing. Verified on prod: null on all
  1,528,669 inventoryItem rows and all 11,686 snapshot rows respectively.
  
  Stock ageing that is actually in use resolves the original external supplier at query
  time by serialNumber + supplier.internal = false, and does not read these columns.
  originalInventoryItemId is deliberately left alone - it is populated on 157,020 rows.
  
  Includes sql/drop_dead_ageing_columns_20260912.sql to drop the columns. Run it only
  after web, fofo and cron are all on this build.