报废单导出金额信息

futian.liu

2023-12-05 87ff2a60723119530d071f6ed6b16fc2f3f023ca

 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java

@@ -1,8 +1,17 @@
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;
import org.springframework.stereotype.Service;

/**
 * @author asus
@@ -13,4 +22,22 @@
@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;
    }
}