| | |
|---|
| | | return null; |
|---|
| | | } |
|---|
| | | Long warehouseId = inventory.getWarehouseId(); |
|---|
| | | Integer warehouseType = inventory.getWarehouseType(); |
|---|
| | | |
|---|
| | | formInventoryVO.setBusinessFormCode(inventory.getBusinessFormCode()); |
|---|
| | | formInventoryVO.setBusinessFormName(inventory.getBusinessFormName()); |
|---|
| | | formInventoryVO.setWarehouseId(warehouseId); |
|---|
| | | formInventoryVO.setWarehouseName(inventory.getWarehouseName()); |
|---|
| | | |
|---|
| | | // 统计仓库内的物品 |
|---|
| | | String sql = |
|---|
| | | "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"; |
|---|
| | | "SELECT distinct bgt.id baseGoodsTemplateId,bgm.id baseGoodsModelId,bgt.GOODS_NAME goodsTemplateName,bgm.MODEL_NAME baseGoodsModelsName," |
|---|
| | | + "bgt.CLASSIFICATION TYPE,bgm.UNIT FROM l_wh_goods g " |
|---|
| | | + "LEFT JOIN base_goods_template bgt ON g.BASE_GOODS_TEMPLATE_ID = bgt.ID " |
|---|
| | | + "LEFT JOIN base_goods_models bgm ON bgm.GOODS_TEMPLATES_ID = bgt.id WHERE " |
|---|
| | | + "WAREHOUSE_ID = :warehouseId "; |
|---|
| | | HashMap<String, Object> param = new HashMap<>(); |
|---|
| | | param.put("agencyId", inventory.getAgencyId()); |
|---|
| | | param.put("warehouseId", warehouseId); |
|---|
| | | |
|---|
| | | // String sql = |
|---|
| | | // "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<>(); |
|---|
| | | // param.put("agencyId", inventory.getAgencyId()); |
|---|
| | | List<Map<String, Object>> result = this.select(sql, param, new MapperUtil()); |
|---|
| | | List<FormInventoryGoodsVO> goodsVOList = Lists.newArrayList(); |
|---|
| | | result.forEach(item -> { |
|---|
