Page Comparison

...

迁移项

备注

数量（1站点，36站点）

SQL

客户站点开通

库存

跟随库位

1: 72215

36: 1502

Code Block

select count(*) from container_product 
inner join container on container.id = container_id
inner join aisle on aisle.id = container.aisle_id
inner join zone on zone.id = zone_id
inner join warehouse on warehouse.id = warehouse_id
where warehouse.company_id = 1 and container.status = 'ACTIVE';

库位

跟随过道

1：843115

36: 23044

Code Block

language	sql

select count(container.id) from container 
inner join aisle on aisle.id = container.aisle_id
inner join zone on zone.id = zone_id
inner join warehouse on warehouse.id = warehouse_id
where warehouse.company_id = 1 and container.status = 'ACTIVE';

过道

跟随库区

库区

跟随仓库

仓库

修改站点id修改仓库的站点id为分站点id，需要确认好，仓库要移到哪个分站点

Versions Compared

Old Version 3

New Version 4

Key