| | |
|---|
| | | formInventoryVO.setWarehouseName(inventory.getWarehouseName()); |
|---|
| | | |
|---|
| | | String sql = |
|---|
| | | "select bgt.id baseGoodsTemplateId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT " |
|---|
| | | "select bgt.id baseGoodsTemplateId,bgm.id baseGoodsModelId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName,bgt.CLASSIFICATION type,bgm.UNIT " |
|---|
| | | + "from base_goods_models bgm left join base_goods_template bgt on bgm.GOODS_TEMPLATES_ID = bgt.id " |
|---|
| | | + "where bgt.AGENCY_ID = :agencyId"; |
|---|
| | | HashMap<String, Object> param = new HashMap<>(); |
|---|
| | |
|---|
| | | result.forEach(item -> { |
|---|
| | | FormInventoryGoodsVO baseGoodsModels = MapUtils.convertMapToObj(item, FormInventoryGoodsVO.class); |
|---|
| | | List<Long> warehouseIds = new ArrayList<>(Arrays.asList(warehouseId)); |
|---|
| | | int inventoryCount = |
|---|
| | | this.lWhGoodsService.queryGoodsModelNum(warehouseType, warehouseIds, baseGoodsModels.getId(), 1, null); |
|---|
| | | int inventoryCount = this.lWhGoodsService.queryGoodsModelNum(warehouseType, warehouseIds, |
|---|
| | | baseGoodsModels.getBaseGoodsModelId(), 1, null); |
|---|
| | | baseGoodsModels.setInventoryCount(inventoryCount); |
|---|
| | | goodsVOList.add(baseGoodsModels); |
|---|
| | | }); |
|---|
