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