Subversion Repositories SmartDukaan

Last modification

• Rev 37563 – 27 d 14 h
• Author: amit

• Log message:

  Filter delisted SKUs out of creation pickers; add rolling 24m delist migration
  
  Creation screens could offer items whose catalog.tag_listing.active = 0:
  - Item.selectAllModels (scheme/offer model dropdown) joined tag_listing with
  no active predicate. Adding tl.active = true also gives the model-level
  rollup, since callers dedupe to catalogItemId: a model whose colours are
  all inactive now yields no rows, one keeping a listed colour stays.
  - The shared partner item picker had no active filter at all. Added a second
  basis via getAllPartnerItemStringDescription(anyColor, activeOnly);
  activeOnly participates in the fofoItems cache key so the two bases cannot
  serve each other's cached results. Default stays false for screens that
  inspect or edit existing records.
  - New TagListing.selectActiveItemIds named query backs the filter.
  
  Also adds the rolling 24-month delist migration: zero stock both sides, no
  outstanding vendor PO (status IN (1,2), external supplier, unfulfilled > 0 --
  INIT is excluded as it is a drawer of stale drafts), and re-categorises
  fully-dark mobile models to OTHER. Idempotent, audited, rollback documented.