From fd45fcbd496bbeaf9ee18edd8f2f858cf9cebaf3 Mon Sep 17 00:00:00 2001 From: Pu Zhibing <393733352@qq.com> Date: 星期五, 24 一月 2025 16:47:38 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java | 182 ++++++++++++++++++++++++++++---------------- 1 files changed, 115 insertions(+), 67 deletions(-) diff --git a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java index 7fe2df4..3eac7b1 100644 --- a/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java +++ b/ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java @@ -6,11 +6,9 @@ import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; -import com.ruoyi.account.api.feignClient.AppUserClient; -import com.ruoyi.account.api.feignClient.BalanceChangeRecordClient; -import com.ruoyi.account.api.feignClient.UserCouponClient; -import com.ruoyi.account.api.feignClient.UserPointClient; +import com.ruoyi.account.api.feignClient.*; import com.ruoyi.account.api.model.*; +import com.ruoyi.common.core.constant.ExpressCompanyMap; import com.ruoyi.common.core.domain.R; import com.ruoyi.common.core.exception.ServiceException; import com.ruoyi.common.core.utils.StringUtils; @@ -38,12 +36,15 @@ import com.ruoyi.system.api.domain.SysUser; import com.ruoyi.system.api.feignClient.SysUserClient; import com.ruoyi.system.api.model.LoginUser; +import org.apache.poi.ss.usermodel.*; import org.springframework.data.redis.core.RedisTemplate; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; +import org.springframework.web.multipart.MultipartFile; import javax.annotation.Resource; import java.io.IOException; +import java.io.InputStream; import java.math.BigDecimal; import java.math.RoundingMode; import java.time.LocalDateTime; @@ -89,9 +90,6 @@ private UserPointClient userPointClient; @Resource - private PointSettingClient pointSettingClient; - - @Resource private OrderBalancePaymentService orderBalancePaymentService; @Resource @@ -115,6 +113,9 @@ @Resource private UserCouponClient userCouponClient; + + @Resource + private UserChangeLogClient userChangeLogClient; @@ -286,6 +287,7 @@ if(StringUtils.isNotEmpty(technicianId) && !"null".equals(technicianId)){ order.setTechnicianId(Integer.valueOf(technicianId)); } + // TODO orderMapper.updateById(order); } @@ -344,6 +346,14 @@ List<ShopBalanceStatement> data = shopBalanceStatementClient.getShopBalanceStatementList(Arrays.asList(1, 2, 3), Long.valueOf(orderPageListVo.getId())).getData(); BigDecimal reduce = data.stream().map(ShopBalanceStatement::getVariableAmount).reduce(BigDecimal.ZERO, BigDecimal::add); orderPageListVo.setGetCommission(reduce); + + String expressJson = orderPageListVo.getExpressJson(); + // {"com":"zhongtong","num":"78853319672621"} + JSONObject jsonObject = JSONObject.parseObject(expressJson); + + String companyName = ExpressCompanyMap.getCompanyNameByCode(jsonObject.getString("com")); + orderPageListVo.setExpressCompany(companyName); + orderPageListVo.setExpressNum(jsonObject.getString("num")); } return pageInfo.setRecords(list); } @@ -470,7 +480,7 @@ BigDecimal balance = appUser.getBalance(); if(null != orderBalancePayment){ appUser.setTotalRedPacketAmount(appUser.getTotalRedPacketAmount().add(orderBalancePayment.getRedPacketAmount()).setScale(2, RoundingMode.HALF_EVEN)); - appUser.setTotalDistributionAmount(appUser.getTotalDistributionAmount().add(orderBalancePayment.getDistributionAmount()).setScale(2, RoundingMode.HALF_EVEN)); +// appUser.setTotalDistributionAmount(appUser.getTotalDistributionAmount().add(orderBalancePayment.getDistributionAmount()).setScale(2, RoundingMode.HALF_EVEN)); } appUser.setBalance(balance.add(paymentAmount).setScale(2, RoundingMode.HALF_EVEN)); appUser.setShopAmount(appUser.getShopAmount().subtract(paymentAmount).setScale(2, RoundingMode.HALF_EVEN)); @@ -518,22 +528,24 @@ } appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint); - boolean vipDemotion = vipDemotion(appUser.getShopPoint(), appUser.getVipId()); - if(vipDemotion){ - appUser.setVipId(appUser.getVipId() - 1); - } - //构建积分流水明细 - UserPoint userPoint = new UserPoint(); - userPoint.setType(1); - userPoint.setHistoricalPoint(lavePoint); - userPoint.setVariablePoint(shopPoint); - userPoint.setBalance(appUser.getLavePoint()); - userPoint.setCreateTime(LocalDateTime.now()); - userPoint.setAppUserId(order.getAppUserId()); - userPoint.setObjectId(order.getId()); - userPointClient.saveUserPoint(userPoint); + if(shopPoint > 0){ + UserPoint userPoint = new UserPoint(); + userPoint.setType(1); + userPoint.setHistoricalPoint(lavePoint); + userPoint.setVariablePoint(shopPoint); + userPoint.setBalance(appUser.getLavePoint()); + userPoint.setCreateTime(LocalDateTime.now()); + userPoint.setAppUserId(order.getAppUserId()); + userPoint.setObjectId(order.getId()); + userPointClient.saveUserPoint(userPoint); + } appUserClient.editAppUserById(appUser); + + //降级检测 + if(1 < appUser.getVipId() && appUser.getVipId() < 4){ + appUserClient.vipDemotion(appUser.getId()); + } //回退优惠券状态 if(null != order.getUserCouponId()){ UserCoupon userCoupon = userCouponClient.getUserCoupon(order.getUserCouponId()).getData(); @@ -561,7 +573,7 @@ BigDecimal balance = appUser.getBalance(); if(null != orderBalancePayment){ appUser.setTotalRedPacketAmount(appUser.getTotalRedPacketAmount().add(orderBalancePayment.getRedPacketAmount()).setScale(2, RoundingMode.HALF_EVEN)); - appUser.setTotalDistributionAmount(appUser.getTotalDistributionAmount().add(orderBalancePayment.getDistributionAmount()).setScale(2, RoundingMode.HALF_EVEN)); +// appUser.setTotalDistributionAmount(appUser.getTotalDistributionAmount().add(orderBalancePayment.getDistributionAmount()).setScale(2, RoundingMode.HALF_EVEN)); } appUser.setBalance(balance.add(expressAmount).setScale(2, RoundingMode.HALF_EVEN)); //构建账户余额流水明细 @@ -595,15 +607,17 @@ appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint); //构建积分流水明细 - UserPoint userPoint = new UserPoint(); - userPoint.setType(11); - userPoint.setHistoricalPoint(lavePoint); - userPoint.setVariablePoint(order.getPoint()); - userPoint.setBalance(appUser.getLavePoint()); - userPoint.setCreateTime(LocalDateTime.now()); - userPoint.setAppUserId(order.getAppUserId()); - userPoint.setObjectId(order.getId()); - userPointClient.saveUserPoint(userPoint); + if(order.getPoint() > 0){ + UserPoint userPoint = new UserPoint(); + userPoint.setType(11); + userPoint.setHistoricalPoint(lavePoint); + userPoint.setVariablePoint(order.getPoint()); + userPoint.setBalance(appUser.getLavePoint()); + userPoint.setCreateTime(LocalDateTime.now()); + userPoint.setAppUserId(order.getAppUserId()); + userPoint.setObjectId(order.getId()); + userPointClient.saveUserPoint(userPoint); + } appUserClient.editAppUserById(appUser); } @@ -650,22 +664,24 @@ } appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint); - boolean vipDemotion = vipDemotion(appUser.getShopPoint(), appUser.getVipId()); - if(vipDemotion){ - appUser.setVipId(appUser.getVipId() - 1); - } - //构建积分流水明细 - UserPoint userPoint = new UserPoint(); - userPoint.setType(1); - userPoint.setHistoricalPoint(lavePoint); - userPoint.setVariablePoint(shopPoint); - userPoint.setBalance(appUser.getLavePoint()); - userPoint.setCreateTime(LocalDateTime.now()); - userPoint.setAppUserId(order.getAppUserId()); - userPoint.setObjectId(order.getId()); - userPointClient.saveUserPoint(userPoint); + if(shopPoint > 0){ + UserPoint userPoint = new UserPoint(); + userPoint.setType(1); + userPoint.setHistoricalPoint(lavePoint); + userPoint.setVariablePoint(shopPoint); + userPoint.setBalance(appUser.getLavePoint()); + userPoint.setCreateTime(LocalDateTime.now()); + userPoint.setAppUserId(order.getAppUserId()); + userPoint.setObjectId(order.getId()); + userPointClient.saveUserPoint(userPoint); + } appUserClient.editAppUserById(appUser); + + //降级检测 + if(1 < appUser.getVipId() && appUser.getVipId() < 4){ + appUserClient.vipDemotion(appUser.getId()); + } //回退优惠券状态 if(null != order.getUserCouponId()){ @@ -710,30 +726,21 @@ appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint); //构建积分流水明细 - UserPoint userPoint = new UserPoint(); - userPoint.setType(11); - userPoint.setHistoricalPoint(lavePoint); - userPoint.setVariablePoint(order.getPoint()); - userPoint.setBalance(appUser.getLavePoint()); - userPoint.setCreateTime(LocalDateTime.now()); - userPoint.setAppUserId(order.getAppUserId()); - userPoint.setObjectId(order.getId()); - userPointClient.saveUserPoint(userPoint); + if(order.getPoint() > 0){ + UserPoint userPoint = new UserPoint(); + userPoint.setType(11); + userPoint.setHistoricalPoint(lavePoint); + userPoint.setVariablePoint(order.getPoint()); + userPoint.setBalance(appUser.getLavePoint()); + userPoint.setCreateTime(LocalDateTime.now()); + userPoint.setAppUserId(order.getAppUserId()); + userPoint.setObjectId(order.getId()); + userPointClient.saveUserPoint(userPoint); + } return R.ok(); } - /** - * 会员降级检测 - */ - public boolean vipDemotion(Integer shopPoint, Integer vipId){ - if(vipId == 1 || vipId > 3){ - return false; - } - VipSetting vipSetting = vipSettingClient.getVipSetting(vipId).getData(); - Integer vipLevelUpShopRole = vipSetting.getVipLevelUpShopRole(); - Integer vipLevelUpShop = vipSetting.getVipLevelUpShop(); - return 1 == vipLevelUpShopRole && shopPoint < vipLevelUpShop; - } + /** @@ -808,6 +815,7 @@ } List<OrderGood> orderGoods = orderGoodMapper.selectList(new LambdaQueryWrapper<OrderGood>().eq(OrderGood::getOrderId, orderId).eq(OrderGood::getDelFlag, 0)); int sum = orderGoods.stream().mapToInt(OrderGood::getNum).sum(); + System.out.println("111111111111222"); orderInfo.setGoodsNum(sum); List<Object> goodsJson = new ArrayList<>(); for (OrderGood orderGood : orderGoods) { @@ -905,4 +913,44 @@ } } } + + @Override + public void importExpress(MultipartFile file) { + try (InputStream inputStream = file.getInputStream()) { + Workbook workbook = WorkbookFactory.create(inputStream); + Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet + int lastRowNum = sheet.getLastRowNum(); + for (int i = 1; i <= lastRowNum; i++) { + Row row = sheet.getRow(i); + String orderNum = row.getCell(1).getStringCellValue(); + // 快递单号 + String expressNum = row.getCell(7).getStringCellValue(); + // 快递公司名称 + String expressName = row.getCell(8).getStringCellValue(); + // 省区划代码 + String provinceCode = row.getCell(10).getStringCellValue(); + // 市区划代码 + String cityCode = row.getCell(12).getStringCellValue(); + Order order = this.getOne(new LambdaQueryWrapper<Order>() + .eq(Order::getOrderNumber, orderNum) + .eq(Order::getOrderType, 1) + .eq(Order::getDistributionMode,2) + .eq(Order::getOrderStatus, 1) + ); + if (order != null){ + JSONObject jsonObject = new JSONObject(); + jsonObject.put("com", expressName); + jsonObject.put("num", expressNum); + order.setExpressJson(jsonObject.toJSONString()); + order.setDeliverProvinceCode(provinceCode); + order.setDeliverCityCode(cityCode); + order.setOrderStatus(2); + this.updateById(order); + } + } + + } catch (IOException e) { + throw new RuntimeException(e); + } + } } -- Gitblit v1.7.1