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;
    }
}