Subversion Repositories SmartDukaan

-- Warehouse status + label move from ProfitMandiConstants.WAREHOUSE_MAP / WAREHOUSE_NAME_MAP into the seller registration.
--   ACTIVE    operating: dashboards, warehouse-team screens, new orders
--   SUSPENDED stopped, may come back; stock and returns still cleared through the warehouse-team screens
--   INACTIVE  closed for good: only the label survives, for old records
-- is_active is no longer read by the code; it stays until every app runs the new build.
-- sellerwarehouse is ~33 rows.

CREATE TABLE transaction._bak_sellerwarehouse_status_20261005 AS SELECT * FROM transaction.sellerwarehouse;

ALTER TABLE transaction.sellerwarehouse
    ADD COLUMN status VARCHAR(16) NOT NULL DEFAULT 'ACTIVE',
    ADD COLUMN display_name VARCHAR(64) NULL,
    ALGORITHM=INPLACE, LOCK=NONE;

-- Labels exactly as WAREHOUSE_MAP had them
UPDATE transaction.sellerwarehouse SET display_name = CASE warehouse_id
    WHEN 7720  THEN 'HR'
    WHEN 7573  THEN 'DELHI'
    WHEN 8947  THEN 'RJ'
    WHEN 8468  THEN 'UP-EAST'
    WHEN 7678  THEN 'UP-WEST/NOIDA'
    WHEN 9349  THEN 'UP-WEST/SRNPR'
    WHEN 9203  THEN 'UK'
    WHEN 8889  THEN 'PUNJAB'
    WHEN 9470  THEN 'UK/RDPR'
    WHEN 9513  THEN 'UP-WEST/BLY'
    WHEN 9514  THEN 'DL-UPWEST/NOIDA'
    WHEN 9213  THEN 'DL-UK'
    WHEN 10010 THEN 'DL-PB'
    WHEN 10516 THEN 'UP-NSSPL/Delhi'
    WHEN 10519 THEN 'UP-NSSPL/DL-HR'
    WHEN 10520 THEN 'UP-NSSPL/DL-UK'
    WHEN 10521 THEN 'UP-NSSPL/DL-PB'
    WHEN 12595 THEN 'MP'
    WHEN 13368 THEN 'HR-NSSPL/GGN'
    WHEN 13370 THEN 'HR-NSSPL/DL'
    WHEN 13372 THEN 'HR-NSSPL/UPW'
END;

-- Warehouses that were never in WAREHOUSE_MAP take their inventory.warehouse name
UPDATE transaction.sellerwarehouse sw JOIN inventory.warehouse w ON w.id = sw.warehouse_id
   SET sw.display_name = LEFT(w.displayName, 64)
 WHERE sw.display_name IS NULL;

-- Delhi/Noida/UP-NSSPL hubs stopped 2026-10-05 (indent moved to the HR warehouses, brand mapping removed)
UPDATE transaction.sellerwarehouse SET status = 'SUSPENDED'
 WHERE warehouse_id IN (7573, 7720, 7678, 9349, 9470, 9513, 9514, 9213, 10010, 10516, 10519, 10520, 10521);

-- Not billed since 2021 or never: no stock, no open orders, no active store
UPDATE transaction.sellerwarehouse SET status = 'INACTIVE'
 WHERE warehouse_id IN (7, 7441, 7480, 7681, 10515);

SELECT warehouse_id, display_name, status, COUNT(*) rows_ FROM transaction.sellerwarehouse
 GROUP BY warehouse_id, display_name, status ORDER BY status, warehouse_id;