package cc.mrbird.febs.mall.service.impl; import cc.mrbird.febs.common.entity.FebsResponse; import cc.mrbird.febs.common.entity.QueryRequest; 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 cn.hutool.json.JSONUtil; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import lombok.RequiredArgsConstructor; import lombok.extern.slf4j.Slf4j; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.math.BigDecimal; import java.util.ArrayList; import java.util.HashSet; import java.util.List; import java.util.Set; @Slf4j @Service @RequiredArgsConstructor @Transactional public class AdminMallGoodsService extends ServiceImpl implements IAdminMallGoodsService { private final MallGoodsCategoryMapper mallGoodsCategoryMapper; private final MallGoodsMapper mallGoodsMapper; private final MallGoodsSkuMapper mallGoodsSkuMapper; private final MallGoodsStyleMapper mallGoodsStyleMapper; private final MallGoodsImagesMapper mallGoodsImagesMapper; private final MallShoppingCartMapper mallShoppingCartMapper; @Override public IPage getCategoryListInPage(MallGoods mallGoods, QueryRequest request) { Page page = new Page<>(request.getPageNum(), request.getPageSize()); IPage adminMallGoodsVos = this.baseMapper.selectMallGoodsInPage(page, mallGoods); return adminMallGoodsVos; } @Override @Transactional public FebsResponse addMallGoods(AddMallGoodsDto addMallGoodsDto) { String goodsName = addMallGoodsDto.getGoodsName(); if (StrUtil.isEmpty(goodsName)) { return new FebsResponse().fail().message("商品名称不能为空"); } Integer mallGoodsByGoodsName = mallGoodsMapper.selectMallGoodsCountByGoodsName(goodsName); if (mallGoodsByGoodsName > 0) { return new FebsResponse().fail().message("商品名称不能重复"); } String goodsNo = addMallGoodsDto.getGoodsNo(); if (StrUtil.isEmpty(goodsNo)) { return new FebsResponse().fail().message("商品编号不能为空"); } Integer mallGoodsByGoodsNo = mallGoodsMapper.selectMallGoodsCountByGoodsNo(goodsNo); if (mallGoodsByGoodsNo > 0) { return new FebsResponse().fail().message("商品编号不能重复"); } // 付费商品 if (addMallGoodsDto.getGoodsType() != 2) { Long categoryId = addMallGoodsDto.getCategoryId(); if (ObjectUtil.isEmpty(categoryId)) { return new FebsResponse().fail().message("商品分类不能为空"); } if (addMallGoodsDto.getIsSku() == 1) { List 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("商品规格名称不能为空"); } 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(); if (StrUtil.isNotEmpty(thumbs)) { List imgs = StrUtil.splitTrim(thumbs, ","); if (CollUtil.isNotEmpty(imgs)) { int i = 1; for (String img : imgs) { MallGoodsImages mallGoodsImages = new MallGoodsImages(); mallGoodsImages.setGoodsId(mallGoods.getId()); mallGoodsImages.setImageUrl(img); mallGoodsImages.setSeq(i); mallGoodsImagesMapper.insert(mallGoodsImages); i++; } } } if (addMallGoodsDto.getGoodsType() == 2) { 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 addMallGoodsSkuDtos = addMallGoodsDto.getAddMallGoodsSkuDtos(); Set styles = new HashSet<>(); if (CollUtil.isNotEmpty(addMallGoodsSkuDtos)) { for (AddMallGoodsSkuDto addStyleDto : addMallGoodsSkuDtos) { styles.add(addStyleDto.getStyleName()); } } if (CollUtil.isNotEmpty(styles)) { for (String style : styles) { //新增样式 MallGoodsStyle mallGoodsStyle = new MallGoodsStyle(); mallGoodsStyle.setName(style); mallGoodsStyle.setGoodsId(mallGoods.getId()); mallGoodsStyleMapper.insert(mallGoodsStyle); } } if (CollUtil.isNotEmpty(addMallGoodsSkuDtos)) { for (AddMallGoodsSkuDto addMallGoodsSkuDto : addMallGoodsSkuDtos) { MallGoodsStyle mallGoodsStyleSku = mallGoodsStyleMapper.selectByStyleName(addMallGoodsSkuDto.getStyleName(), mallGoods.getId()); //新增商品规格 MallGoodsSku mallGoodsSku = new MallGoodsSku(); mallGoodsSku.setSkuName(addMallGoodsSkuDto.getSkuName()); mallGoodsSku.setSkuImage(addMallGoodsSkuDto.getSkuImage()); mallGoodsSku.setStock(addMallGoodsSkuDto.getStock() == null ? 0 : addMallGoodsSkuDto.getStock()); mallGoodsSku.setSkuVolume(addMallGoodsSkuDto.getSkuVolume() == null ? 0 : addMallGoodsSkuDto.getSkuVolume()); mallGoodsSku.setOriginalPrice(new BigDecimal(addMallGoodsSkuDto.getOriginalPrice())); mallGoodsSku.setPresentPrice(new BigDecimal(addMallGoodsSkuDto.getPresentPrice())); mallGoodsSku.setStyleId(mallGoodsStyleSku.getId()); mallGoodsSku.setCostPrice(addMallGoodsSkuDto.getCostPrice()); mallGoodsSku.setGoodsId(mallGoods.getId()); mallGoodsSkuMapper.insert(mallGoodsSku); } } return new FebsResponse().success().message("操作成功"); } @Override public FebsResponse upMallGoods(Long id) { MallGoods mallGoods = mallGoodsMapper.selectById(id); if (ObjectUtil.isEmpty(mallGoods)) { return new FebsResponse().fail().message("商品不存在,请刷新当前页面"); } mallGoods.setIsSale(MallGoods.ISSALE_STATUS_ENABLE); mallGoodsMapper.updateById(mallGoods); return new FebsResponse().success(); } @Override public FebsResponse downMallGoods(Long id) { MallGoods mallGoods = mallGoodsMapper.selectById(id); if (ObjectUtil.isEmpty(mallGoods)) { return new FebsResponse().fail().message("商品不存在,请刷新当前页面"); } mallGoods.setIsSale(MallGoods.ISSALE_STATUS_DISABLED); mallGoodsMapper.updateById(mallGoods); return new FebsResponse().success(); } @Override @Transactional public FebsResponse delMallGoods(Long id) { MallGoods mallGoods = mallGoodsMapper.selectById(id); if (ObjectUtil.isEmpty(mallGoods)) { return new FebsResponse().fail().message("商品不存在,请刷新当前页面"); } Integer isSale = mallGoods.getIsSale(); if (MallGoods.ISSALE_STATUS_DISABLED != isSale) { return new FebsResponse().fail().message("请先下架该商品"); } mallGoodsStyleMapper.deleteByGoodsId(id); mallGoodsSkuMapper.deleteByGoodsId(id); mallGoodsMapper.deleteById(mallGoods); mallShoppingCartMapper.deleteByGoodsId(id); return new FebsResponse().success(); } @Override public AdminMailGoodsDetailVo getMallGoodsInfoById(long id) { AdminMailGoodsDetailVo adminMailGoodsDetailVo = mallGoodsMapper.selectMallGoodsInfoById(id); List adminMailGoodsSkuDetailVos = mallGoodsSkuMapper.selectByGoodId(id); adminMailGoodsDetailVo.setMailGoodsSkuDetailVo(adminMailGoodsSkuDetailVos); return adminMailGoodsDetailVo; } @Override public AdminMailGoodsUpdateVo getMallGoodsUpdateInfoById(long id) { AdminMailGoodsUpdateVo adminMailGoodsUpdateVo = mallGoodsMapper.getMallGoodsUpdateInfoById(id); List adminMailGoodsSkuDetailVos = mallGoodsSkuMapper.selectByGoodId(id); if (CollUtil.isNotEmpty(adminMailGoodsSkuDetailVos)) { adminMailGoodsUpdateVo.setMailGoodsSkuDetailVo(adminMailGoodsSkuDetailVos); } List adminMailGoodsImagesVos = mallGoodsImagesMapper.selectByGoodId(id); if (CollUtil.isNotEmpty(adminMailGoodsImagesVos)) { adminMailGoodsUpdateVo.setMailGoodsImagesVo(adminMailGoodsImagesVos); } return adminMailGoodsUpdateVo; } @Override public MallGoods selectGoodsById(long id) { MallGoods mallGoods = mallGoodsMapper.selectById(id); List skus = mallGoodsSkuMapper.selectSkuByGoodsId(mallGoods.getId()); List thumbs = mallGoodsImagesMapper.selectByGoodId(mallGoods.getId()); mallGoods.setImages(thumbs); mallGoods.setSkus(skus); return mallGoods; } @Override @Transactional public FebsResponse updateMallGoods(MallGoodsUpdateDto mallGoodsUpdateDto) { String goodsName = mallGoodsUpdateDto.getGoodsName(); if (StrUtil.isEmpty(goodsName)) { return new FebsResponse().fail().message("商品名称不能为空"); } Integer mallGoodsByGoodsName = mallGoodsMapper.selectMallGoodsCountByGoodsNameAndGoodId(goodsName, mallGoodsUpdateDto.getId()); if (mallGoodsByGoodsName > 0) { return new FebsResponse().fail().message("商品名称不能重复"); } String goodsNo = mallGoodsUpdateDto.getGoodsNo(); if (StrUtil.isEmpty(goodsNo)) { return new FebsResponse().fail().message("商品编号不能为空"); } Integer mallGoodsByGoodsNo = mallGoodsMapper.selectMallGoodsCountByGoodsNoAndGoodId(goodsNo, mallGoodsUpdateDto.getId()); if (mallGoodsByGoodsNo > 0) { return new FebsResponse().fail().message("商品编号不能重复"); } if (mallGoodsUpdateDto.getGoodsType() != 2) { Long categoryId = mallGoodsUpdateDto.getCategoryId(); if (ObjectUtil.isEmpty(categoryId)) { return new FebsResponse().fail().message("商品分类不能为空"); } if (mallGoodsUpdateDto.getIsSku() == 1) { List 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()); // 若原来不为多规格或编辑后也不为多规格,则清空样式和规格 if (mallGoods.getIsSku() == 2 || mallGoodsUpdateDto.getIsSku() == 2) { mallGoodsSkuMapper.deleteByGoodsId(mallGoods.getId()); mallGoodsStyleMapper.deleteByGoodsId(mallGoods.getId()); } BeanUtil.copyProperties(mallGoodsUpdateDto, mallGoods); if (mallGoods.getHasCarriage() == 2) { mallGoods.setCarriage(BigDecimal.ZERO); } mallGoodsMapper.updateById(mallGoods); mallGoodsImagesMapper.deleteByGoodsId(mallGoodsUpdateDto.getId()); String thumbs = mallGoodsUpdateDto.getThumbs(); if (StrUtil.isNotEmpty(thumbs)) { List imgs = StrUtil.splitTrim(thumbs, ","); if (CollUtil.isNotEmpty(imgs)) { int i = 1; for (String img : imgs) { MallGoodsImages mallGoodsImages = new MallGoodsImages(); mallGoodsImages.setGoodsId(mallGoods.getId()); mallGoodsImages.setImageUrl(img); mallGoodsImages.setSeq(i); mallGoodsImagesMapper.insert(mallGoodsImages); i++; } } } 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 delSkuIds = mallGoodsUpdateDto.getDelSkuId(); if (CollUtil.isNotEmpty(delSkuIds)) { mallGoodsSkuMapper.delSkuByIds(delSkuIds); // 如果该样式下sku全删除,则删除该样式 List styles = mallGoodsStyleMapper.selectByGoodsId(mallGoods.getId()); for (MallGoodsStyle style : styles) { if (CollUtil.isEmpty(style.getSkus())) { mallGoodsStyleMapper.deleteById(style.getId()); } } } List mailGoodsSkuDto = mallGoodsUpdateDto.getMailGoodsSkuDto(); Set styles = new HashSet<>(); if (CollUtil.isNotEmpty(mailGoodsSkuDto)) { for (MailGoodsSkuDto addStyleDto : mailGoodsSkuDto) { // if (ObjectUtil.isNotEmpty(addStyleDto.getDelLog())) { // mallGoodsSkuMapper.deleteById(addStyleDto.getId()); // mallShoppingCartMapper.deleteByGoodsIdAndSkuId(addStyleDto.getId(), addStyleDto.getGoodsId()); // } if (ObjectUtil.isEmpty(addStyleDto.getStyleId())) { MallGoodsStyle mallGoodsStyleSku = mallGoodsStyleMapper.selectByStyleName(addStyleDto.getStyleName(), mallGoods.getId()); if (ObjectUtil.isEmpty(mallGoodsStyleSku)) { styles.add(addStyleDto.getStyleName()); } } } } if (CollUtil.isNotEmpty(styles)) { for (String style : styles) { //新增样式 MallGoodsStyle mallGoodsStyle = new MallGoodsStyle(); mallGoodsStyle.setName(style); mallGoodsStyle.setGoodsId(mallGoods.getId()); mallGoodsStyleMapper.insert(mallGoodsStyle); } } if (CollUtil.isNotEmpty(mailGoodsSkuDto)) { for (MailGoodsSkuDto addMallGoodsSkuDto : mailGoodsSkuDto) { if (StrUtil.isEmpty(addMallGoodsSkuDto.getDelLog())) { if (ObjectUtil.isNotEmpty(addMallGoodsSkuDto.getId())) { MallGoodsSku mallGoodsSku = mallGoodsSkuMapper.selectById(addMallGoodsSkuDto.getId()); mallGoodsSku.setSkuName(addMallGoodsSkuDto.getSkuName()); mallGoodsSku.setSkuImage(addMallGoodsSkuDto.getSkuImage()); mallGoodsSku.setStock(addMallGoodsSkuDto.getStock() == null ? 0 : addMallGoodsSkuDto.getStock()); mallGoodsSku.setSkuVolume(addMallGoodsSkuDto.getSkuVolume() == null ? 0 : addMallGoodsSkuDto.getSkuVolume()); mallGoodsSku.setOriginalPrice(addMallGoodsSkuDto.getOriginalPrice()); mallGoodsSku.setPresentPrice(addMallGoodsSkuDto.getPresentPrice()); mallGoodsSku.setStyleId(addMallGoodsSkuDto.getStyleId()); mallGoodsSku.setGoodsId(mallGoods.getId()); mallGoodsSku.setCostPrice(addMallGoodsSkuDto.getCostPrice()); mallGoodsSkuMapper.updateById(mallGoodsSku); } else { //新增商品规格 MallGoodsStyle mallGoodsStyleSku = mallGoodsStyleMapper.selectByStyleName(addMallGoodsSkuDto.getStyleName(), mallGoods.getId()); MallGoodsSku mallGoodsSku = new MallGoodsSku(); mallGoodsSku.setSkuName(addMallGoodsSkuDto.getSkuName()); mallGoodsSku.setSkuImage(addMallGoodsSkuDto.getSkuImage()); mallGoodsSku.setStock(addMallGoodsSkuDto.getStock() == null ? 0 : addMallGoodsSkuDto.getStock()); mallGoodsSku.setSkuVolume(addMallGoodsSkuDto.getSkuVolume() == null ? 0 : addMallGoodsSkuDto.getSkuVolume()); mallGoodsSku.setOriginalPrice(addMallGoodsSkuDto.getOriginalPrice()); mallGoodsSku.setPresentPrice(addMallGoodsSkuDto.getPresentPrice()); mallGoodsSku.setStyleId(mallGoodsStyleSku.getId()); mallGoodsSku.setCostPrice(addMallGoodsSkuDto.getCostPrice()); mallGoodsSku.setGoodsId(mallGoods.getId()); mallGoodsSkuMapper.insert(mallGoodsSku); } } } } return new FebsResponse().success().message("操作成功"); } @Override public List getAllGoodsTree() { 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 getDeliveryHomeListInPage(AdminHomeDeliverySettingVo adminHomeDeliverySetting, QueryRequest request) { Page page = new Page<>(request.getPageNum(), request.getPageSize()); IPage dataDictionaryCustomIPage = this.baseMapper.getDeliveryHomeListInPage(page, adminHomeDeliverySetting); List records = dataDictionaryCustomIPage.getRecords(); List adminHomeDeliverySettingVos = new ArrayList<>(); if(CollUtil.isNotEmpty(records)){ for(DataDictionaryCustom dataDictionaryCustom : records){ AdminHomeDeliverySettingVo adminHomeDeliverySettingVo = JSONUtil.toBean(dataDictionaryCustom.getValue(), AdminHomeDeliverySettingVo.class); adminHomeDeliverySettingVo.setId(dataDictionaryCustom.getId()); adminHomeDeliverySettingVos.add(adminHomeDeliverySettingVo); } } IPage adminHomeDeliverySettingVoIPage = new Page<>(); adminHomeDeliverySettingVoIPage.setRecords(adminHomeDeliverySettingVos); adminHomeDeliverySettingVoIPage.setTotal(dataDictionaryCustomIPage.getTotal()); return adminHomeDeliverySettingVoIPage; } private final DataDictionaryCustomMapper dataDictionaryCustomMapper; @Override public FebsResponse deliveryHomeUpdate(AdminHomeDeliverySettingVo adminHomeDeliverySettingVo) { DataDictionaryCustom dataDictionaryCustom = dataDictionaryCustomMapper.selectById(adminHomeDeliverySettingVo.getId()); adminHomeDeliverySettingVo.setId(null); dataDictionaryCustom.setValue(JSONUtil.toJsonStr(adminHomeDeliverySettingVo)); dataDictionaryCustomMapper.updateById(dataDictionaryCustom); return new FebsResponse().success(); } }