| | |
|---|
| | | import com.consum.base.core.WhBusinessEnum; |
|---|
| | | import com.consum.base.core.utils.MapUtils; |
|---|
| | | import com.consum.base.core.utils.MapperUtil; |
|---|
| | | import com.consum.base.pojo.dto.GoodModelInfoDTO; |
|---|
| | | import com.consum.base.pojo.response.GoodsTemplateCountVO; |
|---|
| | | import com.consum.base.service.LWhProcureModelService; |
|---|
| | | import com.consum.model.po.LWhProcureModel; |
|---|
| | |
|---|
| | | } |
|---|
| | | return goodsTemplateCount; |
|---|
| | | } |
|---|
| | | |
|---|
| | | @Override |
|---|
| | | public List<GoodModelInfoDTO> getGoodsModelListByBusinessId(Long businessId) { |
|---|
| | | // 查询型号列表信息 |
|---|
| | | List<GoodModelInfoDTO> goodsModelList = Lists.newArrayList(); |
|---|
| | | String sql = |
|---|
| | | "SELECT bgt.id baseGoodsTemplateId,pm.id,CATEGORY_ID,CATEGORY_NAME,GOODS_NAME baseGoodsName,pm.BASE_GOODS_MODELS_NAME,bgm.UNIT,COUNTS,total_amount " |
|---|
| | | + "FROM l_wh_procure_model pm LEFT JOIN base_goods_models bgm ON bgm.id = pm.BASE_GOODS_MODELS_ID " |
|---|
| | | + "LEFT JOIN base_goods_template bgt ON bgt.id = bgm.GOODS_TEMPLATES_ID " |
|---|
| | | + "WHERE pm.BUSINESS_ID = :businessId"; |
|---|
| | | Map<String, Object> paramMap = new HashMap<>(); |
|---|
| | | paramMap.put("businessId", businessId); |
|---|
| | | List<Map<String, Object>> modelList = select(sql, paramMap, new MapperUtil()); |
|---|
| | | modelList.forEach(item -> { |
|---|
| | | GoodModelInfoDTO goodsModelVO = MapUtils.convertMapToObj(item, GoodModelInfoDTO.class); |
|---|
| | | goodsModelList.add(goodsModelVO); |
|---|
| | | }); |
|---|
| | | return goodsModelList; |
|---|
| | | } |
|---|
| | | } |
|---|
