SELECT stock.entruster_id, entruster.customer_name AS entruster_name, stock.supplier_id, supplier.customer_name AS supplier_name, stock.shipper_id, shipper.customer_name AS shipper_name, stock.sku_id, sku.sku_name, sku.sku_code, sku.sku_spec, sku.sku_model, stock.qa_state, stock.storage_code, stock.sku_pd, stock.batch_no, stock.pack_id, pack.pack_name, stock.piece_unit, unit.unit_name AS piece_unit_name, sum( IFNULL( stock.stock_qty, 0 ) ) AS stock_qty, sum( IFNULL( stock.stock_piece, 0 ) ) AS stock_piece, sum( IFNULL( stock.stock_volume, 0 ) ) AS stock_volume, sum( IFNULL( stock.stock_nweight, 0 ) ) AS stock_nweight, sum( IFNULL( stock.stock_gweight, 0 ) ) AS stock_gweight, sum( IFNULL( stock.plan_pick_qty, 0 ) ) AS plan_pick_qty, stock.str_attr_value_01, stock.str_attr_value_02, stock.str_attr_value_03, stock.str_attr_value_04, stock.str_attr_value_05, stock.str_attr_value_06, stock.str_attr_value_07, stock.str_attr_value_08, stock.str_attr_value_09, stock.str_attr_value_10, stock.num_attr_value_01, stock.num_attr_value_02, stock.num_attr_value_03, stock.num_attr_value_04, stock.num_attr_value_05, stock.date_attr_value_01, stock.date_attr_value_02, stock.date_attr_value_03, stock.date_attr_value_04, stock.date_attr_value_05, stock.put_date, stock.remark FROM w_stock_item stock LEFT JOIN b_customer supplier ON stock.supplier_id = supplier.customer_id, b_customer shipper, b_customer entruster, b_sku sku, b_pack pack, b_unit unit WHERE 1 = 1 AND stock.entruster_id = entruster.customer_id AND stock.shipper_id = shipper.customer_id AND stock.sku_id = sku.sku_id AND stock.pack_id = pack.pack_id AND stock.piece_unit = unit.unit_code AND stock.plan_pick_qty > 0 AND stock.deleted = 0 AND entruster.deleted = 0 AND sku.deleted = 0 AND pack.deleted = 0 AND unit.deleted = 0 AND stock.entruster_id = '1b1752279e5ff7c881d7adc0eddefd86' AND stock.warehouse_code = '0001' GROUP BY stock.entruster_id, stock.shipper_id, stock.supplier_id, stock.storage_code, stock.sku_id, sku.sku_spec, sku.sku_model, stock.sku_pd, stock.batch_no, stock.pack_id, stock.piece_unit

2周前