package com.consum.base.service.impl;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.response.GoodsTemplateCountVO;
import com.consum.base.service.UsingFormBackModelService;
import com.walker.jdbc.service.BaseServiceImpl;

/**
 * @author asus
 * @version 1.0
 * @description: 物品回收单
 * @date 2023/12/1 11:27
 */
@Service
public class UsingFormBackModelServiceImpl extends BaseServiceImpl implements UsingFormBackModelService {

    @Override
    public List<GoodsTemplateCountVO> getUsingCountByBusinessId(Long businessId) {
        List<GoodsTemplateCountVO> goodsTemplateCount = Lists.newArrayList();
        // 统计型号数量
        StringBuilder countSql =
            new StringBuilder("SELECT ufbg.BASE_GOODS_TEMPLATE_NAME,sum(ufbm.COUNTS) count,ufbm.UNIT "
                + "FROM using_form_back_goods ufbg "
                + "LEFT JOIN using_form_back_model ufbm ON ufbg.ID = ufbm.USING_FORM_BACK_GOODS_ID "
                + "where ufbg.USING_FORM_BACK_ID = :businessId group by ufbg.BASE_GOODS_TEMPLATE_ID ");
        Map<String, Object> paramMap = new HashMap<>();
        paramMap.put("businessId", businessId);
        List<Map<String, Object>> procureModelList = this.select(countSql.toString(), paramMap, new MapperUtil());
        for (Map<String, Object> map : procureModelList) {
            GoodsTemplateCountVO goodsTemplateCountVO = MapUtils.convertMapToObj(map, GoodsTemplateCountVO.class);
            goodsTemplateCount.add(goodsTemplateCountVO);
        }
        return goodsTemplateCount;
    }
}