断舍离
1.绝大多数青年人都不会想的一件事，就是自己的死亡。
2.克制地购买，克制地享受。
3.克制欲望，看本质
这不是传统，这不是传统，这不是传统。
这是生意。
因为我们富起来一共也没多少年。
4.关于衣服饰品
BS-8734 自发头程客户发货单状态优化 ---开发部
- to Hallucin Grape (Unlicensed)
背景需求
背景：
自发头程发货单，新增了“部分上架”的状态，目前的逻辑是发货单状态要已收货之后的上架才会触发“部分上架”的流转，实际业务中，大部分情况是没有系统操作收货，就直接上架了，这种情况下，发货单状态是不会流转到“部分上架”。所以需要针对次情况做出优化。
需求描述：
1、自发头程的发货单，只要有上架的产品，但没有全部上架，发货单状态就显示为“部分上架”，无需在收货状态下才触发流转。
2、待发货单的产品全部上架完成后，才流转为已上架。
开发方案描述
去掉判断发货单是否已收货的状态
测试环境
工具类型 | 工具名称 | 其他 |
|---|---|---|
浏览器 | chromecore |
|
| bird system | http://www.bs-8734.test.birdsystem.com/client name: test password: 12345 http://www.bs-8734.test.birdsystem.com/admin name: test password: 12345 |
接口工具 | apipost | |
MySQL管理器 | navicat | -- -- ---------------------------- -- -- Records of client -- -- Update Time V20210812 Grape -- -- ---------------------------- -- INSERT INTO `client` VALUES (6666, NULL, 'Test Client 1', NULL, NULL, 0x746573743140746573742E636F6D, 'zhuang@xiang.com', NULL, '123456', 0x33323335323335, NULL, NULL, 'Address Line 1', 'Address Line 2', 'Address Line 3', 'ShenZhen', 'GuangDong', '519000', 'CN', '2016-01-17 20:32:03', NULL, '2021-08-11 10:45:46', NULL, NULL, NULL, 'ID', 1, 1, 1, 1, 0, 0, 0, 1, 10, 15, 15, 15, 15, 15, 0, 'UNKNOWN', 'ACTIVE'); -- INSERT INTO `client` VALUES (8888, NULL, 'Test Client 2', NULL, NULL, 0x746573743240746573742E636F6D, 'sfsdf@dfs.com', NULL, '123456', 0x33323335323335, NULL, NULL, 'Address Line 1', 'Address Line 2', 'Address Line 3', 'ShenZhen', 'GuangDong', '519000', 'CN', '2016-01-17 20:32:03', NULL, '2020-03-17 02:16:32', NULL, NULL, NULL, 'ID', 1, 1, 1, 0, 0, 0, 0, 1, 10, 15, 15, 15, 15, 15, 0, 'UNKNOWN', 'ACTIVE'); -- INSERT INTO `client` VALUES (9999, NULL, 'Test Client 3', NULL, NULL, 0x746573743340746573742E636F6D, 'test3@test.com', NULL, '123456', 0x33323335323335, NULL, NULL, 'Address Line 1', 'Address Line 2', 'Address Line 3', 'ShenZhen', 'GuangDong', '519000', 'CN', '2016-01-17 20:32:03', NULL, NULL, NULL, NULL, NULL, 'ID', 1, 1, 1, 0, 0, 0, 0, 1, 10, 15, 15, 15, 15, 15, 0, 'UNKNOWN', 'ACTIVE'); -- ---------------------------- -- Records of client_user -- Update Time V20210812 Grape -- ---------------------------- -- INSERT INTO `client_user` VALUES (3333, 1, 1, 'grape', '827ccb0eea8a706c4c34a16891f84e7b', '4f04f7b7c8407bb92f496c832ee88af9', 123456789, 0x746573743140746573742E636F6D, '690248104', '+1-787-971-3118', 'Test', 'Test', 'Test Department', 1, 1, 1, 0, '', '', 'ACTIVE', 1); -- INSERT INTO `client_user` VALUES (6666, 2, 2, 'grape2', '827ccb0eea8a706c4c34a16891f84e7b', '4523e5798349624c550df5d7e82a03fa', 123456789, 0x746573743240746573742E636F6D, '690248104', '+1-787-971-3118', 'Test', 'Test', 'Test Department', 1, 1, 1, 0, '', '', 'ACTIVE', 1); -- INSERT INTO `client_user` VALUES (8888, 3, 3, 'grape3', '827ccb0eea8a706c4c34a16891f84e7b', '28aab154dacb5af97afd74d9409d7f5a', 123456789, 0x746573743340746573742E636F6D, '690248104', '+1-787-971-3118', 'Test', 'Test', 'Test Department', 1, 1, 1, 0, '', '', 'ACTIVE', 1); -- ---------------------------- -- Records of warehouse -- update time v20210812 grape -- ---------------------------- INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (200, 1, 'A站-FBA-A', 1, 1, 1, 1, 1, 'ACTIVE'); INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (201, 1, 'A站-FBA-B', 1, 1, 1, 1, 1, 'ACTIVE'); INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (202, 1, 'A站-非FBA-A', 1, 1, 1, 1, 1, 'ACTIVE'); INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (203, 2, 'B站-FBA-A', 1, 1, 1, 1, 1, 'ACTIVE'); INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (204, 2, 'B站-FBA-B', 1, 1, 1, 1, 1, 'ACTIVE'); INSERT INTO `warehouse`(`id`, `company_id`, `name`, `is_dynamic_warehouse_origin`, `is_dynamic_warehouse_destination`, `is_client_dispatch_origination`, `is_client_dispatch_destination`, `is_fba_transport`, `status`) VALUES (205, 2, 'B站-非FBA-B', 1, 1, 1, 1, 1, 'ACTIVE'); -- ---------------------------- -- Records of client_dispatch_delivery_type -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1000, 1, 200,'出A站-FBA-A-到仓入库', '200', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1001, 1, 201,'出A站-FBA-B-到仓入库', '201', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1002, 1, 202, '出A站-非FBA-A-到仓入库', '202', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1003, 2, 203, '出B站-FBA-A到仓入库', '203', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1004, 2, 204, '出B站-FBA-B-到仓入库', '204', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1005, 2, 205, '出B站-非FBA-A-到仓入库', '205', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1006, 2, 200,'到A站-FBA-A-到仓入库', '200', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1007, 2, 201,'到A站-FBA-B-到仓入库', '201', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1008, 2, 202, '到A站-非FBA-A-到仓入库', '202', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1009, 1, 203, '到B站-FBA-A到仓入库', '203', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1010, 1, 204, '到B站-FBA-B-到仓入库', '204', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (1011, 1, 205, '到B站-非FBA-A-到仓入库', '205', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2000, 1, 200,'出A站-FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2001, 1, 201,'出A站-FBA-B到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2002, 1, 202, '出A站-非FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2003, 2, 203, '出B站-FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2004, 2, 204, '出B站-FBA-B到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2005, 2, 205, '出B站-非FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2006, 2, 200,'到A站-FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2007, 2, 201,'到A站-FBA-B到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2008, 2, 202, '到A站-非FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2009, 1, 203, '到B站-FBA-A到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2010, 1, 204, '到B站-FBA-B到仓转运', '98', 'ACTIVE', 1, 0); INSERT INTO `client_dispatch_delivery_type` (`id`, `company_id`, `warehouse_id_destination`, `name`, `code`, `status`, `is_delivery_to_warehouse`, `is_vat_mandatory`) VALUES (2011, 1, 205, '到B站-非FBA-A到仓转运', '98', 'ACTIVE', 1, 0); -- ---------------------------- -- Records of client_warehouse -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 200); INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 201); INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 202); INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 203); INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 204); INSERT INTO `client_warehouse` (`client_id`, `warehouse_id`) VALUES (1, 205); -- ---------------------------- -- Records of container_type -- update time v20210812 grape -- ---------------------------- INSERT INTO `container_type` (`id`, `company_id`, `name`, `length`, `width`, `depth`, `special_type`) VALUES (2001, 2, '普通容器类型专用', 99999999999.00, 99999999999.00, 99999999999.00, 'STANDARD'); INSERT INTO `container_type` (`id`, `company_id`, `name`, `length`, `width`, `depth`, `special_type`) VALUES (2002, 2, '退货容器类型专用', 99999999999.00, 99999999999.00, 99999999999.00, 'RETURN'); INSERT INTO `container_type` (`id`, `company_id`, `name`, `length`, `width`, `depth`, `special_type`) VALUES (2003, 2, '客户发货单容器类型专用', 99999999999.00, 99999999999.00, 99999999999.00, 'CLIENT_DISPATCH_CONTAINER'); INSERT INTO `container_type` (`id`, `company_id`, `name`, `length`, `width`, `depth`, `special_type`) VALUES (2004, 2, '临时上货箱类型专用', 99999999999.00, 99999999999.00, 99999999999.00, 'IN_USE_FOR_STOCKING'); -- ---------------------------- -- Records of zone -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111279, 200, '1站点-FBA-A-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111280, 200, '1站点-FBA-A-B,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111281, 201, '1站点-FBA-B-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111282, 201, '1站点-FBA-B-B,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111283, 202, '1站点-FBA-A-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111284, 203, '2站点-FBA-A-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111285, 203, '2站点-FBA-A-B,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111286, 204, '2站点-FBA-B-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111287, 204, '2站点-FBA-B-B,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (1111288, 205, '2站点-非FBA-A-A,收货区', 1, 'ALL', 'RECEIVE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222279, 200,'1站点-FBA-A-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222280, 200,'1站点-FBA-A-B,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222281, 201,'1站点-FBA-B-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222282, 201,'1站点-FBA-B-B,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222283, 202, '1站点-FBA-A-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222284, 203, '2站点-FBA-A-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222285, 203, '2站点-FBA-A-B,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222286, 204, '2站点-FBA-B-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222287, 204, '2站点-FBA-B-B,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (2222288, 205, '2站点-非FBA-A-A,查验区', 1, 'ALL', 'CHECK', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333379, 200,'1站点-FBA-A-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333380, 200,'1站点-FBA-A-B,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333381, 201,'1站点-FBA-B-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333382, 201,'1站点-FBA-B-B,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333383, 202, '1站点-FBA-A-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333384, 203, '2站点-FBA-A-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333385, 203, '2站点-FBA-A-B,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333386, 204, '2站点-FBA-B-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333387, 204, '2站点-FBA-B-B,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (3333388, 205, '2站点-非FBA-A-A,存储区', 1, 'ALL', 'STORAGE', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444479, 200,'1站点-FBA-A-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444480, 200,'1站点-FBA-A-B,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444481, 201,'1站点-FBA-B-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444482, 201,'1站点-FBA-B-B,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444483, 202, '1站点-FBA-A-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444484, 203, '2站点-FBA-A-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444485, 203, '2站点-FBA-A-B,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444486, 204, '2站点-FBA-B-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444487, 204, '2站点-FBA-B-B,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); INSERT INTO `zone`(`id`, `warehouse_id`, `name`, `rank`, `product_property`, `type`, `status`) VALUES (4444488, 205, '2站点-非FBA-A-A,发货区', 1, 'ALL', 'DELIVERY', 'ACTIVE'); -- ---------------------------- -- Records of aisle -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112185, 1111279, '1站点-FBA-A-A-A,RECEIVE', 1, 'ASC', 1000011, 1900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112186, 1111279, '1站点-FBA-A-A-B,RECEIVE', 1, 'ASC', 1000012, 1900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112187, 1111280, '1站点-FBA-A-B-A,RECEIVE', 1, 'ASC', 1000021, 1900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112188, 1111280, '1站点-FBA-A-B-B,RECEIVE', 1, 'ASC', 1000022, 1900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112189, 1111281, '1站点-FBA-B-A-A,RECEIVE', 1, 'ASC', 1000031, 1900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112190, 1111281, '1站点-FBA-B-A-B,RECEIVE', 1, 'ASC', 1000032, 1900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112191, 1111282, '1站点-FBA-B-B-A,RECEIVE', 1, 'ASC', 1000041, 1900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112192, 1111282, '1站点-FBA-B-B-B,RECEIVE', 1, 'ASC', 1000042, 1900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112193, 1111283, '1站点-非FBA-A-A,RECEIVE', 1, 'ASC', 0118801, 0198801, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112194, 1111284, '2站点-FBA-A-A-A,RECEIVE', 1, 'ASC', 1000011, 1900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112195, 1111284, '2站点-FBA-A-A-B,RECEIVE', 1, 'ASC', 1000012, 1900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112196, 1111285, '2站点-FBA-A-B-A,RECEIVE', 1, 'ASC', 1000021, 1900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112197, 1111285, '2站点-FBA-A-B-B,RECEIVE', 1, 'ASC', 1000022, 1900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112198, 1111286, '2站点-FBA-B-A-A,RECEIVE', 1, 'ASC', 1000031, 1900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112199, 1111286, '2站点-FBA-B-A-B,RECEIVE', 1, 'ASC', 1000032, 1900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112200, 1111287, '2站点-FBA-B-B-A,RECEIVE', 1, 'ASC', 1000041, 1900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112201, 1111287, '2站点-FBA-B-B-B,RECEIVE', 1, 'ASC', 1000042, 1900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (11112202, 1111288, '2站点-非FBA-A-A,RECEIVE', 1, 'ASC', 0118802, 0198802, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222185, 2222279, '1站点-FBA-A-A-A,CHECK', 1, 'ASC', 2000011, 2900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222186, 2222279, '1站点-FBA-A-A-B,CHECK', 1, 'ASC', 2000012, 2900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222187, 2222280, '1站点-FBA-A-B-A,CHECK', 1, 'ASC', 2000021, 2900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222188, 2222280, '1站点-FBA-A-B-B,CHECK', 1, 'ASC', 2000022, 2900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222189, 2222281, '1站点-FBA-B-A-A,CHECK', 1, 'ASC', 2000031, 2900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222190, 2222281, '1站点-FBA-B-A-B,CHECK', 1, 'ASC', 2000032, 2900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222191, 2222282, '1站点-FBA-B-B-A,CHECK', 1, 'ASC', 2000041, 2900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222192, 2222282, '1站点-FBA-B-B-B,CHECK', 1, 'ASC', 2000042, 2900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222193, 2222283, '1站点-非FBA-A-A,CHECK', 1, 'ASC', 0218801, 0298801, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222194, 2222284, '2站点-FBA-A-A-A,CHECK', 1, 'ASC', 2000011, 2900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222195, 2222284, '2站点-FBA-A-A-B,CHECK', 1, 'ASC', 2000012, 2900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222196, 2222285, '2站点-FBA-A-B-A,CHECK', 1, 'ASC', 2000021, 2900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222197, 2222285, '2站点-FBA-A-B-B,CHECK', 1, 'ASC', 2000022, 2900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222198, 2222286, '2站点-FBA-B-A-A,CHECK', 1, 'ASC', 2000031, 2900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222199, 2222286, '2站点-FBA-B-A-B,CHECK', 1, 'ASC', 2000032, 2900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222200, 2222287, '2站点-FBA-B-B-A,CHECK', 1, 'ASC', 2000041, 2900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222201, 2222287, '2站点-FBA-B-B-B,CHECK', 1, 'ASC', 2000042, 2900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (22222202, 2222288, '2站点-非FBA-A-A,CHECK', 1, 'ASC', 0218802, 0298802, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333185, 3333379, '1站点-FBA-A-A-A,STORAGE', 1, 'ASC', 3000011, 3900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333186, 3333379, '1站点-FBA-A-A-B,STORAGE', 1, 'ASC', 3000012, 3900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333187, 3333380, '1站点-FBA-A-B-A,STORAGE', 1, 'ASC', 3000021, 3900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333188, 3333380, '1站点-FBA-A-B-B,STORAGE', 1, 'ASC', 3000022, 3900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333189, 3333381, '1站点-FBA-B-A-A,STORAGE', 1, 'ASC', 3000031, 3900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333190, 3333381, '1站点-FBA-B-A-B,STORAGE', 1, 'ASC', 3000032, 3900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333191, 3333382, '1站点-FBA-B-B-A,STORAGE', 1, 'ASC', 3000041, 3900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333192, 3333382, '1站点-FBA-B-B-B,STORAGE', 1, 'ASC', 3000042, 3900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333193, 3333383, '1站点-非FBA-A-A,STORAGE', 1, 'ASC', 0318801, 0398801, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333194, 3333384, '2站点-FBA-A-A-A,STORAGE', 1, 'ASC', 3000011, 3900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333195, 3333384, '2站点-FBA-A-A-B,STORAGE', 1, 'ASC', 3000012, 3900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333196, 3333385, '2站点-FBA-A-B-A,STORAGE', 1, 'ASC', 3000021, 3900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333197, 3333385, '2站点-FBA-A-B-B,STORAGE', 1, 'ASC', 3000022, 3900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333198, 3333386, '2站点-FBA-B-A-A,STORAGE', 1, 'ASC', 3000031, 3900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333199, 3333386, '2站点-FBA-B-A-B,STORAGE', 1, 'ASC', 3000032, 3900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333200, 3333387, '2站点-FBA-B-B-A,STORAGE', 1, 'ASC', 3000041, 3900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333201, 3333387, '2站点-FBA-B-B-B,STORAGE', 1, 'ASC', 3000042, 3900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (33333202, 3333388, '2站点-非FBA-A-A,STORAGE', 1, 'ASC', 0318802, 0398802, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444185, 4444479, '1站点-FBA-A-A-A,DELIVERY', 1, 'ASC', 4000011, 4900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444186, 4444479, '1站点-FBA-A-A-B,DELIVERY', 1, 'ASC', 4000012, 4900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444187, 4444480, '1站点-FBA-A-B-A,DELIVERY', 1, 'ASC', 4000021, 4900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444188, 4444480, '1站点-FBA-A-B-B,DELIVERY', 1, 'ASC', 4000022, 4900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444189, 4444481, '1站点-FBA-B-A-A,DELIVERY', 1, 'ASC', 4000031, 4900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444190, 4444481, '1站点-FBA-B-A-B,DELIVERY', 1, 'ASC', 4000032, 4900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444191, 4444482, '1站点-FBA-B-B-A,DELIVERY', 1, 'ASC', 4000041, 4900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444192, 4444482, '1站点-FBA-B-B-B,DELIVERY', 1, 'ASC', 4000042, 4900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444193, 4444483, '1站点-非FBA-A-A,DELIVERY', 1, 'ASC', 0418801, 0498801, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444194, 4444484, '2站点-FBA-A-A-A,DELIVERY', 1, 'ASC', 4000011, 4900011, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444195, 4444484, '2站点-FBA-A-A-B,DELIVERY', 1, 'ASC', 4000012, 4900012, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444196, 4444485, '2站点-FBA-A-B-A,DELIVERY', 1, 'ASC', 4000021, 4900021, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444197, 4444485, '2站点-FBA-A-B-B,DELIVERY', 1, 'ASC', 4000022, 4900022, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444198, 4444486, '2站点-FBA-B-A-A,DELIVERY', 1, 'ASC', 4000031, 4900031, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444199, 4444486, '2站点-FBA-B-A-B,DELIVERY', 1, 'ASC', 4000032, 4900032, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444200, 4444487, '2站点-FBA-B-B-A,DELIVERY', 1, 'ASC', 4000041, 4900041, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444201, 4444487, '2站点-FBA-B-B-B,DELIVERY', 1, 'ASC', 4000042, 4900042, 'ACTIVE'); INSERT INTO `aisle`(`id`, `zone_id`, `name`, `rank`, `container_rank_type`, `from_container_reference`, `to_container_reference`, `status`) VALUES (44444202, 4444488, '2站点-非FBA-A-A,DELIVERY', 1, 'ASC', 0418802, 0498802, 'ACTIVE'); -- ---------------------------- -- Records of container Update Time V20210812 Grape -- ---------------------------- INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188062, 1188011, 2001, 1, 11112185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188063, 1188012, 2001, 1, 11112186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188064, 1188021, 2001, 1, 11112187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188065, 1188022, 2001, 1, 11112188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188066, 1188031, 2001, 1, 11112189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188067, 1188032, 2001, 1, 11112190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188068, 1188041, 2001, 1, 11112191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188069, 1188042, 2001, 1, 11112192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188070, 0118801, 2001, 1, 11112193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188071, 1188011, 2001, 1, 11112194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188072, 1188012, 2001, 1, 11112195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188073, 1188021, 2001, 1, 11112196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188074, 1188022, 2001, 1, 11112197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188075, 1188031, 2001, 1, 11112198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188076, 1188032, 2001, 1, 11112199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188077, 1188041, 2001, 1, 11112200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188078, 1188042, 2001, 1, 11112201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1188079, 0118801, 2001, 1, 11112202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289062, 1289011, 2002, 1, 11112185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289063, 1289012, 2002, 1, 11112186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289064, 1289021, 2002, 1, 11112187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289065, 1289022, 2002, 1, 11112188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289066, 1289031, 2002, 1, 11112189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289067, 1289032, 2002, 1, 11112190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289068, 1289041, 2002, 1, 11112191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289069, 1289042, 2002, 1, 11112192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289070, 0128901, 2002, 1, 11112193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289071, 1289011, 2002, 1, 11112194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289072, 1289012, 2002, 1, 11112195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289073, 1289021, 2002, 1, 11112196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289074, 1289022, 2002, 1, 11112197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289075, 1289031, 2002, 1, 11112198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289076, 1289032, 2002, 1, 11112199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289077, 1289041, 2002, 1, 11112200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289078, 1289042, 2002, 1, 11112201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1289079, 0128901, 2002, 1, 11112202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390062, 1390011, 2003, 1, 11112185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390063, 1390012, 2003, 1, 11112186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390064, 1390021, 2003, 1, 11112187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390065, 1390022, 2003, 1, 11112188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390066, 1390031, 2003, 1, 11112189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390067, 1390032, 2003, 1, 11112190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390068, 1390041, 2003, 1, 11112191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390069, 1390042, 2003, 1, 11112192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390070, 0139001, 2003, 1, 11112193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390071, 1390011, 2003, 1, 11112194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390072, 1390012, 2003, 1, 11112195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390073, 1390021, 2003, 1, 11112196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390074, 1390022, 2003, 1, 11112197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390075, 1390031, 2003, 1, 11112198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390076, 1390032, 2003, 1, 11112199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390077, 1390041, 2003, 1, 11112200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390078, 1390042, 2003, 1, 11112201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1390079, 0139001, 2003, 1, 11112202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491062, 1491011, 2004, 1, 11112185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491063, 1491012, 2004, 1, 11112186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491064, 1491021, 2004, 1, 11112187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491065, 1491022, 2004, 1, 11112188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491066, 1491031, 2004, 1, 11112189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491067, 1491032, 2004, 1, 11112190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491068, 1491091, 2004, 1, 11112191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491069, 1491042, 2004, 1, 11112192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491070, 0149101, 2004, 1, 11112193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491071, 1491011, 2004, 1, 11112194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491072, 1491012, 2004, 1, 11112195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491073, 1491021, 2004, 1, 11112196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491074, 1491022, 2004, 1, 11112197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491075, 1491031, 2004, 1, 11112198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491076, 1491032, 2004, 1, 11112199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491077, 1491041, 2004, 1, 11112200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491078, 1491042, 2004, 1, 11112201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (1491079, 0149101, 2004, 1, 11112202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188062, 2188011, 2001, 1, 22222185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188063, 2188012, 2001, 1, 22222186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188064, 2188021, 2001, 1, 22222187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188065, 2188022, 2001, 1, 22222188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188066, 2188031, 2001, 1, 22222189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188067, 2188032, 2001, 1, 22222190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188068, 2188041, 2001, 1, 22222191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188069, 2188042, 2001, 1, 22222192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188070, 0218801, 2001, 1, 22222193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188071, 2188011, 2001, 1, 22222194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188072, 2188012, 2001, 1, 22222195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188073, 2188021, 2001, 1, 22222196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188074, 2188022, 2001, 1, 22222197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188075, 2188031, 2001, 1, 22222198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188076, 2188032, 2001, 1, 22222199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188077, 2188041, 2001, 1, 22222200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188078, 2188042, 2001, 1, 22222201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2188079, 0218801, 2001, 1, 22222202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289062, 2289011, 2002, 1, 22222185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289063, 2289012, 2002, 1, 22222186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289064, 2289021, 2002, 1, 22222187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289065, 2289022, 2002, 1, 22222188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289066, 2289031, 2002, 1, 22222189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289067, 2289032, 2002, 1, 22222190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289068, 2289041, 2002, 1, 22222191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289069, 2289042, 2002, 1, 22222192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289070, 0228901, 2002, 1, 22222193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289071, 2289011, 2002, 1, 22222194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289072, 2289012, 2002, 1, 22222195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289073, 2289021, 2002, 1, 22222196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289074, 2289022, 2002, 1, 22222197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289075, 2289031, 2002, 1, 22222198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289076, 2289032, 2002, 1, 22222199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289077, 2289041, 2002, 1, 22222200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289078, 2289042, 2002, 1, 22222201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2289079, 0228901, 2002, 1, 22222202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390062, 2390011, 2003, 1, 22222185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390063, 2390012, 2003, 1, 22222186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390064, 2390021, 2003, 1, 22222187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390065, 2390022, 2003, 1, 22222188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390066, 2390031, 2003, 1, 22222189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390067, 2390032, 2003, 1, 22222190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390068, 2390041, 2003, 1, 22222191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390069, 2390042, 2003, 1, 22222192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390070, 0239001, 2003, 1, 22222193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390071, 2390011, 2003, 1, 22222194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390072, 2390012, 2003, 1, 22222195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390073, 2390021, 2003, 1, 22222196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390074, 2390022, 2003, 1, 22222197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390075, 2390031, 2003, 1, 22222198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390076, 2390032, 2003, 1, 22222199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390077, 2390041, 2003, 1, 22222200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390078, 2390042, 2003, 1, 22222201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2390079, 0239001, 2003, 1, 22222202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491062, 2491011, 2004, 1, 22222185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491063, 2491012, 2004, 1, 22222186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491064, 2491021, 2004, 1, 22222187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491065, 2491022, 2004, 1, 22222188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491066, 2491031, 2004, 1, 22222189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491067, 2491032, 2004, 1, 22222190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491068, 2491091, 2004, 1, 22222191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491069, 2491042, 2004, 1, 22222192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491070, 0249101, 2004, 1, 22222193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491071, 2491011, 2004, 1, 22222194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491072, 2491012, 2004, 1, 22222195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491073, 2491021, 2004, 1, 22222196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491074, 2491022, 2004, 1, 22222197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491075, 2491031, 2004, 1, 22222198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491076, 2491032, 2004, 1, 22222199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491077, 2491041, 2004, 1, 22222200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491078, 2491042, 2004, 1, 22222201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (2491079, 0249101, 2004, 1, 22222202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188062, 3188011, 2001, 1, 33333185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188063, 3188012, 2001, 1, 33333186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188064, 3188021, 2001, 1, 33333187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188065, 3188022, 2001, 1, 33333188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188066, 3188031, 2001, 1, 33333189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188067, 3188032, 2001, 1, 33333190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188068, 3188041, 2001, 1, 33333191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188069, 3188042, 2001, 1, 33333192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188070, 0318801, 2001, 1, 33333193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188071, 3188011, 2001, 1, 33333194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188072, 3188012, 2001, 1, 33333195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188073, 3188021, 2001, 1, 33333196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188074, 3188022, 2001, 1, 33333197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188075, 3188031, 2001, 1, 33333198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188076, 3188032, 2001, 1, 33333199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188077, 3188041, 2001, 1, 33333200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188078, 3188042, 2001, 1, 33333201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3188079, 0318801, 2001, 1, 33333202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289062, 3289011, 2002, 1, 33333185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289063, 3289012, 2002, 1, 33333186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289064, 3289021, 2002, 1, 33333187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289065, 3289022, 2002, 1, 33333188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289066, 3289031, 2002, 1, 33333189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289067, 3289032, 2002, 1, 33333190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289068, 3289041, 2002, 1, 33333191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289069, 3289042, 2002, 1, 33333192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289070, 0328901, 2002, 1, 33333193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289071, 3289011, 2002, 1, 33333194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289072, 3289012, 2002, 1, 33333195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289073, 3289021, 2002, 1, 33333196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289074, 3289022, 2002, 1, 33333197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289075, 3289031, 2002, 1, 33333198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289076, 3289032, 2002, 1, 33333199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289077, 3289041, 2002, 1, 33333200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289078, 3289042, 2002, 1, 33333201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3289079, 0328901, 2002, 1, 33333202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390062, 3390011, 2003, 1, 33333185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390063, 3390012, 2003, 1, 33333186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390064, 3390021, 2003, 1, 33333187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390065, 3390022, 2003, 1, 33333188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390066, 3390031, 2003, 1, 33333189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390067, 3390032, 2003, 1, 33333190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390068, 3390041, 2003, 1, 33333191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390069, 3390042, 2003, 1, 33333192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390070, 0339001, 2003, 1, 33333193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390071, 3390011, 2003, 1, 33333194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390072, 3390012, 2003, 1, 33333195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390073, 3390021, 2003, 1, 33333196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390074, 3390022, 2003, 1, 33333197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390075, 3390031, 2003, 1, 33333198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390076, 3390032, 2003, 1, 33333199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390077, 3390041, 2003, 1, 33333200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390078, 3390042, 2003, 1, 33333201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3390079, 0339001, 2003, 1, 33333202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491062, 3491011, 2004, 1, 33333185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491063, 3491012, 2004, 1, 33333186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491064, 3491021, 2004, 1, 33333187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491065, 3491022, 2004, 1, 33333188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491066, 3491031, 2004, 1, 33333189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491067, 3491032, 2004, 1, 33333190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491068, 3491091, 2004, 1, 33333191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491069, 3491042, 2004, 1, 33333192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491070, 0349101, 2004, 1, 33333193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491071, 3491011, 2004, 1, 33333194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491072, 3491012, 2004, 1, 33333195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491073, 3491021, 2004, 1, 33333196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491074, 3491022, 2004, 1, 33333197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491075, 3491031, 2004, 1, 33333198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491076, 3491032, 2004, 1, 33333199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491077, 3491041, 2004, 1, 33333200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491078, 3491042, 2004, 1, 33333201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (3491079, 0349101, 2004, 1, 33333202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188062, 4188011, 2001, 1, 44444185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188063, 4188012, 2001, 1, 44444186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188064, 4188021, 2001, 1, 44444187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188065, 4188022, 2001, 1, 44444188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188066, 4188031, 2001, 1, 44444189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188067, 4188032, 2001, 1, 44444190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188068, 4188041, 2001, 1, 44444191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188069, 4188042, 2001, 1, 44444192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188070, 0418801, 2001, 1, 44444193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188071, 4188011, 2001, 1, 44444194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188072, 4188012, 2001, 1, 44444195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188073, 4188021, 2001, 1, 44444196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188074, 4188022, 2001, 1, 44444197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188075, 4188031, 2001, 1, 44444198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188076, 4188032, 2001, 1, 44444199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188077, 4188041, 2001, 1, 44444200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188078, 4188042, 2001, 1, 44444201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4188079, 0418801, 2001, 1, 44444202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289062, 4289011, 2002, 1, 44444185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289063, 4289012, 2002, 1, 44444186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289064, 4289021, 2002, 1, 44444187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289065, 4289022, 2002, 1, 44444188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289066, 4289031, 2002, 1, 44444189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289067, 4289032, 2002, 1, 44444190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289068, 4289041, 2002, 1, 44444191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289069, 4289042, 2002, 1, 44444192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289070, 0428901, 2002, 1, 44444193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289071, 4289011, 2002, 1, 44444194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289072, 4289012, 2002, 1, 44444195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289073, 4289021, 2002, 1, 44444196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289074, 4289022, 2002, 1, 44444197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289075, 4289031, 2002, 1, 44444198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289076, 4289032, 2002, 1, 44444199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289077, 4289041, 2002, 1, 44444200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289078, 4289042, 2002, 1, 44444201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4289079, 0428901, 2002, 1, 44444202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390062, 4390011, 2003, 1, 44444185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390063, 4390012, 2003, 1, 44444186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390064, 4390021, 2003, 1, 44444187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390065, 4390022, 2003, 1, 44444188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390066, 4390031, 2003, 1, 44444189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390067, 4390032, 2003, 1, 44444190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390068, 4390041, 2003, 1, 44444191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390069, 4390042, 2003, 1, 44444192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390070, 0439001, 2003, 1, 44444193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390071, 4390011, 2003, 1, 44444194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390072, 4390012, 2003, 1, 44444195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390073, 4390021, 2003, 1, 44444196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390074, 4390022, 2003, 1, 44444197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390075, 4390031, 2003, 1, 44444198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390076, 4390032, 2003, 1, 44444199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390077, 4390041, 2003, 1, 44444200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390078, 4390042, 2003, 1, 44444201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4390079, 0439001, 2003, 1, 44444202, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491062, 4491011, 2004, 1, 44444185, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491063, 4491012, 2004, 1, 44444186, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491064, 4491021, 2004, 1, 44444187, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491065, 4491022, 2004, 1, 44444188, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491066, 4491031, 2004, 1, 44444189, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491067, 4491032, 2004, 1, 44444190, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491068, 4491091, 2004, 1, 44444191, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491069, 4491042, 2004, 1, 44444192, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491070, 0449101, 2004, 1, 44444193, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491071, 4491011, 2004, 1, 44444194, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491072, 4491012, 2004, 1, 44444195, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491073, 4491021, 2004, 1, 44444196, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491074, 4491022, 2004, 1, 44444197, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491075, 4491031, 2004, 1, 44444198, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491076, 4491032, 2004, 1, 44444199, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491077, 4491041, 2004, 1, 44444200, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491078, 4491042, 2004, 1, 44444201, 'ACTIVE'); INSERT INTO `container`(`id`, `reference`, `container_type_id`, `rank`, `aisle_id`, `status`) VALUES (4491079, 0449101, 2004, 1, 44444202, 'ACTIVE'); -- ---------------------------- -- Records of product -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996130, 1, NULL, NULL, '紫色诱惑', 'yuhao0', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.500, 1.000, NULL, 0.00, 0.00, '1-1996130', '1-1996130', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-11 05:45:23', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996131, 1, NULL, NULL, '紫色诱惑', 'yuhao1', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.500, 1.000, NULL, 0.00, 0.00, '1-1996131', '1-1996131', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-10 08:43:25', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996132, 1, NULL, NULL, '紫色诱惑', 'yuhao2', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.500, 1.000, NULL, 0.00, 0.00, '1-1996132', '1-1996132', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-10 08:43:25', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996133, 1, NULL, NULL, '紫色诱惑', 'yuhao3', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.500, 1.000, NULL, 0.00, 0.00, '1-1996133', '1-1996133', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-10 08:43:25', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996134, 1, NULL, NULL, '紫色诱惑', 'yuhao4', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.500, 1.000, NULL, 0.00, 0.00, '1-1996134', '1-1996134', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-10 08:43:25', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); INSERT INTO `product` (`id`, `client_id`, `crossing_harbor_name_id`, `customs_clear_name_id`, `name`, `name_customs`, `material`, `usage`, `brand`, `url`, `color`, `model`, `country_of_origin`, `shape_type`, `product_risk_level`, `customs_value_level`, `customs_category_id`, `commodity_code`, `note`, `description`, `price_customs_import`, `price_customs_export`, `price_customs_export_internal`, `sales_price`, `handling_fee`, `delivery_fee_adjustment`, `client_ref`, `company_ref`, `weight`, `length`, `width`, `depth`, `dimension_lock`, `live_stock`, `frozen_stock`, `pending_stock`, `low_stock_level`, `inventory_time`, `is_use_delivery_cost`, `is_no_handling_fee`, `is_vip`, `is_dynamic_warehouse_unsalable_product`, `is_need_to_record_sn`, `last_info_check_time`, `last_stock_update_time`, `last_in_stock_time`, `last_out_stock_time`, `last_update_status_time`, `create_time`, `update_time`, `note_internal`, `dynamic_warehouse_stock_sequence`, `return_action`, `status`) VALUES (1996135, 1, NULL, NULL, '紫色诱惑', 'yuhao5', '布匹', '穿戴', '紫光科技', 'https://gimg2.baidu.com/image_search/src=http%3A%2F%2Fimg1.szhk.com%2FImage%2F2016%2F09%2F03%2F201609031137460811.jpg&refer=http%3A%2F%2Fimg1.szhk.com&app=2002&size=f9999,10000&q=a80&n=0&g=0n&fmt=jpeg', '紫色', '130', NULL, 'NORMAL_SHAPE', 'LOW', 'LOW', 6, NULL, NULL, NULL, NULL, 1.5000, 1.000, NULL, 0.00, 0.00, '1-1996135', '1-1996135', 10.00, 8.00, 4.00, 2.00, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, '2021-08-02 08:27:48', '2021-08-02 08:04:15', '2021-08-10 08:43:25', '', 'DYNAMIC_WAREHOUSE_STOCK_FIRST', NULL, 'ACTIVE'); -- ---------------------------- -- Records of container_product_transaction -- Update Time V20210812 Grape -- ---------------------------- INSERT INTO `container_product_transaction` (`id`, `container_id`, `product_id`, `quantity`, `consignment_id`, `warehouse_dispatch_id`, `client_dispatch_id`, `warehouse_transfer_id`, `additional_service_id`, `company_user_id`, `note`, `update_time`, `type`) VALUES (5060, 1188071, 1996130, 1000, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2021-09-10 07:23:06', 'LOCAL_RETURN_STOCK_IN'); INSERT INTO `container_product_transaction` (`id`, `container_id`, `product_id`, `quantity`, `consignment_id`, `warehouse_dispatch_id`, `client_dispatch_id`, `warehouse_transfer_id`, `additional_service_id`, `company_user_id`, `note`, `update_time`, `type`) VALUES (5061, 1188079, 1996130, 1000, NULL, NULL, NULL, NULL, NULL, 1, NULL, '2021-09-10 09:17:39', 'LOCAL_RETURN_STOCK_IN'); |
测试点
1.不判断发货单当前状态，发货单内发货箱存在以上架，则发货单状态更新为部分已上架
2.发货单内所以发货单已上架，则发货单状态更新为已上架
测试结果
测试点描述 | 结果截图 | 问题描述 |
|---|---|---|
.不判断发货单当前状态，发货单内发货箱存在以上架，则发货单状态更新为部分已上架 |  发货箱内产品上架，状态不会更新  发货箱内产品上架，状态会正常更新到目的仓部分已上架
|
|
发货单内所以发货单已上架，则发货单状态更新为已上架 |  非已收货状态，发货单所有发货箱上架后，发货单状态更新为目的仓已上架
|
|
问题根据
问题描述 | 问题截图 | 结果跟进 |
|---|---|---|
|
|
|
|
|
|
勇于舍弃那些不属于你的东西。
我首先舍弃的是银行卡，包括信用卡和储蓄卡。
我在瞎折腾。
再说说我买的衣服。
终于有一天我看了《断舍离》这本书，开始决定扔东西了。
当年用淘宝是为了省钱，没想到更费钱了……