Subversion Repositories SmartDukaan

-- Seed Dummy/GOOD/OURS warehouses under fallback vendor (id = 40) for every billing region
-- in ProfitMandiConstants.WAREHOUSE_MAP that doesn't already have one.
--
-- Phantom order allocations (placement when stock is insufficient or missing) route to the
-- Dummy warehouse for the partner's billing region. This guarantees every region has a
-- deterministic phantom target; going forward WarehouseServiceImpl.ensureDummyForBillingRegion
-- auto-creates Dummies when a new billing region's first warehouse is created.
--
-- Idempotent: uses NOT EXISTS to skip regions that already have a Dummy (the 5 pre-existing
-- regions with coverage: 7, 7441, 7573, 9203, 9213).
--
-- Applied on: hadb1 (remote) and local 127.0.0.1 as part of this refactor.

INSERT INTO inventory.warehouse
    (displayName, vendor_id, billingWarehouseId, shippingWarehouseId,
     inventoryType, warehouseType, status, billingType,
     state_id, addedOn, lastCheckedOn)
SELECT
    CONCAT(bw.displayName, '/Dummy/G'),
    40,
    bw.id,
    bw.id,
    'GOOD',
    'OURS',
    3,
    0,
    bw.state_id,
    NOW(),
    NOW()
FROM inventory.warehouse bw
WHERE bw.id IN (7720, 8947, 8468, 7678, 9349, 8889, 9470, 9513, 9514,
                10010, 10516, 10519, 10520, 10521)
  AND NOT EXISTS (
    SELECT 1 FROM inventory.warehouse w
    WHERE w.vendor_id = 40 AND w.billingWarehouseId = bw.id
      AND w.inventoryType = 'GOOD' AND w.warehouseType = 'OURS'
  );

-- Verify coverage:
-- SELECT billingWarehouseId, id, displayName
-- FROM inventory.warehouse
-- WHERE vendor_id = 40 AND inventoryType='GOOD' AND warehouseType='OURS'
-- ORDER BY billingWarehouseId;