From 24843b5e25b3fbe95675fa1501a983598ffc3b78 Mon Sep 17 00:00:00 2001 From: jiangping <jp@doumee.com> Date: 星期四, 21 九月 2023 15:26:06 +0800 Subject: [PATCH] Merge branch 'dev' of http://139.186.142.91:10010/r/productDev/preselect into dev --- server/service/src/main/java/com/doumee/service/business/impl/GoodsServiceImpl.java | 61 +++++++++++++++--------------- 1 files changed, 30 insertions(+), 31 deletions(-) diff --git a/server/service/src/main/java/com/doumee/service/business/impl/GoodsServiceImpl.java b/server/service/src/main/java/com/doumee/service/business/impl/GoodsServiceImpl.java index 0f972e2..adf97ea 100644 --- a/server/service/src/main/java/com/doumee/service/business/impl/GoodsServiceImpl.java +++ b/server/service/src/main/java/com/doumee/service/business/impl/GoodsServiceImpl.java @@ -18,6 +18,8 @@ import com.doumee.dao.business.join.GoodsJoinMapper; import com.doumee.dao.business.model.*; import com.doumee.dao.business.model.dto.*; +import com.doumee.dao.system.model.SystemDepartment; +import com.doumee.service.CateParamSelectService; import com.doumee.service.business.BaseDataService; import com.doumee.service.business.GoodsService; import com.github.yulichang.wrapper.MPJLambdaWrapper; @@ -45,6 +47,7 @@ import java.net.URLEncoder; import java.nio.charset.Charset; import java.util.*; +import java.util.stream.Collectors; /** * 鍟嗗搧淇℃伅琛⊿ervice瀹炵幇 @@ -83,8 +86,10 @@ @Autowired private GoodsJoinMapper goodsJoinMapper; + + @Lazy @Autowired - private CateParamSelectMapper cateParamSelectMapper; + private CateParamSelectService cateParamSelectService; @Autowired private RedisTemplate redisTemplate; @@ -211,6 +216,7 @@ if(goodsParamList.size()>0){ goodsParamMapper.insertBatch(goodsParamList); } + cateParamSelectService.dealCateParamSelect(); }catch (Exception e){ e.printStackTrace(); }finally { @@ -646,13 +652,7 @@ Goods::getPrice,goods.getSPrice(),goods.getEPrice()); queryWrapper.orderByDesc(Goods::getId); List<Goods> goodsList = goodsJoinMapper.selectJoinList(Goods.class,queryWrapper); - String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() - + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); - goodsList.forEach(i->{ - i.setPrefixUrl(prefixUrl); - i.setMultifileList(multifileMapper.selectList(new QueryWrapper<Multifile>().eq("OBJ_ID",i.getId()).orderByAsc(" SORTNUM "))); - i.setGoodsParamList(goodsParamMapper.selectList(new QueryWrapper<GoodsParam>().eq("GOODS_ID",i.getId()).orderByAsc(" SORTNUM "))); - }); + this.dealGoodsMsg(goodsList); return goodsList; } @@ -1093,20 +1093,30 @@ .apply(!Objects.isNull(pageWrap.getModel()) && !Objects.isNull(pageWrap.getModel().getEPrice()), " t.PRICE <= "+pageWrap.getModel().getEPrice()+" "); queryWrapper.orderByDesc(Goods::getId); IPage<Goods> goodsIPage = goodsJoinMapper.selectJoinPage(page, Goods.class, queryWrapper); - String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() - + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); - goodsIPage.getRecords().forEach(i->{ - i.setCategoryImgurl(systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() - + systemDictDataBiz.queryByCode(Constants.OSS, Constants.CATEGORY_IMG).getCode() + i.getCategoryImgurl()); - i.setPrefixUrl(prefixUrl); - i.setMultifileList(multifileMapper.selectList(new QueryWrapper<Multifile>().eq("OBJ_ID",i.getId()).orderByAsc(" SORTNUM "))); - i.setGoodsParamList(goodsParamMapper.selectList(new QueryWrapper<GoodsParam>() - .eq("GOODS_ID",i.getId()) - .orderByAsc(" SORTNUM "))); - }); + this.dealGoodsMsg(goodsIPage.getRecords()); return PageData.from(goodsIPage); } + + + public void dealGoodsMsg(List<Goods> goodsList){ + String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() + + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); + String prefixUrlCategory = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() + + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); + List<Integer> integerList = goodsList.stream().map(Goods::getId).collect(Collectors.toList()); + List<Multifile> mFileList = multifileMapper.selectList(new QueryWrapper<Multifile>() + .in("OBJ_ID",integerList).eq("TYPE",Constants.ZERO)); + List<GoodsParam> goodsParamList = goodsParamMapper.selectList(new QueryWrapper<GoodsParam>() + .in("GOODS_ID",integerList) + .orderByAsc(" SORTNUM ")); + goodsList.forEach(i->{ + i.setCategoryImgurl(prefixUrlCategory + i.getCategoryImgurl()); + i.setPrefixUrl(prefixUrl); + i.setMultifileList(mFileList.stream().filter(s -> s.getObjId().equals(i.getId())).collect(Collectors.toList())); + i.setGoodsParamList(goodsParamList.stream().filter(s -> s.getGoodsId().equals(i.getId())).collect(Collectors.toList())); + }); + } @Override public List<Goods> findListForH5(GoodsRequest goodsRequest) { @@ -1139,18 +1149,7 @@ .apply(!Objects.isNull(goodsRequest) && !Objects.isNull(goodsRequest.getEPrice()), " t.PRICE <= "+goodsRequest.getEPrice()+" "); queryWrapper.orderByDesc(Goods::getId); List<Goods> goodsList = goodsJoinMapper.selectJoinList(Goods.class,queryWrapper); - String prefixUrl = systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() - + systemDictDataBiz.queryByCode(Constants.OSS, Constants.GOODS_IMG).getCode(); - goodsList.forEach(i->{ - i.setCategoryImgurl(systemDictDataBiz.queryByCode(Constants.OSS, Constants.RESOURCE_PATH).getCode() - + systemDictDataBiz.queryByCode(Constants.OSS, Constants.CATEGORY_IMG).getCode() + i.getCategoryImgurl()); - i.setPrefixUrl(prefixUrl); - i.setMultifileList(multifileMapper.selectList(new QueryWrapper<Multifile>().eq("OBJ_ID",i.getId()).orderByAsc(" SORTNUM "))); - i.setGoodsParamList(goodsParamMapper.selectList( - new QueryWrapper<GoodsParam>().eq("GOODS_ID",i.getId()) - .apply(" name in ( select cp.NAME from cate_param cp where cp.CATEGORY_ID = "+i.getCategoryId()+" and cp.ISSHOW = 1 and cp.ISDELETED = 0 and cp.STATUS = 0 ) ") - .orderByAsc(" SORTNUM "))); - }); + this.dealGoodsMsg(goodsList); return goodsList; } -- Gitblit v1.9.3