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;