futian.liu
2023-12-08 583f0b0df83876e68e8729d9872f83af08b8ae27
consum-base/src/main/java/com/consum/base/service/impl/LWhFormScrappedGoodsServiceImpl.java
@@ -1,9 +1,16 @@
package com.consum.base.service.impl;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Objects;
import org.apache.commons.compress.utils.Lists;
import org.springframework.stereotype.Service;
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.service.LWhFormScrappedGoodsService;
import com.consum.model.po.LWhFormScrappedGoods;
import com.walker.jdbc.service.BaseServiceImpl;
@@ -23,9 +30,29 @@
     * @Author 卢庆阳
     * @Date 2023/11/2
     */
    @Override
    public List<LWhFormScrappedGoods> getByFormScrappedId(Long id) {
        LWhFormScrappedGoods scrappedGoods = new LWhFormScrappedGoods();
        scrappedGoods.setFormScrappedId(id);
        return this.select(scrappedGoods);
    }
    @Override
    public List<GoodModelInfoDTO> getScrappedGoodsByScrappedId(Long scrappedId) {
        String sql =
            "select fsg.id,CATEGORY_NAME,fsg.GOODS_TEMPLATE_NAME baseGoodsName,fsg.BASE_GOODS_MODELS_NAME,fsg.BASE_GOODS_TEMPLATE_ID,"
                + "fsg.UNIT,fsg.COUNTS,SCRAPPED_NAME from l_wh_form_scrapped_goods fsg left join base_goods_template bgt on "
                + "fsg.BASE_GOODS_TEMPLATE_ID = bgt.id where form_scrapped_id =:scrappedId ";
        Map<String, Object> param = new HashMap<>();
        param.put("scrappedId", scrappedId);
        List<Map<String, Object>> select = this.select(sql, param, new MapperUtil());
        List<GoodModelInfoDTO> goodModelInfoList = Lists.newArrayList();
        select.forEach(item -> {
            GoodModelInfoDTO goodModelInfoDTO = MapUtils.convertMapToObj(item, GoodModelInfoDTO.class);
            if (Objects.nonNull(goodModelInfoDTO)) {
                goodModelInfoList.add(goodModelInfoDTO);
            }
        });
        return goodModelInfoList;
    }
}