Subversion Repositories SmartDukaan

-- HR-NSSPL/GGN (13368) is the central warehouse: every ACTIVE billing warehouse may draw every brand from it except
-- Oppo/Vivo, which stay regional. Additive on top of each warehouse's own mapping - allocation still tries the
-- partner's own warehouse first (TransactionServiceImpl.getFulfillments). Re-runnable (INSERT IGNORE).
-- Applied on hadb1 2026-10-05: 532 rows (8468:78, 8889:78, 8947:78, 9203:78, 12595:79, 13370:67, 13372:74).

CREATE TABLE inventory._bak_warehouseBrandMapping_ggn_central_20261005 AS SELECT * FROM inventory.warehouseBrandMapping;

INSERT IGNORE INTO inventory.warehouseBrandMapping (brand, warehouseFrom, warehouseTo, isAccessory)
SELECT p.brand, 13368, a.warehouse_id, p.isAccessory
  FROM (SELECT DISTINCT brand, isAccessory FROM inventory.warehouseBrandMapping
         WHERE LOWER(brand) NOT IN ('oppo', 'vivo')) p
 CROSS JOIN (SELECT DISTINCT warehouse_id FROM transaction.sellerwarehouse WHERE status = 'ACTIVE') a;

SELECT ROW_COUNT() inserted;
SELECT warehouseTo, COUNT(*) rows_from_13368 FROM inventory.warehouseBrandMapping WHERE warehouseFrom = 13368
 GROUP BY warehouseTo ORDER BY warehouseTo;