Subversion Repositories SmartDukaan

Last modification

• Rev 36397 2026-04-27 14:38:57
• Author: amit

• Log message:

  Scheme item windowing: add startDate/endDate per scheme_item.
  
  Each fofo.scheme_item row now carries an optional [start_date, end_date]
  window so the same (scheme_id, catalog_id) pair can be applicable for
  different date ranges. Backward compatible: NULL window = always active.
  
  - SchemeItem entity: composite (schemeId, catalogId) PK -> surrogate
  long id (IDENTITY), unique (catalog_id, scheme_id, start_date, end_date),
  audit cols (updatedBy, updatedOn).
  - Scheme + TagListing named queries: gated by
  '(si.start_date is null or :onDate between si.start_date and si.end_date)'.
  - SchemeItemRepository: + selectById, selectBySchemeId,
  existsOverlapping (half-open, with self-exclude), selectItemsOutsideWindow.
  - SchemeService: + updateSchemeItemWindow / addSchemeItemWithDates /
  clampSchemeItems with containment + overlap validation; drop dead
  getTotalMargin.
  - SchemeServiceImpl.processSchemeOut: pin scheme resolution to each
  IMEI's GRN billing date (Purchase -> Order.billingTimestamp via
  PurchaseService.getBillingDateOfPurchase) instead of fofoOrder
  createTimestamp, aligning OUT with the existing IN behaviour.