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;
|
|
/**
|
* @ClassName LWhFormScrappedGoodsService
|
*
|
* @Date 2023/10/30
|
* @Description
|
* @Version 1.0
|
**/
|
@Service
|
public class LWhFormScrappedGoodsServiceImpl extends BaseServiceImpl implements LWhFormScrappedGoodsService {
|
|
/**
|
* @Description 根据报废单id查询报废单物品
|
* @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;
|
}
|
}
|
