From 97d99b76bdde8952cf257c3c85c1a8a080927af4 Mon Sep 17 00:00:00 2001
From: Pu Zhibing <393733352@qq.com>
Date: 星期一, 31 三月 2025 16:44:22 +0800
Subject: [PATCH] 修改反馈文档bug
---
ruoyi-service/ruoyi-order/src/main/java/com/ruoyi/order/service/impl/OrderServiceImpl.java | 1526 +++++++++++++++++++++++++++++++--------------------------
1 files changed, 831 insertions(+), 695 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 81f0d2c..e0c937f 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
@@ -1,5 +1,8 @@
package com.ruoyi.order.service.impl;
+import cn.hutool.http.HttpRequest;
+import cn.hutool.http.HttpUtil;
+import cn.hutool.json.JSONUtil;
import com.alibaba.fastjson2.JSON;
import com.alibaba.fastjson2.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
@@ -9,11 +12,13 @@
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.HttpUtils;
import com.ruoyi.common.core.utils.StringUtils;
import com.ruoyi.common.core.utils.uuid.QRCodeGenerator;
import com.ruoyi.common.core.web.page.PageInfo;
import com.ruoyi.common.security.service.TokenService;
import com.ruoyi.order.enums.OrderStatus;
+import com.ruoyi.order.event.ConfirmDeliveryEvent;
import com.ruoyi.order.mapper.OrderGoodMapper;
import com.ruoyi.order.mapper.OrderMapper;
import com.ruoyi.order.model.Order;
@@ -43,6 +48,8 @@
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
+import org.jetbrains.annotations.Nullable;
+import org.springframework.context.ApplicationEventPublisher;
import org.springframework.data.redis.core.RedisTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -57,6 +64,7 @@
import java.net.MalformedURLException;
import java.net.URL;
import java.time.LocalDateTime;
+import java.time.OffsetDateTime;
import java.time.ZoneOffset;
import java.time.format.DateTimeFormatter;
import java.util.*;
@@ -65,7 +73,7 @@
/**
* <p>
- * 服务实现类
+ * 服务实现类
* </p>
*
* @author luodangjia
@@ -89,22 +97,23 @@
private CommissionService commissionService;
@Resource
private BaseSettingClient baseSettingClient;
-
+
@Resource
private SysUserClient sysUserClient;
-
+
@Resource
private BalanceChangeRecordClient balanceChangeRecordClient;
+
@Resource
private UserPointClient userPointClient;
-
+
@Resource
private OrderBalancePaymentService orderBalancePaymentService;
-
+
@Resource
private VipSettingClient vipSettingClient;
-
+
@Resource
private GoodsClient goodsClient;
@@ -114,22 +123,30 @@
private TechnicianSubscribeClient technicianSubscribeClient;
@Resource
private ShopBalanceStatementClient shopBalanceStatementClient;
-
+
+ @Resource
+ private ShopPointClient shopPointClient;
+
@Resource
private RedisTemplate redisTemplate;
-
+
@Resource
private SystemConfigClient systemConfigClient;
@Resource
private UserCouponClient userCouponClient;
-
+
@Resource
private UserChangeLogClient userChangeLogClient;
@Resource
private RegionClient regionClient;
-
+ @Resource
+ private AppUserGiveawayTemporaryClient appUserGiveawayTemporaryClient;
+ @Resource
+ private ShopGiveawayTemporaryClient shopGiveawayTemporaryClient;
+ @Resource
+ private ApplicationEventPublisher applicationEventPublisher;
@Override
@@ -138,16 +155,14 @@
}
-
-
@Override
public OrderDetailVO getOrderDetail(Long orderId) {
Order order = orderMapper.selectById(orderId);
- if (order == null){
+ if (order == null) {
throw new ServiceException("订单不存在");
}
R<Shop> shopR = shopClient.getShopById(order.getShopId());
- if (!R.isSuccess(shopR)){
+ if (!R.isSuccess(shopR)) {
throw new ServiceException("获取门店信息失败");
}
@@ -173,20 +188,20 @@
// 收货地址
String addressJson = order.getAddressJson();
UserAddress userAddress = new UserAddress();
- if (2 == order.getDistributionMode()){
+ if (2 == order.getDistributionMode()) {
userAddress = JSONObject.parseObject(addressJson, UserAddress.class);
}
// 优惠券
String couponJson = order.getCouponJson();
- CouponInfo couponInfo = new CouponInfo();
- if (StringUtils.isNotEmpty(couponJson)){
- couponInfo = JSONObject.parseObject(couponJson, CouponInfo.class);
+ JSONObject jsonObject = new JSONObject();
+ if (StringUtils.isNotEmpty(couponJson)) {
+ jsonObject = JSONObject.parseObject(couponJson);
}
// 参与活动
String activityJson = order.getActivityJson();
OrderActivityInfo orderActivityInfo = new OrderActivityInfo();
- if (StringUtils.isNotEmpty(activityJson)){
+ if (StringUtils.isNotEmpty(activityJson)) {
orderActivityInfo = JSONObject.parseObject(activityJson, OrderActivityInfo.class);
}
OrderDetailVO orderDetailVO = new OrderDetailVO();
@@ -203,7 +218,7 @@
orderDetailVO.setOrderNumber(order.getOrderNumber());
orderDetailVO.setCreateTime(order.getCreateTime());
orderDetailVO.setTotalAmount(order.getTotalAmount());
- orderDetailVO.setCouponName(couponInfo.getCouponName());
+ orderDetailVO.setCouponName(jsonObject.getString("couponName"));
orderDetailVO.setActivityName(orderActivityInfo.getActivityName());
orderDetailVO.setCouponAmount(order.getDiscountTotalAmount());
orderDetailVO.setExpressAmount(order.getExpressAmount());
@@ -215,15 +230,15 @@
orderDetailVO.setLongitude(shop.getLongitude());
orderDetailVO.setLatitude(shop.getLatitude());
orderDetailVO.setShopId(shop.getId());
- if(StringUtils.isNotEmpty(order.getExpressResult())){
+ if (StringUtils.isNotEmpty(order.getExpressResult())) {
MapTrackKD100Vo mapTrackKD100Vo = JSON.parseObject(order.getExpressResult(), MapTrackKD100Vo.class);
List<QueryKD100ListVo> data = mapTrackKD100Vo.getData();
orderDetailVO.setExpress(null != data && data.size() > 0 ? data.get(0).getContext() : "");
}
-
- if(order.getOrderType() == 1){
+
+ if (order.getOrderType() == 1) {
List<TechnicianSubscribe> data = technicianSubscribeClient.getTechnicianSubscribeList(order.getId()).getData();
- if(data.size() > 0){
+ if (data.size() > 0) {
Long id = data.get(0).getId();
orderDetailVO.setTechnicianSubscribeId(id.toString());
Technician technician = technicianClient.shopdetail(order.getTechnicianId()).getData();
@@ -242,14 +257,15 @@
return orderDetailVO;
}
+
@Override
public boolean check(Order order, Integer shopId, Long userId) {
R<List<AppUserShop>> r = appUserClient.getAppUserShop(userId);
- if (r.getCode() != R.SUCCESS){
+ if (r.getCode() != R.SUCCESS) {
throw new ServiceException("获取用户门店信息失败");
}
List<AppUserShop> appUserShopList = r.getData();
- if (appUserShopList == null || appUserShopList.isEmpty()){
+ if (appUserShopList == null || appUserShopList.isEmpty()) {
return false;
}
@@ -257,12 +273,12 @@
List<AppUserShop> userShopList = appUserShopList.stream()
.filter(appUserShop -> appUserShop.getShopId().equals(shopId))
.collect(Collectors.toList());
- if (userShopList.isEmpty()){
+ if (userShopList.isEmpty()) {
return false;
}
// 判断订单是否属于该门店
- if (order == null){
+ if (order == null) {
throw new ServiceException("订单不存在");
}
@@ -275,7 +291,7 @@
LoginUser loginUserApplet = tokenService.getLoginUserApplet();
Order order = orderMapper.selectById(id);
boolean check = check(order, shopId, loginUserApplet.getUserid());
- if (!check){
+ if (!check) {
throw new ServiceException("该订单与当前扫码门店不一致");
}
@@ -292,177 +308,835 @@
JSONObject jsonObject = JSONObject.parseObject(content);
Long days = jsonObject.getLong("days");
order.setOrderStatus(OrderStatus.COMPLETED.getCode());
- order.setIsCommission(0);
order.setAfterSaleTime(LocalDateTime.now().plusDays(days));
order.setEndTime(LocalDateTime.now());
order.setCancellerAppUserId(loginUserApplet.getUserid());
- if(StringUtils.isNotEmpty(technicianId) && !"null".equals(technicianId)){
+ if (StringUtils.isNotEmpty(technicianId) && !"null".equals(technicianId)) {
order.setTechnicianId(Integer.valueOf(technicianId));
}
- // TODO
orderMapper.updateById(order);
+ commissionService.calculationCommissionShop(order.getId());
}
-
-
+
+
/**
* 管理后台获取订单列表数据
+ *
* @param orderPageList
* @return
*/
@Override
public PageInfo<OrderPageListVo> getOrderPageList(OrderPageList orderPageList) {
- Long userId = tokenService.getLoginUser().getUserid();
- SysUser sysUser = sysUserClient.getSysUser(userId).getData();
-
- // 设置店铺ID
- if (sysUser.getRoleType() == 2) {
+ Long userid = tokenService.getLoginUser().getUserid();
+ SysUser sysUser = sysUserClient.getSysUser(userid).getData();
+ if (2 == sysUser.getRoleType()) {
orderPageList.setShopId(sysUser.getObjectId());
}
+ //搜索条件，用户姓名
+ if (StringUtils.isNotEmpty(orderPageList.getUserName())) {
+ List<AppUser> data = appUserClient.getAppUserByNameNoFilter(orderPageList.getUserName()).getData();
+ List<Long> collect = data.stream().map(AppUser::getId).collect(Collectors.toList());
+ if (CollectionUtils.isEmpty(collect)) {
+ return new PageInfo<>();
+ }
+ if (null != orderPageList.getAppUserIds()) {
+ List<Long> appUserIds = orderPageList.getAppUserIds();
+ appUserIds.addAll(collect);
+ orderPageList.setAppUserIds(appUserIds);
+ } else {
+ orderPageList.setAppUserIds(collect);
+ }
+ }
+ //搜索条件，用户电话
+ if (StringUtils.isNotEmpty(orderPageList.getPhone())) {
+ List<AppUser> data = appUserClient.getAppUserByPhoneNoFilter(orderPageList.getPhone()).getData();
+ List<Long> collect = data.stream().map(AppUser::getId).collect(Collectors.toList());
+ if (CollectionUtils.isEmpty(collect)) {
+ return new PageInfo<>();
+ }
- // 处理用户姓名搜索条件
- processAppUserIds(orderPageList, orderPageList.getUserName(), appUserClient::getAppUserByNameNoFilter);
+ if (null != orderPageList.getAppUserIds()) {
+ List<Long> appUserIds = orderPageList.getAppUserIds();
+ if (!containsAny(appUserIds, collect)) {
+ return new PageInfo<>();
+ }
+ appUserIds.addAll(collect);
+ orderPageList.setAppUserIds(appUserIds);
+ } else {
+ orderPageList.setAppUserIds(collect);
+ }
+ }
+ if (null != orderPageList.getAppUserIds()) {
+ orderPageList.setAppUserIds(orderPageList.getAppUserIds().stream().distinct().collect(Collectors.toList()));
+ }
- // 处理用户电话搜索条件
- processAppUserIds(orderPageList, orderPageList.getPhone(), appUserClient::getAppUserByPhoneNoFilter);
- // 去重 appUserIds
- Optional.ofNullable(orderPageList.getAppUserIds())
- .ifPresent(ids -> orderPageList.setAppUserIds(ids.stream().distinct().collect(Collectors.toList())));
-
- log.error("orderPageList:"+orderPageList.getAppUserIds());
- // 分页查询订单列表
PageInfo<OrderPageListVo> pageInfo = new PageInfo<>(orderPageList.getPageCurr(), orderPageList.getPageSize());
+
List<OrderPageListVo> list = this.baseMapper.getOrderPageList(pageInfo, orderPageList);
+ for (OrderPageListVo orderPageListVo : list) {
+ Long appUserId = orderPageListVo.getAppUserId();
+ AppUser appUser = appUserClient.getAppUserById(appUserId);
+ if (null != appUser) {
+ orderPageListVo.setUserName(appUser.getName());
+ orderPageListVo.setPhone(appUser.getPhone());
+ }
+ RefundPass one = refundPassService.getOne(new LambdaQueryWrapper<RefundPass>().eq(RefundPass::getOrderId, orderPageListVo.getId()).eq(RefundPass::getDelFlag, 0).last(" order by create_time desc limit 0,1"));
+ orderPageListVo.setRefundPassId(null != one ? one.getId().toString() : null);
- // 处理订单列表中的每个订单
- list.forEach(this::processOrderPageListVo);
+ // 平台分佣
+ 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();
+ if (StringUtils.isNotEmpty(expressJson) && !expressJson.equals("NULL")) {
+ JSONObject jsonObject = null;
+ try {
+ jsonObject = JSONObject.parseObject(expressJson);
+ String companyName = ExpressCompanyMap.getCompanyNameByCode(jsonObject.getString("com"));
+ orderPageListVo.setExpressCompany(companyName);
+ orderPageListVo.setExpressNum(jsonObject.getString("num"));
+ } catch (Exception e) {
+ }
+
+ }
+
+ }
return pageInfo.setRecords(list);
}
-
-
- private void processAppUserIds(OrderPageList orderPageList, String searchKey, Function<String, R<List<AppUser>>> userSearchFunction) {
- if (StringUtils.isNotEmpty(searchKey)) {
- List<Long> userIds = Optional.ofNullable(userSearchFunction.apply(searchKey).getData())
- .orElse(Collections.emptyList())
- .stream()
- .map(AppUser::getId)
- .collect(Collectors.toList());
-
- if (CollectionUtils.isEmpty(userIds)) {
- return;
- }
-
- List<Long> existingUserIds = orderPageList.getAppUserIds();
- if (existingUserIds != null) {
- if (!containsAny(existingUserIds, userIds)) {
- return;
- }
- existingUserIds.addAll(userIds);
- } else {
- orderPageList.setAppUserIds(userIds);
- }
- }
- }
-
- private void processOrderPageListVo(OrderPageListVo orderPageListVo) {
- Long appUserId = orderPageListVo.getAppUserId();
- Optional.ofNullable(appUserClient.getAppUserById(appUserId))
- .ifPresent(appUser -> {
- orderPageListVo.setUserName(appUser.getName());
- orderPageListVo.setPhone(appUser.getPhone());
- });
-
- Optional.ofNullable(refundPassService.getOne(new LambdaQueryWrapper<RefundPass>()
- .eq(RefundPass::getOrderId, orderPageListVo.getId())
- .eq(RefundPass::getDelFlag, 0)
- .orderByDesc(RefundPass::getCreateTime)
- .last("limit 1")))
- .ifPresent(refundPass -> orderPageListVo.setRefundPassId(refundPass.getId().toString()));
-
- // 平台分佣
- BigDecimal commission = Optional.ofNullable(shopBalanceStatementClient.getShopBalanceStatementList(Arrays.asList(1, 2, 3), Long.valueOf(orderPageListVo.getId())).getData())
- .orElse(Collections.emptyList())
- .stream()
- .map(ShopBalanceStatement::getVariableAmount)
- .reduce(BigDecimal.ZERO, BigDecimal::add);
- orderPageListVo.setGetCommission(commission);
-
- // 处理快递信息
- Optional.ofNullable(orderPageListVo.getExpressJson())
- .filter(expressJson -> !expressJson.equals("NULL"))
- .ifPresent(expressJson -> {
- try {
- JSONObject jsonObject = JSONObject.parseObject(expressJson);
- orderPageListVo.setExpressCompany(ExpressCompanyMap.getCompanyNameByCode(jsonObject.getString("com")));
- orderPageListVo.setExpressNum(jsonObject.getString("num"));
- } catch (Exception e) {
- }
- });
- }
-
/**
- * 判断两个列表中是否至少有一个相同的元素
- * 此方法用于检查两个长整型列表之间的元素交集
- * 主要解决的问题是确定两个列表是否有共同的元素，用于避免潜在的数据不一致或错误
+ * 判断 list1 是否包含 list2 中的至少一个元素
*
- * @param list1 第一个列表，包含一系列长整型数值
- * @param list2 第二个列表，同样包含一系列长整型数值
- * @return 返回一个布尔值，如果两个列表中至少有一个相同的元素，则返回true，否则返回false
+ * @param list1 第一个列表
+ * @param list2 第二个列表
+ * @return 如果 list1 包含 list2 中的至少一个元素，返回 true；否则返回 false
*/
private boolean containsAny(List<Long> list1, List<Long> list2) {
- return list1.stream().anyMatch(list2::contains) || list2.stream().anyMatch(list1::contains);
+ // 将 list1 转换为 HashSet 以提高查询效率
+ Set<Long> set1 = new HashSet<>(list1);
+
+ // 遍历 list2，检查是否有元素存在于 set1 中
+ for (Long element : list2) {
+ if (set1.contains(element)) {
+ return true;
+ }
+ }
+
+ // 如果没有找到共同元素，返回 false
+ return false;
}
-
-
-
-
/**
* 小程序取消订单
+ *
* @param orderId
* @return
*/
@Override
public R cancel(Long orderId) {
Order order = this.getById(orderId);
- if(null == order){
+ if (null == order) {
return R.fail("取消失败");
}
Long userid = tokenService.getLoginUserApplet().getUserid();
- if(!order.getAppUserId().equals(userid)){
+ if (!order.getAppUserId().equals(userid)) {
return R.fail("取消失败");
}
- if(!Arrays.asList(1, 2, 3).contains(order.getOrderStatus())){
+ if (!Arrays.asList(1, 2, 3).contains(order.getOrderStatus())) {
return R.fail("订单取消失败");
}
- if(null != order.getAfterSaleTime() && LocalDateTime.now().isAfter(order.getAfterSaleTime())){
+ if (null != order.getAfterSaleTime() && LocalDateTime.now().isAfter(order.getAfterSaleTime())) {
return R.fail("订单取消失败");
}
order.setOrderStatus(5);
R r = refundPayMoney(order);
- if(200 == r.getCode()){
+ if (200 == r.getCode()) {
this.updateById(order);
}
return r;
}
+
+
+
+ /**
+ * 取消订单操作
+ *
+ * @param orderId
+ * @return
+ */
+ @Override
+ public R cancelOrder(Long orderId) {
+ Order order = this.getById(orderId);
+ if (Arrays.asList(5, 6, 7).contains(order.getOrderStatus())) {
+ return R.fail("无效的操作");
+ }
+ if (null != order.getAfterSaleTime() && LocalDateTime.now().isAfter(order.getAfterSaleTime())) {
+ return R.fail("订单取消失败");
+ }
+ order.setOrderStatus(5);
+ R r = refundPayMoney(order);
+ if (200 == r.getCode()) {
+ this.updateById(order);
+ }
+ return r;
+ }
+
+
+ /**
+ * 返回订单支付金额和回退积分和会员等级
+ *
+ * @param order
+ */
+ public R refundPayMoney(Order order) {
+ //开始退款
+ Integer payMethod = order.getPayMethod();
+ BigDecimal expressAmount = order.getExpressAmount() == null ? BigDecimal.ZERO : order.getExpressAmount();
+ BigDecimal paymentAmount = order.getPaymentAmount().add(expressAmount);
+ AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
+ if (1 == payMethod) {
+ //微信退款
+ RefundResult refund = PaymentUtil.refund(order.getOrderNumber(), "R" + order.getOrderNumber(), paymentAmount.doubleValue(), "/order/order/refundPayMoneyCallback");
+ if ("100".equals(refund.getRa_Status())) {
+ order.setRefundStatus(1);
+ return R.ok();
+ } else {
+ return R.fail(refund.getRc_CodeMsg());
+ }
+ }
+ if (2 == payMethod) {
+ //余额退款
+ OrderBalancePayment orderBalancePayment = orderBalancePaymentService.getOne(new LambdaQueryWrapper<OrderBalancePayment>().eq(OrderBalancePayment::getOrderId, order.getId()));
+ 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.setBalance(balance.add(paymentAmount).setScale(2, RoundingMode.HALF_EVEN));
+ //扣减门店消费金额
+ appUser.setShopAmount(appUser.getShopAmount().subtract(paymentAmount).setScale(2, RoundingMode.HALF_EVEN));
+ //查询最后一次的消费订单
+ Order order1 = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getAppUserId, order.getAppUserId()).eq(Order::getPayStatus, 2)
+ .eq(Order::getDelFlag, 0).in(Order::getOrderStatus, Arrays.asList(1, 2, 3, 4, 8)).ne(Order::getId, order.getId()).last(" order by create_time desc limit 0, 1"));
+ if (null != order1) {
+ appUser.setLastShopTime(order1.getCreateTime());
+ } else {
+ appUser.setLastShopTime(null);
+ }
+
+ //构建账户余额流水明细（账户支付订单的流水，不属于冻结数据）
+ BalanceChangeRecord balanceChangeRecord = new BalanceChangeRecord();
+ balanceChangeRecord.setOrderId(order.getId());
+ balanceChangeRecord.setAppUserId(order.getAppUserId());
+ balanceChangeRecord.setVipId(appUser.getVipId());
+ balanceChangeRecord.setChangeType(6);
+ balanceChangeRecord.setChangeAmount(paymentAmount);
+ balanceChangeRecord.setDelFlag(0);
+ balanceChangeRecord.setCreateTime(LocalDateTime.now());
+ balanceChangeRecord.setChangeDirection(1);
+ balanceChangeRecordClient.saveBalanceChangeRecord(balanceChangeRecord);
+
+
+ //退回获得的消费积分
+ //需要先检查会员等级时候回回退，使用回退后的会员等级查询配置
+ UserPoint userPoint1 = new UserPoint();
+ userPoint1.setType(1);
+ userPoint1.setAppUserId(appUser.getId());
+ userPoint1.setObjectId(order.getId());
+ UserPoint userPoint2 = userPointClient.getUserPointList(userPoint1).getData().get(0);
+ JSONObject jsonObject = JSON.parseObject(userPoint2.getExtention());
+ Integer shopPoint = jsonObject.getInteger("shopPoint");
+ Integer availablePoint = jsonObject.getInteger("availablePoint");
+ Integer transferablePoint = jsonObject.getInteger("transferablePoint");
+ appUser.setShopPoint(appUser.getShopPoint() - shopPoint);
+ appUser.setLavePoint(appUser.getLavePoint() - shopPoint);
+ appUser.setAvailablePoint(appUser.getAvailablePoint() - availablePoint);
+ appUser.setTotalAvailablePoint(appUser.getTotalAvailablePoint() - availablePoint);
+ if (null != transferablePoint) {
+ appUser.setTransferablePoint(appUser.getTransferablePoint() - transferablePoint);
+ }
+ appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint);
+
+ //构建积分流水明细（消费金额，不属于冻结数据）
+ if (shopPoint > 0) {
+ UserPoint userPoint = new UserPoint();
+ userPoint.setType(1);
+ userPoint.setVariablePoint(shopPoint);
+ userPoint.setCreateTime(LocalDateTime.now());
+ userPoint.setAppUserId(order.getAppUserId());
+ userPoint.setObjectId(order.getId());
+ userPoint.setChangeDirection(-1);
+ userPointClient.saveUserPoint(userPoint);
+ }
+ appUserClient.editAppUserById(appUser);
+ //回退优惠券状态
+ if (null != order.getUserCouponId()) {
+ UserCoupon userCoupon = userCouponClient.getUserCoupon(order.getUserCouponId()).getData();
+ userCoupon.setUseTime(null);
+ userCouponClient.editReturnUse(userCoupon);
+ }
+ }
+ if (3 == payMethod) {
+ //开始运费退款，积分支付，运费是单独进行支付的，所以需要单独退款
+ if (null != order.getExpressAmount() && BigDecimal.ZERO.compareTo(order.getExpressAmount()) < 0) {
+ if (1 == order.getExpressPayMethod()) {
+ //微信退款
+ RefundResult refund = PaymentUtil.refund(order.getOrderNumber(), "R" + order.getOrderNumber(), expressAmount.doubleValue(), "/order/order/refundExpressPayMoneyCallback");
+ if ("100".equals(refund.getRa_Status())) {
+ order.setRefundStatus(1);
+ return R.ok();
+ } else {
+ return R.fail(refund.getRc_CodeMsg());
+ }
+ }
+ if (2 == order.getExpressPayMethod()) {
+ //余额退款
+ OrderBalancePayment orderBalancePayment = orderBalancePaymentService.getOne(new LambdaQueryWrapper<OrderBalancePayment>().eq(OrderBalancePayment::getOrderId, order.getId()));
+ 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.setBalance(balance.add(expressAmount).setScale(2, RoundingMode.HALF_EVEN));
+ //构建账户余额流水明细（消费支付的余额流水）
+ BalanceChangeRecord balanceChangeRecord = new BalanceChangeRecord();
+ balanceChangeRecord.setOrderId(order.getId());
+ balanceChangeRecord.setAppUserId(order.getAppUserId());
+ balanceChangeRecord.setVipId(appUser.getVipId());
+ balanceChangeRecord.setChangeType(6);
+ balanceChangeRecord.setChangeAmount(expressAmount);
+ balanceChangeRecord.setDelFlag(0);
+ balanceChangeRecord.setCreateTime(LocalDateTime.now());
+ balanceChangeRecord.setChangeDirection(1);
+ balanceChangeRecordClient.saveBalanceChangeRecord(balanceChangeRecord);
+ }
+ }
+
+ Integer lavePoint = appUser.getLavePoint();
+ //积分退款
+ appUser.setLavePoint(appUser.getLavePoint() + order.getPoint());
+ appUser.setAvailablePoint(appUser.getAvailablePoint() + order.getPoint());
+ UserPoint userPoint1 = new UserPoint();
+ userPoint1.setType(11);
+ userPoint1.setObjectId(order.getId());
+ List<UserPoint> data = userPointClient.getUserPointList(userPoint1).getData();
+ Integer transferablePoint = order.getPoint();
+ if (data.size() > 0) {
+ UserPoint userPoint = data.get(0);
+ transferablePoint = Integer.valueOf(userPoint.getExtention());
+ }
+ appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint);
+
+ //构建积分流水明细（支付的积分，不属于冻结数据）
+ if (order.getPoint() > 0) {
+ UserPoint userPoint = new UserPoint();
+ userPoint.setType(11);
+ userPoint.setVariablePoint(order.getPoint());
+ userPoint.setCreateTime(LocalDateTime.now());
+ userPoint.setAppUserId(order.getAppUserId());
+ userPoint.setObjectId(order.getId());
+ userPoint.setChangeDirection(1);
+ userPointClient.saveUserPoint(userPoint);
+ }
+ appUserClient.editAppUserById(appUser);
+ }
+
+ order.setRefundStatus(2);
+ order.setRefundTime(LocalDateTime.now());
+
+ //生成反向冻结流水数据
+ List<UserPointCopy> data2 = userPointClient.getUserPointCopy(order.getId(), Arrays.asList(2, 8, 9, 10, 14)).getData();
+ for (UserPointCopy userPointCopy : data2) {
+ userPointCopy.setId(null);
+ userPointCopy.setCreateTime(LocalDateTime.now());
+ userPointCopy.setChangeDirection(-1);
+ userPointClient.saveUserPointCopy(userPointCopy);
+ }
+ List<BalanceChangeRecordCopy> data3 = balanceChangeRecordClient.getBalanceChangeRecordCopy(order.getId(), Arrays.asList(4)).getData();
+ for (BalanceChangeRecordCopy balanceChangeRecordCopy : data3) {
+ balanceChangeRecordCopy.setId(null);
+ balanceChangeRecordCopy.setCreateTime(LocalDateTime.now());
+ balanceChangeRecordCopy.setChangeDirection(-1);
+ balanceChangeRecordClient.saveBalanceChangeRecordCopy(balanceChangeRecordCopy);
+ }
+ List<ShopPointCopy> data = shopPointClient.getShopPointCopy(order.getId(), Arrays.asList(1, 2, 3)).getData();
+ for (ShopPointCopy datum : data) {
+ datum.setId(null);
+ datum.setCreateTime(LocalDateTime.now());
+ datum.setChangeDirection(-1);
+ shopPointClient.saveShopPointCopy(datum);
+ }
+ List<ShopBalanceStatementCopy> data1 = shopBalanceStatementClient.getShopBalanceStatementCopy(order.getId(), Arrays.asList(1, 2, 3)).getData();
+ for (ShopBalanceStatementCopy shopBalanceStatementCopy : data1) {
+ shopBalanceStatementCopy.setId(null);
+ shopBalanceStatementCopy.setCreateTime(LocalDateTime.now());
+ shopBalanceStatementCopy.setChangeDirection(-1);
+ shopBalanceStatementClient.saveShopBalanceStatementCopy(shopBalanceStatementCopy);
+ }
+ //删除用户和门店添加的汇总数据（冻结数据）
+ appUserGiveawayTemporaryClient.delAppUserGiveawayTemporary(order.getId());
+ shopGiveawayTemporaryClient.delShopGiveawayTemporary(order.getId());
+
+ //降级检测
+ if (1 < appUser.getVipId() && appUser.getVipId() < 4) {
+ appUserClient.vipDemotion(appUser.getId());
+ }
+ return R.ok();
+ }
+
+
+ /**
+ * 取消订单后回调处理
+ *
+ * @return
+ */
+ @Override
+ public R refundPayMoneyCallback(RefundCallbackResult refundCallbackResult) {
+ String code = refundCallbackResult.getR3_RefundOrderNo().substring(1);
+ Order order = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNumber, code));
+ if (null == order || order.getPayStatus() == 1 || order.getOrderStatus() == 6) {
+ return R.ok();
+ }
+ order.setRefundCode(refundCallbackResult.getR5_RefundTrxNo());
+ order.setRefundStatus(2);
+ order.setRefundTime(LocalDateTime.now());
+ this.updateById(order);
+ //退回获得的消费积分
+ //需要先检查会员等级时候回回退，使用回退后的会员等级查询配置
+ AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
+ Integer lavePoint = appUser.getLavePoint();
+ UserPoint userPoint1 = new UserPoint();
+ userPoint1.setType(1);
+ userPoint1.setAppUserId(appUser.getId());
+ userPoint1.setObjectId(order.getId());
+ UserPoint userPoint2 = userPointClient.getUserPointList(userPoint1).getData().get(0);
+ JSONObject jsonObject = JSON.parseObject(userPoint2.getExtention());
+ Integer shopPoint = jsonObject.getInteger("shopPoint");
+ Integer availablePoint = jsonObject.getInteger("availablePoint");
+ Integer transferablePoint = jsonObject.getInteger("transferablePoint");
+ appUser.setShopPoint(appUser.getShopPoint() - shopPoint);
+ appUser.setLavePoint(appUser.getLavePoint() - shopPoint);
+ appUser.setAvailablePoint(appUser.getAvailablePoint() - availablePoint);
+ appUser.setTotalAvailablePoint(appUser.getTotalAvailablePoint() - availablePoint);
+ if (null != transferablePoint) {
+ appUser.setTransferablePoint(appUser.getTransferablePoint() - transferablePoint);
+ }
+ appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint);
+
+ //构建积分流水明细
+ if (shopPoint > 0) {
+ UserPoint userPoint = new UserPoint();
+ userPoint.setType(1);
+ userPoint.setVariablePoint(shopPoint);
+ userPoint.setCreateTime(LocalDateTime.now());
+ userPoint.setAppUserId(order.getAppUserId());
+ userPoint.setObjectId(order.getId());
+ userPoint.setChangeDirection(-1);
+ userPointClient.saveUserPoint(userPoint);
+ }
+ appUserClient.editAppUserById(appUser);
+
+ //回退优惠券状态
+ if (null != order.getUserCouponId()) {
+ UserCoupon userCoupon = userCouponClient.getUserCoupon(order.getUserCouponId()).getData();
+ userCoupon.setUseTime(null);
+ userCouponClient.editReturnUse(userCoupon);
+ }
+
+ //生成反向冻结流水数据
+ List<UserPointCopy> data2 = userPointClient.getUserPointCopy(order.getId(), Arrays.asList(2, 8, 9, 10, 14)).getData();
+ for (UserPointCopy userPointCopy : data2) {
+ userPointCopy.setId(null);
+ userPointCopy.setCreateTime(LocalDateTime.now());
+ userPointCopy.setChangeDirection(-1);
+ userPointClient.saveUserPointCopy(userPointCopy);
+ }
+ List<BalanceChangeRecordCopy> data3 = balanceChangeRecordClient.getBalanceChangeRecordCopy(order.getId(), Arrays.asList(4)).getData();
+ for (BalanceChangeRecordCopy balanceChangeRecordCopy : data3) {
+ balanceChangeRecordCopy.setId(null);
+ balanceChangeRecordCopy.setCreateTime(LocalDateTime.now());
+ balanceChangeRecordCopy.setChangeDirection(-1);
+ balanceChangeRecordClient.saveBalanceChangeRecordCopy(balanceChangeRecordCopy);
+ }
+ List<ShopPointCopy> data = shopPointClient.getShopPointCopy(order.getId(), Arrays.asList(1, 2, 3)).getData();
+ for (ShopPointCopy datum : data) {
+ datum.setId(null);
+ datum.setCreateTime(LocalDateTime.now());
+ datum.setChangeDirection(-1);
+ shopPointClient.saveShopPointCopy(datum);
+ }
+ List<ShopBalanceStatementCopy> data1 = shopBalanceStatementClient.getShopBalanceStatementCopy(order.getId(), Arrays.asList(1, 2, 3)).getData();
+ for (ShopBalanceStatementCopy shopBalanceStatementCopy : data1) {
+ shopBalanceStatementCopy.setId(null);
+ shopBalanceStatementCopy.setCreateTime(LocalDateTime.now());
+ shopBalanceStatementCopy.setChangeDirection(-1);
+ shopBalanceStatementClient.saveShopBalanceStatementCopy(shopBalanceStatementCopy);
+ }
+ //删除用户和门店添加的汇总数据（冻结数据）
+ appUserGiveawayTemporaryClient.delAppUserGiveawayTemporary(order.getId());
+ shopGiveawayTemporaryClient.delShopGiveawayTemporary(order.getId());
+
+ //降级检测
+ if (1 < appUser.getVipId() && appUser.getVipId() < 4) {
+ appUserClient.vipDemotion(appUser.getId());
+ }
+ return R.ok();
+ }
+
+
+ /**
+ * 取消订单快递费回退
+ *
+ * @return
+ */
+ @Override
+ public R refundExpressPayMoneyCallback(RefundCallbackResult refundCallbackResult) {
+ String code = refundCallbackResult.getR3_RefundOrderNo().substring(1);
+ Order order = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNumber, code));
+ if (null == order || order.getPayStatus() == 1 || order.getOrderStatus() == 6) {
+ return R.ok();
+ }
+ order.setRefundCode(refundCallbackResult.getR5_RefundTrxNo());
+ order.setRefundStatus(2);
+ order.setRefundTime(LocalDateTime.now());
+ this.updateById(order);
+
+ AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
+ Integer lavePoint = appUser.getLavePoint();
+ //积分退款
+ appUser.setLavePoint(appUser.getLavePoint() + order.getPoint());
+ appUser.setAvailablePoint(appUser.getAvailablePoint() + order.getPoint());
+ UserPoint userPoint1 = new UserPoint();
+ userPoint1.setType(11);
+ userPoint1.setObjectId(order.getId());
+ List<UserPoint> data = userPointClient.getUserPointList(userPoint1).getData();
+ Integer transferablePoint = order.getPoint();
+ if (data.size() > 0) {
+ UserPoint userPoint = data.get(0);
+ transferablePoint = Integer.valueOf(userPoint.getExtention());
+ }
+ appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint);
+
+ //构建积分流水明细
+ if (order.getPoint() > 0) {
+ UserPoint userPoint = new UserPoint();
+ userPoint.setType(11);
+ userPoint.setVariablePoint(order.getPoint());
+ userPoint.setCreateTime(LocalDateTime.now());
+ userPoint.setAppUserId(order.getAppUserId());
+ userPoint.setObjectId(order.getId());
+ userPoint.setChangeDirection(1);
+ userPointClient.saveUserPoint(userPoint);
+ }
+ return R.ok();
+ }
+
+
+ /**
+ * 收货操作
+ *
+ * @param orderId
+ * @return
+ */
+ @Override
+ public R receivingOperation(Long orderId) {
+ Order order = this.getById(orderId);
+ if (order.getOrderStatus() != 2) {
+ return R.fail("无效的操作");
+ }
+ order.setOrderStatus(4);
+ R<BaseSetting> baseSettingR = baseSettingClient.getBaseSetting(5);
+ if (R.isError(baseSettingR)) {
+ return R.fail("售后设置获取失败");
+ }
+ BaseSetting baseSetting = baseSettingR.getData();
+ if (baseSetting == null) {
+ return R.fail("售后设置获取失败");
+ }
+ String content = baseSetting.getContent();
+ JSONObject jsonObject = JSONObject.parseObject(content);
+ Long days = jsonObject.getLong("days");
+ order.setAfterSaleTime(LocalDateTime.now().plusDays(days));
+ this.updateById(order);
+ return R.ok();
+ }
+
+
+ /**
+ * 获取订单详情
+ *
+ * @param orderId
+ * @return
+ */
+ @Override
+ public OrderInfoVo getOrderInfo(Long orderId) {
+ Order order = this.getById(orderId);
+ OrderInfoVo orderInfo = new OrderInfoVo();
+ orderInfo.setId(orderId.toString());
+ orderInfo.setOrderNumber(order.getOrderNumber());
+ orderInfo.setOrderStatus(order.getOrderStatus());
+ orderInfo.setCreateTime(order.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+ AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
+ if (null != appUser) {
+ orderInfo.setUserName(appUser.getName());
+ orderInfo.setPhone(appUser.getPhone());
+ }
+ orderInfo.setOrderType(order.getOrderType() == 1 ? "服务" : (StringUtils.isNotEmpty(order.getAddressJson()) ? "单品-快递配送" : "单品-上门自提"));
+ Shop shop = shopClient.getShopById(order.getShopId()).getData();
+ if (null != shop) {
+ orderInfo.setShopName(shop.getName());
+ }
+ orderInfo.setPaymentMethod(order.getPayMethod());
+ orderInfo.setTotalAmount(order.getTotalAmount());
+ if (StringUtils.isNotEmpty(order.getCouponJson())) {
+ CouponInfo couponInfo = JSON.parseObject(order.getCouponJson(), CouponInfo.class);
+ orderInfo.setCouponName(couponInfo.getCouponName());
+ }
+ orderInfo.setDiscountAmount(order.getDiscountTotalAmount());
+ orderInfo.setExpressAmount(order.getExpressAmount());
+ orderInfo.setPaymentAmount(order.getPaymentAmount());
+ orderInfo.setGetPoint(order.getGetPoint());
+ if (2 == order.getDistributionMode()) {
+ UserAddress userAddress = JSON.parseObject(order.getAddressJson(), UserAddress.class);
+ orderInfo.setRecipient(userAddress.getRecieveName() + "-" + userAddress.getRecievePhone());
+ userAddress.setRecieveAddress(userAddress.getProvince() + userAddress.getCity() + userAddress.getDistrict() + userAddress.getRecieveAddress());
+ orderInfo.setAddress(userAddress.getRecieveAddress());
+ MapTrackKD100Vo mapTrackKD100Vo = JSON.parseObject(order.getExpressResult(), MapTrackKD100Vo.class);
+ orderInfo.setExpress(mapTrackKD100Vo);
+ }
+ if (StringUtils.isNotEmpty(order.getExpressJson()) && !order.getExpressJson().equals("NULL")){
+ JSONObject jsonObject = JSON.parseObject(order.getExpressJson());
+ orderInfo.setExpressCompany(jsonObject.getString("com"));
+ orderInfo.setExpressNumber(jsonObject.getString("num"));
+ }
+
+ List<OrderGood> orderGoods = orderGoodMapper.selectList(new LambdaQueryWrapper<OrderGood>().eq(OrderGood::getOrderId, orderId).eq(OrderGood::getDelFlag, 0));
+ int sum = orderGoods.stream().mapToInt(OrderGood::getNum).sum();
+ orderInfo.setGoodsNum(sum);
+ List<Object> goodsJson = new ArrayList<>();
+ for (OrderGood orderGood : orderGoods) {
+ Goods goods = JSON.parseObject(orderGood.getGoodJson(), Goods.class);
+ Map<String, Object> map = new HashMap<>();
+ map.put("name", goods.getName());
+ map.put("imgUrl", goods.getHomePagePicture());
+ map.put("number", orderGood.getNum());
+ goodsJson.add(map);
+ }
+ orderInfo.setGoodsJson(JSON.toJSONString(goodsJson));
+ orderInfo.setPoint(order.getPoint());
+ if (null != order.getAfterSaleTime()) {
+ orderInfo.setAfterSaleTime(order.getAfterSaleTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+ }
+ if (StringUtils.isNotEmpty(order.getActivityJson())) {
+ OrderActivityInfo activityInfo = JSON.parseObject(order.getActivityJson(), OrderActivityInfo.class);
+ orderInfo.setActivityName(activityInfo.getActivityName());
+ }
+ if (null != order.getEndTime()) {
+ AppUser user = appUserClient.getAppUserById(order.getCancellerAppUserId());
+ orderInfo.setCanceller(user.getName());
+ orderInfo.setWriteOffTime(order.getEndTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
+ }
+ if (order.getOrderType() == 1) {
+ List<TechnicianSubscribe> technicianSubscribes = technicianSubscribeClient.getTechnicianSubscribeList(order.getId()).getData();
+ if (technicianSubscribes.size() > 0) {
+ Set<Integer> collect = technicianSubscribes.stream().map(TechnicianSubscribe::getTechnicianId).collect(Collectors.toSet());
+ List<Technician> data = technicianClient.getTechnicianByIds(collect).getData();
+ orderInfo.setTechnicianName(data.stream().map(Technician::getName).collect(Collectors.joining(",")));
+ }
+ }
+ List<ShopBalanceStatement> data = shopBalanceStatementClient.getShopBalanceStatementList(Arrays.asList(1, 2, 3), order.getId()).getData();
+ BigDecimal reduce = data.stream().map(ShopBalanceStatement::getVariableAmount).reduce(BigDecimal.ZERO, BigDecimal::add);
+ orderInfo.setSubcommission(reduce);
+ return orderInfo;
+ }
+
+
+ /**
+ * 获取商品销售数量
+ *
+ * @param goodsId
+ * @return
+ */
+ @Override
+ public Integer getGoodsSaleNum(Integer goodsId, Integer type, Long userId) {
+ return this.baseMapper.getGoodsSaleNum(goodsId, type, userId);
+ }
+
+
+ /**
+ * 获取店铺订单数量
+ *
+ * @param shopId
+ * @param type
+ * @return
+ */
+ @Override
+ public Integer getShopSaleNum(Integer shopId, Integer type) {
+ return this.baseMapper.getShopSaleNum(shopId, type);
+ }
+
+
+ /**
+ * 定时查询快递信息
+ */
+ @Override
+ public void taskExpress() {
+ Set<Long> order_express = redisTemplate.opsForZSet().rangeByScore("order_express", 0, LocalDateTime.now().toEpochSecond(ZoneOffset.UTC));
+ if (order_express.size() > 0) {
+ for (Long id : order_express) {
+ Order order = this.getById(id);
+ if (order == null){
+ redisTemplate.opsForZSet().remove("order_express", id);
+ continue;
+ }
+ if (order.getOrderStatus() != 2) {
+ redisTemplate.opsForZSet().remove("order_express", id);
+ continue;
+ }
+ String expressJson = order.getExpressJson();
+ if (StringUtils.isEmpty(expressJson)) {
+ redisTemplate.opsForZSet().remove("order_express", id);
+ continue;
+ }
+ //{"com":"jd","num":"JDV016336234367"}
+ JSONObject jsonObject = JSON.parseObject(expressJson);
+ String com = jsonObject.getString("com");
+ String num = jsonObject.getString("num");
+ UserAddress userAddress = JSON.parseObject(order.getAddressJson(), UserAddress.class);
+ MapTrackKD100Vo mapTrackKD100Vo = ExpressDeliveryUtil.kd100MapTrack(com, num, order.getDeliverProvince() + order.getDeliverCity(),
+ userAddress.getProvince() + userAddress.getCity());
+ order.setExpressResult(JSON.toJSONString(mapTrackKD100Vo));
+ this.updateById(order);
+ //延长时间x小时
+ SystemConfig systemConfig = systemConfigClient.getSystemConfig(3).getData();
+ JSONObject jsonObject1 = JSON.parseObject(systemConfig.getContent());
+ Integer waitTime = jsonObject1.getInteger("waitTime");
+ redisTemplate.opsForZSet().add("order_express", order.getId(), LocalDateTime.now().plusHours(waitTime).toEpochSecond(ZoneOffset.UTC));
+ }
+ }
+ }
+
+ @Override
+ @Transactional(rollbackFor = Exception.class)
+ public void importExpress(String url) {
+ URL url1 = null;
+ try {
+ url1 = new URL(url);
+ } catch (MalformedURLException e) {
+ throw new RuntimeException(e);
+ }
+ try (InputStream fileInputStream = url1.openStream()) {
+ Workbook workbook = new XSSFWorkbook(fileInputStream);
+ Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet
+ int lastRowNum = sheet.getLastRowNum();
+ for (int i = 1; i <= lastRowNum; i++) {
+ Row row = sheet.getRow(i);
+ // 订单编号
+ if (row.getCell(0) == null){
+ throw new ServiceException("第" + i + "行订单编号为空", 500);
+ }
+ row.getCell(0).setCellType(CellType.STRING);
+ String orderNum = row.getCell(0).getStringCellValue();
+ // 快递单号
+ if (row.getCell(1) == null){
+ throw new ServiceException("第" + i + "行快递单号为空", 500);
+ }
+ row.getCell(1).setCellType(CellType.STRING);
+ String expressNum = row.getCell(1).getStringCellValue();
+ // 快递公司名称
+ if (row.getCell(2) == null){
+ throw new ServiceException("第" + i + "行快递公司为空", 500);
+ }
+ row.getCell(2).setCellType(CellType.STRING);
+ String expressName = row.getCell(2).getStringCellValue();
+ // 省区划代码
+ if (row.getCell(3) == null){
+ throw new ServiceException("第" + i + "行省区划代码为空", 500);
+ }
+ row.getCell(3).setCellType(CellType.STRING);
+ String provinceCode = row.getCell(3).getStringCellValue();
+ // 市区划代码
+ if (row.getCell(4) == null){
+ throw new ServiceException("第" + i + "行市区划代码为空", 500);
+ }
+ row.getCell(4).setCellType(CellType.STRING);
+ String cityCode = row.getCell(4).getStringCellValue();
+ Order order = this.getOne(new LambdaQueryWrapper<Order>()
+ .eq(Order::getOrderNumber, orderNum)
+ );
+ if (order == null) {
+ throw new ServiceException("订单不存在：" + orderNum, 500);
+ }
+
+ Integer orderType = order.getOrderType();
+ if (orderType != 2) {
+ throw new ServiceException("该订单：" + orderNum + "类型不为单品订单", 500);
+ }
+ if (order.getDistributionMode() != 2) {
+ throw new ServiceException("该订单：" + orderNum + "配送方式不为快递", 500);
+ }
+ Integer orderStatus = order.getOrderStatus();
+ if (orderStatus != 1) {
+ throw new ServiceException("该订单：" + orderNum + "状态不为待发货", 500);
+ }
+
+ String companyNameByCode = ExpressCompanyMap.getCodeByCompanyName(expressName);
+ if (StringUtils.isEmpty(companyNameByCode)) {
+ throw new ServiceException("快递公司名称错误：" + expressName, 500);
+ }
+
+ R<Region> regionBiCode = regionClient.getRegionBiCode(provinceCode);
+ if (regionBiCode.getData() == null) {
+ throw new ServiceException("省份编码错误：" + provinceCode, 500);
+ }
+ R<Region> regionBiCode1 = regionClient.getRegionBiCode(cityCode);
+ if (regionBiCode1.getData() == null) {
+ throw new ServiceException("城市编码错误：" + cityCode, 500);
+ }
+ JSONObject jsonObject = new JSONObject();
+ jsonObject.put("com", companyNameByCode);
+ jsonObject.put("num", expressNum);
+ ConfirmDelivery confirmDelivery = new ConfirmDelivery();
+ confirmDelivery.setOrderId(order.getId());
+ confirmDelivery.setCode(jsonObject.toJSONString());
+ confirmDelivery.setDeliverProvince(regionBiCode.getData().getName());
+ confirmDelivery.setDeliverProvinceCode(regionBiCode.getData().getCode());
+ confirmDelivery.setDeliverCity(regionBiCode1.getData().getName());
+ confirmDelivery.setDeliverCityCode(regionBiCode1.getData().getCode());
+ R r = confirmDelivery(confirmDelivery);
+ if (R.isError(r)) {
+ throw new ServiceException(r.getMsg(), 500);
+ }
+ }
+
+ } catch (IOException e) {
+ e.printStackTrace();
+ throw new ServiceException(e.getMessage());
+ }
+
+
+ }
+
/**
* 确认发货操作
+ *
* @return
*/
@Override
public R confirmDelivery(ConfirmDelivery confirmDelivery) {
Order order = this.getById(confirmDelivery.getOrderId());
- if(1 == order.getPayStatus()){
+ if (1 == order.getPayStatus()) {
return R.fail("订单还未完成支付");
}
- if(1 == order.getOrderType() || null == order.getAddressJson()){
+ if (1 == order.getOrderType() || null == order.getAddressJson()) {
return R.fail("该订单不支付快递配送");
}
- if(1 != order.getOrderStatus()){
+ if (1 != order.getOrderStatus()) {
return R.fail("无效的操作");
}
//添加快递号和修改订单状态
@@ -489,577 +1163,18 @@
userAddress.getProvince() + userAddress.getCity());
order.setExpressResult(JSON.toJSONString(mapTrackKD100Vo));
this.updateById(order);
+
+ // 发布事件
+ applicationEventPublisher.publishEvent(new ConfirmDeliveryEvent(order.getId()));
return R.ok();
}
-
-
- /**
- * 取消订单操作
- * @param orderId
- * @return
- */
- @Override
- public R cancelOrder(Long orderId) {
- Order order = this.getById(orderId);
- if(Arrays.asList(5, 6, 7).contains(order.getOrderStatus())){
- return R.fail("无效的操作");
- }
- if(null != order.getAfterSaleTime() && LocalDateTime.now().isAfter(order.getAfterSaleTime())){
- return R.fail("订单取消失败");
- }
- order.setOrderStatus(5);
- R r = refundPayMoney(order);
- if(200 == r.getCode()){
- this.updateById(order);
- }
- return r;
- }
-
-
- /**
- * 返回订单支付金额和回退积分和会员等级
- * @param order
- */
- public R refundPayMoney(Order order){
- //开始退款
- Integer payMethod = order.getPayMethod();
- BigDecimal paymentAmount = order.getPaymentAmount();
- AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
- if(1 == payMethod){
- //微信退款
- RefundResult refund = PaymentUtil.refund(order.getOrderNumber(), "R" + order.getOrderNumber(), paymentAmount.doubleValue(), "/order/order/refundPayMoneyCallback");
- if("100".equals(refund.getRa_Status())){
- order.setRefundStatus(1);
- return R.ok();
- }else{
- return R.fail(refund.getRc_CodeMsg());
- }
- }
- if(2 == payMethod){
- //余额退款
- OrderBalancePayment orderBalancePayment = orderBalancePaymentService.getOne(new LambdaQueryWrapper<OrderBalancePayment>().eq(OrderBalancePayment::getOrderId, order.getId()));
- 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.setBalance(balance.add(paymentAmount).setScale(2, RoundingMode.HALF_EVEN));
- appUser.setShopAmount(appUser.getShopAmount().subtract(paymentAmount).setScale(2, RoundingMode.HALF_EVEN));
- //查询最后一次的消费订单
- Order order1 = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getAppUserId, order.getAppUserId()).eq(Order::getPayStatus, 2)
- .eq(Order::getDelFlag, 0).in(Order::getOrderStatus, Arrays.asList(1, 2, 3, 4, 8)).ne(Order::getId, order.getId()).last(" order by create_time desc limit 0, 1"));
- if(null != order1){
- appUser.setLastShopTime(order1.getCreateTime());
- }else{
- appUser.setLastShopTime(null);
- }
-
- //构建账户余额流水明细
- BalanceChangeRecord balanceChangeRecord = new BalanceChangeRecord();
- balanceChangeRecord.setOrderId(order.getId());
- balanceChangeRecord.setAppUserId(order.getAppUserId());
- balanceChangeRecord.setVipId(appUser.getVipId());
- balanceChangeRecord.setChangeType(6);
- balanceChangeRecord.setBeforeAmount(balance);
- balanceChangeRecord.setChangeAmount(paymentAmount);
- balanceChangeRecord.setAfterAmount(appUser.getBalance());
- balanceChangeRecord.setDelFlag(0);
- balanceChangeRecord.setCreateTime(LocalDateTime.now());
- balanceChangeRecordClient.saveBalanceChangeRecord(balanceChangeRecord);
-
- //退回获得的消费积分
- //需要先检查会员等级时候回回退，使用回退后的会员等级查询配置
- Integer lavePoint = appUser.getLavePoint();
-
- UserPoint userPoint1 = new UserPoint();
- userPoint1.setType(1);
- userPoint1.setAppUserId(appUser.getId());
- userPoint1.setObjectId(order.getId());
- UserPoint userPoint2 = userPointClient.getUserPointList(userPoint1).getData().get(0);
- JSONObject jsonObject = JSON.parseObject(userPoint2.getExtention());
- Integer shopPoint = jsonObject.getInteger("shopPoint");
- Integer availablePoint = jsonObject.getInteger("availablePoint");
- Integer transferablePoint = jsonObject.getInteger("transferablePoint");
- appUser.setShopPoint(appUser.getShopPoint() - shopPoint);
- appUser.setLavePoint(appUser.getLavePoint() - shopPoint);
- appUser.setAvailablePoint(appUser.getAvailablePoint() - availablePoint);
- appUser.setTotalAvailablePoint(appUser.getTotalAvailablePoint() - availablePoint);
- if(null != transferablePoint){
- appUser.setTransferablePoint(appUser.getTransferablePoint() - transferablePoint);
- }
- appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint);
-
- //构建积分流水明细
- 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();
- userCoupon.setUseTime(null);
- userCouponClient.editReturnUse(userCoupon);
- }
- }
- if(3 == payMethod){
- //开始运费退款，积分支付，运费是单独进行支付的，所以需要单独退款
- if(null != order.getExpressAmount() && BigDecimal.ZERO.compareTo(order.getExpressAmount()) < 0){
- BigDecimal expressAmount = order.getExpressAmount();
- if(1 == order.getExpressPayMethod()){
- //微信退款
- RefundResult refund = PaymentUtil.refund(order.getOrderNumber(), "R" + order.getOrderNumber(), expressAmount.doubleValue(), "/order/order/refundExpressPayMoneyCallback");
- if("100".equals(refund.getRa_Status())){
- order.setRefundStatus(1);
- return R.ok();
- }else{
- return R.fail(refund.getRc_CodeMsg());
- }
- }
- if(2 == order.getExpressPayMethod()){
- //余额退款
- OrderBalancePayment orderBalancePayment = orderBalancePaymentService.getOne(new LambdaQueryWrapper<OrderBalancePayment>().eq(OrderBalancePayment::getOrderId, order.getId()));
- 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.setBalance(balance.add(expressAmount).setScale(2, RoundingMode.HALF_EVEN));
- //构建账户余额流水明细
- BalanceChangeRecord balanceChangeRecord = new BalanceChangeRecord();
- balanceChangeRecord.setOrderId(order.getId());
- balanceChangeRecord.setAppUserId(order.getAppUserId());
- balanceChangeRecord.setVipId(appUser.getVipId());
- balanceChangeRecord.setChangeType(6);
- balanceChangeRecord.setBeforeAmount(balance);
- balanceChangeRecord.setChangeAmount(expressAmount);
- balanceChangeRecord.setAfterAmount(appUser.getBalance());
- balanceChangeRecord.setDelFlag(0);
- balanceChangeRecord.setCreateTime(LocalDateTime.now());
- balanceChangeRecordClient.saveBalanceChangeRecord(balanceChangeRecord);
- }
- }
-
- Integer lavePoint = appUser.getLavePoint();
- //积分退款
- appUser.setLavePoint(appUser.getLavePoint() + order.getPoint());
- appUser.setAvailablePoint(appUser.getAvailablePoint() + order.getPoint());
- UserPoint userPoint1 = new UserPoint();
- userPoint1.setType(11);
- userPoint1.setObjectId(order.getId());
- List<UserPoint> data = userPointClient.getUserPointList(userPoint1).getData();
- Integer transferablePoint = order.getPoint();
- if(data.size() > 0){
- UserPoint userPoint = data.get(0);
- transferablePoint = Integer.valueOf(userPoint.getExtention());
- }
- appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint);
-
- //构建积分流水明细
- 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);
- }
-
- order.setRefundStatus(2);
- order.setRefundTime(LocalDateTime.now());
- return R.ok();
- }
-
-
- /**
- * 取消订单后回调处理
- * @return
- */
- @Override
- public R refundPayMoneyCallback(RefundCallbackResult refundCallbackResult) {
- String code = refundCallbackResult.getR3_RefundOrderNo().substring(1);
- Order order = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNumber, code));
- if(null == order || order.getPayStatus() == 1 || order.getOrderStatus() == 6){
- return R.ok();
- }
- order.setRefundCode(refundCallbackResult.getR5_RefundTrxNo());
- order.setRefundStatus(2);
- order.setRefundTime(LocalDateTime.now());
- this.updateById(order);
- //退回获得的消费积分
- //需要先检查会员等级时候回回退，使用回退后的会员等级查询配置
- AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
- Integer lavePoint = appUser.getLavePoint();
- UserPoint userPoint1 = new UserPoint();
- userPoint1.setType(1);
- userPoint1.setAppUserId(appUser.getId());
- userPoint1.setObjectId(order.getId());
- UserPoint userPoint2 = userPointClient.getUserPointList(userPoint1).getData().get(0);
- JSONObject jsonObject = JSON.parseObject(userPoint2.getExtention());
- Integer shopPoint = jsonObject.getInteger("shopPoint");
- Integer availablePoint = jsonObject.getInteger("availablePoint");
- Integer transferablePoint = jsonObject.getInteger("transferablePoint");
- appUser.setShopPoint(appUser.getShopPoint() - shopPoint);
- appUser.setLavePoint(appUser.getLavePoint() - shopPoint);
- appUser.setAvailablePoint(appUser.getAvailablePoint() - availablePoint);
- appUser.setTotalAvailablePoint(appUser.getTotalAvailablePoint() - availablePoint);
- if(null != transferablePoint){
- appUser.setTransferablePoint(appUser.getTransferablePoint() - transferablePoint);
- }
- appUser.setTotalPoint(appUser.getTotalPoint() - shopPoint);
-
- //构建积分流水明细
- 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();
- userCoupon.setUseTime(null);
- userCouponClient.editReturnUse(userCoupon);
- }
- return R.ok();
- }
-
-
- /**
- * 取消订单快递费回退
- * @return
- */
- @Override
- public R refundExpressPayMoneyCallback(RefundCallbackResult refundCallbackResult) {
- String code = refundCallbackResult.getR3_RefundOrderNo().substring(1);
- Order order = this.getOne(new LambdaQueryWrapper<Order>().eq(Order::getOrderNumber, code));
- if(null == order || order.getPayStatus() == 1 || order.getOrderStatus() == 6){
- return R.ok();
- }
- order.setRefundCode(refundCallbackResult.getR5_RefundTrxNo());
- order.setRefundStatus(2);
- order.setRefundTime(LocalDateTime.now());
- this.updateById(order);
-
- AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
- Integer lavePoint = appUser.getLavePoint();
- //积分退款
- appUser.setLavePoint(appUser.getLavePoint() + order.getPoint());
- appUser.setAvailablePoint(appUser.getAvailablePoint() + order.getPoint());
- UserPoint userPoint1 = new UserPoint();
- userPoint1.setType(11);
- userPoint1.setObjectId(order.getId());
- List<UserPoint> data = userPointClient.getUserPointList(userPoint1).getData();
- Integer transferablePoint = order.getPoint();
- if(data.size() > 0){
- UserPoint userPoint = data.get(0);
- transferablePoint = Integer.valueOf(userPoint.getExtention());
- }
- appUser.setTransferablePoint(appUser.getTransferablePoint() + transferablePoint);
-
- //构建积分流水明细
- 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();
- }
-
-
-
-
- /**
- * 收货操作
- * @param orderId
- * @return
- */
- @Override
- public R receivingOperation(Long orderId) {
- Order order = this.getById(orderId);
- if(order.getOrderStatus() != 2){
- return R.fail("无效的操作");
- }
- order.setOrderStatus(4);
- R<BaseSetting> baseSettingR = baseSettingClient.getBaseSetting(5);
- if (R.isError(baseSettingR)) {
- return R.fail("售后设置获取失败");
- }
- BaseSetting baseSetting = baseSettingR.getData();
- if (baseSetting == null) {
- return R.fail("售后设置获取失败");
- }
- String content = baseSetting.getContent();
- JSONObject jsonObject = JSONObject.parseObject(content);
- Long days = jsonObject.getLong("days");
- order.setAfterSaleTime(LocalDateTime.now().plusDays(days));
- this.updateById(order);
- return R.ok();
- }
-
-
- /**
- * 获取订单详情
- * @param orderId
- * @return
- */
- @Override
- public OrderInfoVo getOrderInfo(Long orderId) {
- Order order = this.getById(orderId);
- OrderInfoVo orderInfo = new OrderInfoVo();
- orderInfo.setId(orderId.toString());
- orderInfo.setOrderNumber(order.getOrderNumber());
- orderInfo.setOrderStatus(order.getOrderStatus());
- orderInfo.setCreateTime(order.getCreateTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
- AppUser appUser = appUserClient.getAppUserById(order.getAppUserId());
- if(null != appUser){
- orderInfo.setUserName(appUser.getName());
- orderInfo.setPhone(appUser.getPhone());
- }
- orderInfo.setOrderType(order.getOrderType() == 1 ? "服务" : (StringUtils.isNotEmpty(order.getAddressJson()) ? "单品-快递配送" : "单品-上门自提"));
- Shop shop = shopClient.getShopById(order.getShopId()).getData();
- if(null != shop){
- orderInfo.setShopName(shop.getName());
- }
- orderInfo.setPaymentMethod(order.getPayMethod());
- orderInfo.setTotalAmount(order.getTotalAmount());
- if(StringUtils.isNotEmpty(order.getCouponJson())){
- CouponInfo couponInfo = JSON.parseObject(order.getCouponJson(), CouponInfo.class);
- orderInfo.setCouponName(couponInfo.getCouponName());
- }
- orderInfo.setDiscountAmount(order.getDiscountTotalAmount());
- orderInfo.setExpressAmount(order.getExpressAmount());
- orderInfo.setPaymentAmount(order.getPaymentAmount());
- orderInfo.setGetPoint(order.getGetPoint());
- if(2 == order.getDistributionMode()){
- UserAddress userAddress = JSON.parseObject(order.getAddressJson(), UserAddress.class);
- orderInfo.setRecipient(userAddress.getRecieveName() + "-" + userAddress.getRecievePhone());
- userAddress.setRecieveAddress(userAddress.getProvince() + userAddress.getCity() + userAddress.getDistrict() + userAddress.getRecieveAddress());
- orderInfo.setAddress(userAddress.getRecieveAddress());
- MapTrackKD100Vo mapTrackKD100Vo = JSON.parseObject(order.getExpressResult(), MapTrackKD100Vo.class);
- orderInfo.setExpress(mapTrackKD100Vo);
- }
- 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) {
- Goods goods = JSON.parseObject(orderGood.getGoodJson(), Goods.class);
- Map<String, Object> map = new HashMap<>();
- map.put("name", goods.getName());
- map.put("imgUrl", goods.getHomePagePicture());
- map.put("number", orderGood.getNum());
- goodsJson.add(map);
- }
- orderInfo.setGoodsJson(JSON.toJSONString(goodsJson));
- orderInfo.setPoint(order.getPoint());
- if(null != order.getAfterSaleTime()){
- orderInfo.setAfterSaleTime(order.getAfterSaleTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
- }
- if(StringUtils.isNotEmpty(order.getActivityJson())){
- OrderActivityInfo activityInfo = JSON.parseObject(order.getActivityJson(), OrderActivityInfo.class);
- orderInfo.setActivityName(activityInfo.getActivityName());
- }
- if(null != order.getEndTime()){
- AppUser user = appUserClient.getAppUserById(order.getCancellerAppUserId());
- orderInfo.setCanceller(user.getName());
- orderInfo.setWriteOffTime(order.getEndTime().format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss")));
- }
- if(order.getOrderType() == 1){
- List<TechnicianSubscribe> technicianSubscribes = technicianSubscribeClient.getTechnicianSubscribeList(order.getId()).getData();
- if(technicianSubscribes.size() > 0){
- Set<Integer> collect = technicianSubscribes.stream().map(TechnicianSubscribe::getTechnicianId).collect(Collectors.toSet());
- List<Technician> data = technicianClient.getTechnicianByIds(collect).getData();
- orderInfo.setTechnicianName(data.stream().map(Technician::getName).collect(Collectors.joining(",")));
- }
- }
- List<ShopBalanceStatement> data = shopBalanceStatementClient.getShopBalanceStatementList(Arrays.asList(1, 2, 3), order.getId()).getData();
- BigDecimal reduce = data.stream().map(ShopBalanceStatement::getVariableAmount).reduce(BigDecimal.ZERO, BigDecimal::add);
- orderInfo.setSubcommission(reduce);
- return orderInfo;
- }
-
-
- /**
- * 获取商品销售数量
- * @param goodsId
- * @return
- */
- @Override
- public Integer getGoodsSaleNum(Integer goodsId, Integer type, Long userId) {
- return this.baseMapper.getGoodsSaleNum(goodsId, type, userId);
- }
-
-
- /**
- * 获取店铺订单数量
- * @param shopId
- * @param type
- * @return
- */
- @Override
- public Integer getShopSaleNum(Integer shopId, Integer type) {
- return this.baseMapper.getShopSaleNum(shopId, type);
- }
-
-
- /**
- * 定时查询快递信息
- */
- @Override
- public void taskExpress() {
- Set<Long> order_express = redisTemplate.opsForZSet().rangeByScore("order_express", 0, LocalDateTime.now().toEpochSecond(ZoneOffset.UTC));
- if(order_express.size() > 0){
- for (Long id : order_express) {
- Order order = this.getById(id);
- if(order.getOrderStatus() != 2){
- redisTemplate.opsForZSet().remove("order_express", id);
- continue;
- }
- String expressJson = order.getExpressJson();
- if(StringUtils.isEmpty(expressJson)){
- redisTemplate.opsForZSet().remove("order_express", id);
- continue;
- }
- //{"com":"jd","num":"JDV016336234367"}
- JSONObject jsonObject = JSON.parseObject(expressJson);
- String com = jsonObject.getString("com");
- String num = jsonObject.getString("num");
- UserAddress userAddress = JSON.parseObject(order.getAddressJson(), UserAddress.class);
- MapTrackKD100Vo mapTrackKD100Vo = ExpressDeliveryUtil.kd100MapTrack(com, num, order.getDeliverProvince() + order.getDeliverCity(),
- userAddress.getProvince() + userAddress.getCity());
- order.setExpressResult(JSON.toJSONString(mapTrackKD100Vo));
- this.updateById(order);
- //延长时间x小时
- SystemConfig systemConfig = systemConfigClient.getSystemConfig(3).getData();
- JSONObject jsonObject1 = JSON.parseObject(systemConfig.getContent());
- Integer waitTime = jsonObject1.getInteger("waitTime");
- redisTemplate.opsForZSet().add("order_express", order.getId(), LocalDateTime.now().plusHours(waitTime).toEpochSecond(ZoneOffset.UTC));
- }
- }
- }
-
- @SneakyThrows
- @Override
- @Transactional(rollbackFor = Exception.class)
- public void importExpress(String url) {
- URL url1 = new URL(url);
- try (InputStream fileInputStream = url1.openStream()) {
- Workbook workbook = new XSSFWorkbook(fileInputStream);
- Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet
- int lastRowNum = sheet.getLastRowNum();
- for (int i = 1; i <= lastRowNum; i++) {
- Row row = sheet.getRow(i);
- // 订单编号
- row.getCell(0).setCellType(CellType.STRING);
- String orderNum = row.getCell(0).getStringCellValue();
- // 快递单号
- row.getCell(1).setCellType(CellType.STRING);
- String expressNum = row.getCell(1).getStringCellValue();
- // 快递公司名称
- row.getCell(2).setCellType(CellType.STRING);
- String expressName = row.getCell(2).getStringCellValue();
- // 省区划代码
- row.getCell(3).setCellType(CellType.STRING);
- String provinceCode = row.getCell(3).getStringCellValue();
- // 市区划代码
- row.getCell(4).setCellType(CellType.STRING);
- String cityCode = row.getCell(4).getStringCellValue();
- Order order = this.getOne(new LambdaQueryWrapper<Order>()
- .eq(Order::getOrderNumber, orderNum)
- );
- if (order == null){
- throw new ServiceException("订单不存在："+orderNum, 500);
- }
-
- Integer orderType = order.getOrderType();
- if (orderType != 2){
- throw new ServiceException("该订单："+orderNum+"类型不为单品订单", 500);
- }
- if (order.getDistributionMode() != 2){
- throw new ServiceException("该订单："+orderNum+"配送方式不为快递", 500);
- }
- Integer orderStatus = order.getOrderStatus();
- if (orderStatus != 1){
- throw new ServiceException("该订单："+orderNum+"状态不为待发货", 500);
- }
-
- String companyNameByCode = ExpressCompanyMap.getCodeByCompanyName(expressName);
- if(StringUtils.isEmpty(companyNameByCode)){
- throw new ServiceException("快递公司名称错误："+expressName, 500);
- }
-
- R<Region> regionBiCode = regionClient.getRegionBiCode(provinceCode);
- if (regionBiCode.getData() == null) {
- throw new ServiceException("省份编码错误："+provinceCode, 500);
- }
- R<Region> regionBiCode1 = regionClient.getRegionBiCode(cityCode);
- if (regionBiCode1.getData() == null) {
- throw new ServiceException("城市编码错误："+cityCode, 500);
- }
- JSONObject jsonObject = new JSONObject();
- jsonObject.put("com", companyNameByCode);
- jsonObject.put("num", expressNum);
- ConfirmDelivery confirmDelivery =new ConfirmDelivery();
- confirmDelivery.setOrderId(order.getId());
- confirmDelivery.setCode(jsonObject.toJSONString());
- confirmDelivery.setDeliverProvince(regionBiCode.getData().getName());
- confirmDelivery.setDeliverProvinceCode(regionBiCode.getData().getCode());
- confirmDelivery.setDeliverCity(regionBiCode1.getData().getName());
- confirmDelivery.setDeliverCityCode(regionBiCode1.getData().getCode());
- confirmDelivery(confirmDelivery);
- }
-
- } catch (IOException e) {
- e.printStackTrace();
- throw new ServiceException(e.getMessage());
- }
-
-
- }
public static void importExpress2(String filePath) throws MalformedURLException {
// 从网络地址读取
URL url = new URL(filePath);
- try (InputStream fileInputStream = url.openStream()) {
+ try (InputStream fileInputStream = url.openStream()) {
Workbook workbook = new XSSFWorkbook(fileInputStream);
Sheet sheet = workbook.getSheetAt(0); // 获取第一个Sheet
@@ -1083,4 +1198,25 @@
}
}
+ @Override
+ public Integer getShopSaleNumByShopIds(List<Integer> shopIds, Integer type) {
+ return this.baseMapper.getShopSaleNumByShopIds(shopIds, type);
+ }
+
+ @Override
+ public List<OrderExport> getOrderExportList(OrderPageList orderPageList) {
+ return Collections.emptyList();
+ }
+
+
+ /**
+ * 查询给定用户在给定门店核销的订单
+ * @param shopId
+ * @param appUserId
+ * @return
+ */
+ @Override
+ public List<Order> getOrderByAppUserIdsAndWriteOffShop(Integer shopId, Set<Long> appUserId) {
+ return this.baseMapper.getOrderByAppUserIdsAndWriteOffShop(shopId, appUserId);
+ }
}
--
Gitblit v1.7.1