KKSU
2024-02-21 0dded054a1744e032c30bc5b10fda1f2c94a4099
src/main/java/cc/mrbird/febs/mall/service/impl/AdminMallGoodsService.java
@@ -2,15 +2,19 @@
import cc.mrbird.febs.common.entity.FebsResponse;
import cc.mrbird.febs.common.entity.QueryRequest;
import cc.mrbird.febs.common.utils.AppContants;
import cc.mrbird.febs.common.utils.RedisUtils;
import cc.mrbird.febs.mall.conversion.MallGoodsConversion;
import cc.mrbird.febs.mall.dto.*;
import cc.mrbird.febs.mall.entity.*;
import cc.mrbird.febs.mall.mapper.*;
import cc.mrbird.febs.mall.service.IAdminMallGoodsService;
import cc.mrbird.febs.mall.vo.*;
import cn.hutool.core.bean.BeanUtil;
import cn.hutool.core.collection.CollUtil;
import cn.hutool.core.util.ObjectUtil;
import cn.hutool.core.util.StrUtil;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
@@ -24,6 +28,7 @@
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import java.util.stream.Collectors;
@Slf4j
@Service
@@ -37,6 +42,9 @@
    private final MallGoodsStyleMapper mallGoodsStyleMapper;
    private final MallGoodsImagesMapper mallGoodsImagesMapper;
    private final MallShoppingCartMapper mallShoppingCartMapper;
    private final RedisUtils redisUtils;
    private final CjItemMapper cjItemMapper;
    private final CjInfoMapper cjInfoMapper;
    @Override
    public IPage<AdminMallGoodsVo> getCategoryListInPage(MallGoods mallGoods, QueryRequest request) {
@@ -72,40 +80,46 @@
                return new FebsResponse().fail().message("商品分类不能为空");
            }
            List<AddMallGoodsSkuDto> addSkus = addMallGoodsDto.getAddMallGoodsSkuDtos();
            if (CollUtil.isEmpty(addSkus)) {
                return new FebsResponse().fail().message("商品规格不能为空");
            }
            for (AddMallGoodsSkuDto addSku : addSkus) {
                String skuName = addSku.getSkuName();
                if (StrUtil.isEmpty(skuName)) {
                    return new FebsResponse().fail().message("商品规格名称不能为空");
            if (addMallGoodsDto.getIsSku() == 1) {
                List<AddMallGoodsSkuDto> addSkus = addMallGoodsDto.getAddMallGoodsSkuDtos();
                if (CollUtil.isEmpty(addSkus)) {
                    return new FebsResponse().fail().message("商品规格不能为空");
                }
                String skuImage = addSku.getSkuImage();
                if (StrUtil.isEmpty(skuImage)) {
                    return new FebsResponse().fail().message("商品规格图片不能为空");
                }
                Integer skuVolume = addSku.getSkuVolume() == null ? 0 : addSku.getSkuVolume();
                if (skuVolume < 0) {
                    return new FebsResponse().fail().message("商品规格销售数量不能小于0");
                }
                Integer stock = addSku.getStock() == null ? 0 : addSku.getStock();
                if (stock < 0) {
                    return new FebsResponse().fail().message("商品规格库存必须大于0");
                }
                String originalPrice = addSku.getOriginalPrice();
                if (StrUtil.isEmpty(originalPrice)) {
                    return new FebsResponse().fail().message("商品规格原价不能为空");
                }
                String presentPrice = addSku.getPresentPrice();
                if (StrUtil.isEmpty(presentPrice)) {
                    return new FebsResponse().fail().message("商品规格现价不能为空");
                for (AddMallGoodsSkuDto addSku : addSkus) {
                    String skuName = addSku.getSkuName();
                    if (StrUtil.isEmpty(skuName)) {
                        return new FebsResponse().fail().message("商品规格名称不能为空");
                    }
                    String skuImage = addSku.getSkuImage();
                    if (StrUtil.isEmpty(skuImage)) {
                        return new FebsResponse().fail().message("商品规格图片不能为空");
                    }
                    Integer skuVolume = addSku.getSkuVolume() == null ? 0 : addSku.getSkuVolume();
                    if (skuVolume < 0) {
                        return new FebsResponse().fail().message("商品规格销售数量不能小于0");
                    }
                    Integer stock = addSku.getStock() == null ? 0 : addSku.getStock();
                    if (stock < 0) {
                        return new FebsResponse().fail().message("商品规格库存必须大于0");
                    }
                    String originalPrice = addSku.getOriginalPrice();
                    if (StrUtil.isEmpty(originalPrice)) {
                        return new FebsResponse().fail().message("商品规格原价不能为空");
                    }
                    String presentPrice = addSku.getPresentPrice();
                    if (StrUtil.isEmpty(presentPrice)) {
                        return new FebsResponse().fail().message("商品规格现价不能为空");
                    }
                }
            }
        }
        //新增商品
        MallGoods mallGoods = MallGoodsConversion.INSTANCE.dtoToEntity(addMallGoodsDto);
        mallGoods.setIsSale(MallGoods.ISSALE_STATUS_DISABLED);
        if (mallGoods.getHasCarriage() == 2) {
            mallGoods.setCarriage(BigDecimal.ZERO);
        }
        mallGoodsMapper.insert(mallGoods);
        String thumbs = addMallGoodsDto.getThumbs();
@@ -128,6 +142,27 @@
            return new FebsResponse().success().message("添加成功");
        }
        // 单规格
        if (addMallGoodsDto.getIsSku() == 2) {
            MallGoodsStyle style = new MallGoodsStyle();
            style.setGoodsId(mallGoods.getId());
            style.setName(mallGoods.getGoodsName());
            mallGoodsStyleMapper.insert(style);
            MallGoodsSku sku = new MallGoodsSku();
            sku.setGoodsId(mallGoods.getId());
            sku.setSkuImage(mallGoods.getThumb());
            sku.setSkuName(mallGoods.getGoodsName());
            sku.setCostPrice(mallGoods.getCostPrice());
            sku.setPresentPrice(new BigDecimal(mallGoods.getPresentPrice()));
            sku.setOriginalPrice(new BigDecimal(mallGoods.getOriginalPrice()));
            sku.setSkuVolume(mallGoods.getVolume());
            sku.setStock(mallGoods.getStock());
            sku.setStyleId(style.getId());
            mallGoodsSkuMapper.insert(sku);
            return new FebsResponse().success().message("添加成功");
        }
        List<AddMallGoodsSkuDto> addMallGoodsSkuDtos = addMallGoodsDto.getAddMallGoodsSkuDtos();
        Set<String> styles = new HashSet<>();
@@ -145,7 +180,6 @@
                mallGoodsStyleMapper.insert(mallGoodsStyle);
            }
        }
        if (CollUtil.isNotEmpty(addMallGoodsSkuDtos)) {
            for (AddMallGoodsSkuDto addMallGoodsSkuDto : addMallGoodsSkuDtos) {
@@ -233,6 +267,17 @@
    }
    @Override
    public MallGoods selectGoodsById(long id) {
        MallGoods mallGoods = mallGoodsMapper.selectById(id);
        List<MallGoodsSku> skus = mallGoodsSkuMapper.selectSkuByGoodsId(mallGoods.getId());
        List<String> thumbs = mallGoodsImagesMapper.selectByGoodId(mallGoods.getId());
        mallGoods.setImages(thumbs);
        mallGoods.setSkus(skus);
        return mallGoods;
    }
    @Override
    @Transactional
    public FebsResponse updateMallGoods(MallGoodsUpdateDto mallGoodsUpdateDto) {
        String goodsName = mallGoodsUpdateDto.getGoodsName();
@@ -251,58 +296,65 @@
        if (mallGoodsByGoodsNo > 0) {
            return new FebsResponse().fail().message("商品编号不能重复");
        }
        Long categoryId = mallGoodsUpdateDto.getCategoryId();
        if (ObjectUtil.isEmpty(categoryId)) {
            return new FebsResponse().fail().message("商品分类不能为空");
        }
        List<MailGoodsSkuDto> addSkus = mallGoodsUpdateDto.getMailGoodsSkuDto();
        if (CollUtil.isEmpty(addSkus)) {
            return new FebsResponse().fail().message("商品规格不能为空");
        }
        for (MailGoodsSkuDto addSku : addSkus) {
            String skuName = addSku.getSkuName();
            if (StrUtil.isEmpty(skuName)) {
                return new FebsResponse().fail().message("商品规格名称不能为空");
            }
            String skuImage = addSku.getSkuImage();
            if (StrUtil.isEmpty(skuImage)) {
                return new FebsResponse().fail().message("商品规格图片不能为空");
            }
            Integer skuVolume = addSku.getSkuVolume() == null ? 0 : addSku.getSkuVolume();
            if (skuVolume < 0) {
                return new FebsResponse().fail().message("商品规格销售数量不能小于0");
            }
            Integer stock = addSku.getStock() == null ? 0 : addSku.getStock();
            if (stock < 0) {
                return new FebsResponse().fail().message("商品规格库存必须大于0");
            }
            BigDecimal originalPrice = addSku.getOriginalPrice();
            if (originalPrice.compareTo(BigDecimal.ZERO) <= 0) {
                return new FebsResponse().fail().message("商品规格原价不能小于0");
            }
            BigDecimal presentPrice = addSku.getPresentPrice();
            if (presentPrice.compareTo(BigDecimal.ZERO) <= 0) {
                return new FebsResponse().fail().message("商品规格现价不能小于0");
        if (mallGoodsUpdateDto.getGoodsType() != 2) {
            Long categoryId = mallGoodsUpdateDto.getCategoryId();
            if (ObjectUtil.isEmpty(categoryId)) {
                return new FebsResponse().fail().message("商品分类不能为空");
            }
            if (mallGoodsUpdateDto.getIsSku() == 1) {
                List<MailGoodsSkuDto> addSkus = mallGoodsUpdateDto.getMailGoodsSkuDto();
                if (CollUtil.isEmpty(addSkus)) {
                    return new FebsResponse().fail().message("商品规格不能为空");
                }
                for (MailGoodsSkuDto addSku : addSkus) {
                    String skuName = addSku.getSkuName();
                    if (StrUtil.isEmpty(skuName)) {
                        return new FebsResponse().fail().message("商品规格名称不能为空");
                    }
                    String skuImage = addSku.getSkuImage();
                    if (StrUtil.isEmpty(skuImage)) {
                        return new FebsResponse().fail().message("商品规格图片不能为空");
                    }
                    Integer skuVolume = addSku.getSkuVolume() == null ? 0 : addSku.getSkuVolume();
                    if (skuVolume < 0) {
                        return new FebsResponse().fail().message("商品规格销售数量不能小于0");
                    }
                    Integer stock = addSku.getStock() == null ? 0 : addSku.getStock();
                    if (stock < 0) {
                        return new FebsResponse().fail().message("商品规格库存必须大于0");
                    }
                    BigDecimal originalPrice = addSku.getOriginalPrice();
                    if (originalPrice.compareTo(BigDecimal.ZERO) <= 0) {
                        return new FebsResponse().fail().message("商品规格原价不能小于0");
                    }
                    BigDecimal presentPrice = addSku.getPresentPrice();
                    if (presentPrice.compareTo(BigDecimal.ZERO) < 0) {
                        return new FebsResponse().fail().message("商品规格现价不能小于0");
                    }
                }
            }
        }
        //新增商品
        MallGoods mallGoods = mallGoodsMapper.selectById(mallGoodsUpdateDto.getId());
        mallGoods.setGoodsNo(mallGoodsUpdateDto.getGoodsNo());
        mallGoods.setGoodsName(mallGoodsUpdateDto.getGoodsName());
        mallGoods.setGoodsIntrodution(mallGoodsUpdateDto.getGoodsIntrodution());
        mallGoods.setUnit(mallGoodsUpdateDto.getUnit());
        mallGoods.setThumb(mallGoodsUpdateDto.getThumb());
        mallGoods.setGoodsDetails(mallGoodsUpdateDto.getGoodsDetails());
        mallGoods.setOriginalPrice(mallGoodsUpdateDto.getOriginalPrice());
        mallGoods.setCategoryId(mallGoodsUpdateDto.getCategoryId());
        mallGoods.setPresentPrice(mallGoodsUpdateDto.getPresentPrice());
        mallGoods.setIsHot(mallGoodsUpdateDto.getIsHot());
//        mallGoods.setIsSale(MallGoods.ISSALE_STATUS_DISABLED);
        // 若原来不为多规格或编辑后也不为多规格,则清空样式和规格
        if (mallGoods.getIsSku() == 2 || mallGoodsUpdateDto.getIsSku() == 2) {
            mallGoodsSkuMapper.deleteByGoodsId(mallGoods.getId());
            mallGoodsStyleMapper.deleteByGoodsId(mallGoods.getId());
        }
        BeanUtil.copyProperties(mallGoodsUpdateDto, mallGoods);
        if (mallGoodsUpdateDto.getHasCarriage() == 2) {
            mallGoods.setCarriage(BigDecimal.ZERO);
        }
        mallGoodsMapper.updateById(mallGoods);
        mallGoodsImagesMapper.deleteByGoodsId(mallGoodsUpdateDto.getId());
        String thumbs = mallGoodsUpdateDto.getThumbs();
        if (StrUtil.isNotEmpty(thumbs)) {
            List<String> imgs = StrUtil.splitTrim(thumbs, ",");
@@ -319,15 +371,56 @@
            }
        }
        if (mallGoodsUpdateDto.getGoodsType() == 2) {
            return new FebsResponse().success().message("编辑成功");
        }
        // 单规格
        if (mallGoodsUpdateDto.getIsSku() == 2) {
            MallGoodsStyle style = new MallGoodsStyle();
            style.setGoodsId(mallGoods.getId());
            style.setName(mallGoods.getGoodsName());
            mallGoodsStyleMapper.insert(style);
            MallGoodsSku sku = new MallGoodsSku();
            sku.setGoodsId(mallGoods.getId());
            sku.setSkuImage(mallGoods.getThumb());
            sku.setSkuName(mallGoods.getGoodsName());
            sku.setCostPrice(mallGoods.getCostPrice());
            sku.setPresentPrice(new BigDecimal(mallGoods.getPresentPrice()));
            sku.setOriginalPrice(new BigDecimal(mallGoods.getOriginalPrice()));
            sku.setSkuVolume(mallGoods.getVolume());
            sku.setStock(mallGoods.getStock());
            sku.setStyleId(style.getId());
            mallGoodsSkuMapper.insert(sku);
            return new FebsResponse().success().message("添加成功");
        }
        // 删除已存在sku
        List<Long> delSkuIds = mallGoodsUpdateDto.getDelSkuId();
        if (CollUtil.isNotEmpty(delSkuIds)) {
            mallGoodsSkuMapper.delSkuByIds(delSkuIds);
            // 如果该样式下sku全删除,则删除该样式
            List<MallGoodsStyle> styles = mallGoodsStyleMapper.selectByGoodsId(mallGoods.getId());
            for (MallGoodsStyle style : styles) {
                if (CollUtil.isEmpty(style.getSkus())) {
                    mallGoodsStyleMapper.deleteById(style.getId());
                }
            }
        }
        List<MailGoodsSkuDto> mailGoodsSkuDto = mallGoodsUpdateDto.getMailGoodsSkuDto();
        Set<String> styles = new HashSet<>();
        if (CollUtil.isNotEmpty(mailGoodsSkuDto)) {
            for (MailGoodsSkuDto addStyleDto : mailGoodsSkuDto) {
                if (ObjectUtil.isNotEmpty(addStyleDto.getDelLog())) {
                    mallGoodsSkuMapper.deleteById(addStyleDto.getId());
//                if (ObjectUtil.isNotEmpty(addStyleDto.getDelLog())) {
//                    mallGoodsSkuMapper.deleteById(addStyleDto.getId());
//                    mallShoppingCartMapper.deleteByGoodsIdAndSkuId(addStyleDto.getId(), addStyleDto.getGoodsId());
//                }
                    mallShoppingCartMapper.deleteByGoodsIdAndSkuId(addStyleDto.getId(), addStyleDto.getGoodsId());
                }
                if (ObjectUtil.isEmpty(addStyleDto.getStyleId())) {
                    MallGoodsStyle mallGoodsStyleSku = mallGoodsStyleMapper.selectByStyleName(addStyleDto.getStyleName(), mallGoods.getId());
                    if (ObjectUtil.isEmpty(mallGoodsStyleSku)) {
@@ -359,6 +452,7 @@
                        mallGoodsSku.setPresentPrice(addMallGoodsSkuDto.getPresentPrice());
                        mallGoodsSku.setStyleId(addMallGoodsSkuDto.getStyleId());
                        mallGoodsSku.setGoodsId(mallGoods.getId());
                        mallGoodsSku.setCostPrice(addMallGoodsSkuDto.getCostPrice());
                        mallGoodsSkuMapper.updateById(mallGoodsSku);
                    } else {
                        //新增商品规格
@@ -371,6 +465,7 @@
                        mallGoodsSku.setOriginalPrice(addMallGoodsSkuDto.getOriginalPrice());
                        mallGoodsSku.setPresentPrice(addMallGoodsSkuDto.getPresentPrice());
                        mallGoodsSku.setStyleId(mallGoodsStyleSku.getId());
                        mallGoodsSku.setCostPrice(addMallGoodsSkuDto.getCostPrice());
                        mallGoodsSku.setGoodsId(mallGoods.getId());
                        mallGoodsSkuMapper.insert(mallGoodsSku);
                    }
@@ -385,5 +480,51 @@
        return mallGoodsMapper.getAllGoodsTree();
    }
    @Override
    public FebsResponse goodsHot(Long id) {
        MallGoods mallGoods = mallGoodsMapper.selectById(id);
        if (ObjectUtil.isEmpty(mallGoods)) {
            return new FebsResponse().fail().message("商品不存在,请刷新当前页面");
        }
        mallGoods.setIsHot(MallGoods.ISHOT_STATE_YES);
        mallGoodsMapper.updateById(mallGoods);
        return new FebsResponse().success();
    }
    @Override
    public FebsResponse goodsNotHot(Long id) {
        MallGoods mallGoods = mallGoodsMapper.selectById(id);
        if (ObjectUtil.isEmpty(mallGoods)) {
            return new FebsResponse().fail().message("商品不存在,请刷新当前页面");
        }
        mallGoods.setIsHot(MallGoods.ISHOT_STATE_NO);
        mallGoodsMapper.updateById(mallGoods);
        return new FebsResponse().success();
    }
    @Override
    public IPage<TzInfo> getTzListInPage(TzInfo tzInfo, QueryRequest request) {
        Page<TzInfo> page = new Page<>(request.getPageNum(), request.getPageSize());
        IPage<TzInfo> adminMallGoodsVos = this.baseMapper.getTzListInPage(page, tzInfo);
        List<TzInfo> records = adminMallGoodsVos.getRecords();
        String kjNo = redisUtils.getString(AppContants.KJ_RECORD_NO);
        QueryWrapper<CjInfo> objectQueryWrapper = new QueryWrapper<>();
        objectQueryWrapper.eq("kj_no",kjNo);
        List<CjInfo> cjInfos = cjInfoMapper.selectList(objectQueryWrapper);
        List<Long> collect = cjInfos.stream().map(CjInfo::getId).collect(Collectors.toList());
        List<CjItem> cjItems = cjItemMapper.selectSumAmountByInfoId(collect);
        for(TzInfo tzInfo1 : records){
            List<CjItem> collect1 = cjItems.stream().filter(cjItem -> cjItem.getTzCode().equals(tzInfo1.getTzCode())).collect(Collectors.toList());
            if(CollUtil.isNotEmpty(collect1)){
                BigDecimal reduce = collect1.stream().map(CjItem::getAmount).reduce(BigDecimal.ZERO, BigDecimal::add);
                tzInfo1.setTzAmount(reduce);
            }else{
                tzInfo1.setTzAmount(BigDecimal.ZERO);
            }
        }
        return adminMallGoodsVos;
    }
}