Subversion Repositories SmartDukaan

Last modification

• Rev 37878 2026-10-12 13:34:17
• Author: amit

• Log message:

  fix(dao): warehouse lookup survives legacy NULLs; drop unused warehouse fields; moveToGood/moveToBad qty
  
  - /vendors?warehouseId=10516 (UP-NSSPL/Delhi) failed for every supplier: inventory.warehouse
  rows 10600/10601 had NULL billingType/logisticsLocation mapped to primitive int.
  selectSupplierIdsWithGoodWarehouse now selects only vendorId via HQL.
  - InventoryWarehouse/Warehouse: remove never-read fields billingType, logisticsLocation,
  tinNumber, vendorString, lastCheckedOn, transferDelayInHours, isAvailabilityMonitored
  (DB columns kept); status -> Integer (16 legacy NULL rows); null-safe hashCode/equals
  (InventoryWarehouse.hashCode NPE'd on NULL source).
  - Warehouse creators no longer set the removed fields.
  - moveToGood/moveToBad: act on the newest inventory row per serial; moveToGood restores
  currentQuantity to initialQuantity and adds back only the restored qty; moveToBad
  reduces availability only when units are on hand and zeroes currentQuantity.