WebSVN RSS feed – SmartDukaanWed, 07 Oct 2026 16:57:21 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdrop_dead_ageing_columns_20260912.sql&max=40& Sat, 12 Sep 2026 14:51:19 +0530amit<div><strong>amit – 3 file(s) modified</strong><br/>Remove dead stock-ageing fields rootInvoiceDate and oldest/newest_invoice_date<br /> <br /> rootInvoiceDate on WarehouseInventoryItem had no writer anywhere in the codebase and<br /> was read only by ScheduledTasks.refreshSnapshotAgeing(), which therefore matched zero<br /> rows on every 30-minute run. oldest/newest_invoice_date on SaholicInventorySnapshot<br /> were written only by that task and read by nothing. Verified on prod: null on all<br /> 1,528,669 inventoryItem rows and all 11,686 snapshot rows respectively.<br /> <br /> Stock ageing that is actually in use resolves the original external supplier at query<br /> time by serialNumber + supplier.internal = false, and does not read these columns.<br /> originalInventoryItemId is deliberately left alone - it is populated on 157,020 rows.<br /> <br /> Includes sql/drop_dead_ageing_columns_20260912.sql to drop the columns. Run it only<br /> after web, fofo and cron are all on this build.</div>~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/inventory/SaholicInventorySnapshot.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/entity/warehouse/WarehouseInventoryItem.java<br />+ /trunk/profitmandi-dao/src/main/resources/sql/drop_dead_ageing_columns_20260912.sql<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdrop_dead_ageing_columns_20260912.sql&rev=37601https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2F%2Ftrunk%2Fprofitmandi-dao%2Fsrc%2Fmain%2Fresources%2Fsql%2Fdrop_dead_ageing_columns_20260912.sql&rev=37601