mitao
2025-02-21 31573d6180d15ef65ed0df9c2732495f40b12663
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
package com.panzhihua.service_community.service.impl;
 
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.panzhihua.common.constants.PayCpmstant;
import com.panzhihua.common.model.dtos.shop.WxPayNotifyOrderDTO;
import com.panzhihua.common.model.vos.common.ComBatteryCommodityOrderVo;
import com.panzhihua.common.model.vos.common.ComBatteryCommoditySpecsVo;
import com.panzhihua.common.model.vos.common.ComBatteryCommodityVo;
import com.panzhihua.common.model.vos.common.ComBatteryUserAddressVo;
import com.panzhihua.common.utlis.DateUtils;
import com.panzhihua.common.utlis.Snowflake;
import com.panzhihua.common.utlis.WxPayUtils;
import com.panzhihua.service_community.dao.*;
import com.panzhihua.service_community.entity.*;
import com.panzhihua.service_community.service.ComBatteryCommodityOrderService;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.panzhihua.service_community.service.ComBatteryTradeOrderService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import com.panzhihua.common.model.dtos.common.*;
import com.panzhihua.common.model.vos.R;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.springframework.transaction.annotation.Transactional;
 
import javax.annotation.Resource;
import java.math.BigDecimal;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
/**
 * title: 电动车商城-订单表表服务实现类
 * <p>
 * projectName 成都呐喊信息技术有限公司-智慧社区项目
 * <p>
 * description: 电动车商城-订单表表服务实现类
 *
 * @author lyq
 * @date 2022-03-29 16:05:48
 */
@Slf4j
@Service("comBatteryCommodityOrderService")
public class ComBatteryCommodityOrderServiceImpl extends ServiceImpl<ComBatteryCommodityOrderMapper, ComBatteryCommodityOrder> implements ComBatteryCommodityOrderService {
 
    @Resource
    private ComBatteryCommodityMapper commodityMapper;
    @Resource
    private ComBatteryCommoditySpecsMapper commoditySpecsMapper;
    @Resource
    private ComBatteryUserAddressMapper userAddressMapper;
    @Resource
    private SysUserMapper userMapper;
    @Resource
    private ComBatteryTradeOrderService tradeOrderService;
    @Value("${min.app.isTest}")
    private Boolean isTest;
    @Value("${min.app.appid}")
    private String appid;
    @Value("${min.app.payKey}")
    private String payKey;
    @Value("${min.app.mchId}")
    private String mchId;
//    @Value("${min.app.currencyNotifyUrl}")
//    private String currencyNotifyUrl;
    @Resource
    private ComBatteryCommodityOrderCollageTeamMapper orderCollageTeamMapper;
    @Resource
    private ComBatteryCommodityOrderCollageTeamPeopleMapper orderCollageTeamPeopleMapper;
    @Resource
    private ComBatteryCommodityActivityMapper commodityActivityMapper;
    @Resource
    private ComBatteryCommodityOrderBargainMapper orderBargainMapper;
 
    /**
     * description  queryByPage  分页查询
     *
     * @param comBatteryCommodityOrder 请求参数
     * @return 分页查询列表数据
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R queryByPage(PageComBatteryCommodityOrderDto comBatteryCommodityOrder) {
        return R.ok(this.baseMapper.queryAllByLimit(comBatteryCommodityOrder, new Page(comBatteryCommodityOrder.getPageNum(), comBatteryCommodityOrder.getPageSize())));
    }
 
    /**
     * description  insert  新增数据
     *
     * @param comBatteryCommodityOrder 请求参数
     * @return 新增结果
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R insert(AddComBatteryCommodityOrderDto comBatteryCommodityOrder) {
        ComBatteryCommodityOrder entity = new ComBatteryCommodityOrder();
        BeanUtils.copyProperties(comBatteryCommodityOrder, entity);
        if (this.baseMapper.insert(entity) > 0) {
            return R.ok();
        }
        return R.fail("添加失败");
    }
 
    /**
     * description  update  修改数据
     *
     * @param editDto 请求参数
     * @return 修改结果
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R update(EditComBatteryCommodityOrderDto editDto) {
        ComBatteryCommodityOrder entity = this.baseMapper.selectById(editDto.getId());
        if (entity == null) {
            return R.fail("未查询到该记录");
        }
        BeanUtils.copyProperties(editDto, entity);
        if (this.baseMapper.updateById(entity) > 0) {
            return R.ok();
        }
        return R.fail("修改失败");
    }
 
    /**
     * description  deleteById  通过主键删除数据
     *
     * @param id 主键id
     * @return 删除结果
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R deleteById(Long id) {
        ComBatteryCommodityOrder entity = new ComBatteryCommodityOrder();
        entity.setId(id);
        entity.setIsDel(ComBatteryCommodityOrder.IsDel.YES);
        if (this.baseMapper.updateById(entity) > 0) {
            return R.ok();
        }
        return R.fail("删除失败");
    }
 
    /**
     * description  detailById  查询详情
     *
     * @param id 主键id
     * @return 详情数据
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R detailById(Long id) {
        ComBatteryCommodityOrderVo commodityOrderVo = this.baseMapper.queryById(id);
        if (commodityOrderVo != null) {
            //查询商品信息
            ComBatteryCommodityVo commodityVo = commodityMapper.queryById(commodityOrderVo.getCommodityId());
            commodityOrderVo.setCommodityVo(commodityVo);
            //查询商品规格信息
            ComBatteryCommoditySpecsVo commoditySpecsVo = commoditySpecsMapper.queryById(commodityOrderVo.getSpecsId());
            commodityOrderVo.setCommoditySpecsVo(commoditySpecsVo);
            //查询用户收货地址
            ComBatteryUserAddressVo userAddressVo = userAddressMapper.queryById(commodityOrderVo.getAddressId());
            commodityOrderVo.setUserAddressVo(userAddressVo);
        }
        return R.ok(commodityOrderVo);
    }
 
    /**
     * description  queryByPage  查询列表
     *
     * @param comBatteryCommodityOrder 请求参数
     * @return 列表数据
     * @author lyq
     * @date 2022-03-29 16:05:48
     */
    @Override
    public R queryByList(PageComBatteryCommodityOrderDto comBatteryCommodityOrder) {
        return R.ok(this.baseMapper.queryAllByList(comBatteryCommodityOrder));
    }
 
    /**
     * 修改订单收货地址
     *
     * @param editOrderAddressDto 请求参数
     * @return 修改结果
     */
    @Override
    public R updateOrderAddress(EditOrderAddressDto editOrderAddressDto) {
        ComBatteryCommodityOrder entity = new ComBatteryCommodityOrder();
        BeanUtils.copyProperties(editOrderAddressDto, entity);
        if (this.baseMapper.updateById(entity) > 0) {
            return R.ok();
        }
        return R.fail("修改失败");
    }
 
    /**
     * 修改订单物流信息
     *
     * @param editOrderLogisticsDto 请求参数
     * @return 修改结果
     */
    @Override
    public R updateOrderLogistics(EditOrderLogisticsDto editOrderLogisticsDto) {
        ComBatteryCommodityOrder entity = new ComBatteryCommodityOrder();
        BeanUtils.copyProperties(editOrderLogisticsDto, entity);
        if (this.baseMapper.updateById(entity) > 0) {
            return R.ok();
        }
        return R.fail("修改失败");
    }
 
    /**
     * 电动车商城购买商品支付回调
     *
     * @param notifyOrderDTO 请求参数
     * @return 购买商品支付回调
     */
    @Override
    public R batteryPayNotify(WxPayNotifyOrderDTO notifyOrderDTO) {
        Date payTime = DateUtils.stringToDate(notifyOrderDTO.getPayTime(), new SimpleDateFormat("yyyyMMddHHmmss"));
        Date nowDate = new Date();
        String orderNo = notifyOrderDTO.getOrderTradeNo();
        String payNo = notifyOrderDTO.getWxTradeNo();
        BigDecimal cashFee = new BigDecimal(notifyOrderDTO.getCashFee());
        ComBatteryCommodityOrder commodityOrder = this.baseMapper.selectOne(new QueryWrapper<ComBatteryCommodityOrder>().lambda()
                .eq(ComBatteryCommodityOrder::getOrderNo, orderNo));
        if (commodityOrder == null) {
            log.error("用户购买商品订单微信支付回调错误,未查询到支付订单记录,支付订单号:" + orderNo);
            return R.fail("未查询到用户购买商品支付订单记录");
        }
        if (!commodityOrder.getPayStatus().equals(ComBatteryCommodityOrder.PayStatus.WZF)) {
            log.error("用户购买商品订单微信支付回调错误,错误原因:支付订单状态已发生改变,不可重复回调,订单号:" + orderNo);
            return R.fail("支付订单状态已发生改变,不可重复回调");
        }
        //更新订单
        commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFH);
        commodityOrder.setPayStatus(ComBatteryCommodityOrder.PayStatus.YZF);
        commodityOrder.setPayNo(payNo);
        commodityOrder.setPayAmount(cashFee);
        commodityOrder.setUpdateAt(nowDate);
        commodityOrder.setPayTime(payTime);
        this.baseMapper.updateById(commodityOrder);
 
        // 更新微信支付流水记录
        tradeOrderService.renewPayTrade(commodityOrder.getId(), cashFee, notifyOrderDTO.getWxTradeNo(), payTime, nowDate);
        return R.ok();
    }
 
    /**
     * 小程序用户创建订单
     *
     * @param createOrderDto 请求参数
     * @return 创建结果
     */
    @Override
    public R appletsOrderCreate(UserCreateOrderDto createOrderDto) {
        //查询商品
        ComBatteryCommodity commodity = commodityMapper.selectById(createOrderDto.getCommodityId());
        if (commodity == null) {
            return R.fail("未查询到商品信息");
        }
        //查询商品规格信息
        ComBatteryCommoditySpecs commoditySpecs = commoditySpecsMapper.selectById(createOrderDto.getSpecsId());
        if (commoditySpecs == null) {
            return R.fail("未查询到商品规格信息");
        }
        //判断商品库存
        if (commoditySpecs.getStock() < createOrderDto.getCount()) {
            return R.fail("您购买的商品库存不足");
        }
        //查询用户收货地址
        ComBatteryUserAddress userAddress = userAddressMapper.selectById(createOrderDto.getAddressId());
        if (userAddress == null) {
            return R.fail("未查询到用户收货地址");
        }
        //查询用户信息
        SysUser user = userMapper.selectOne(new QueryWrapper<SysUser>().lambda().eq(SysUser::getUserId,createOrderDto.getUserId()));
        if (user == null) {
            return R.fail("未查询到用户信息");
        }
        Date nowDate = new Date();
        //初始化订单信息
        ComBatteryCommodityOrder commodityOrder = getCreateOrder(commodity, userAddress, user, commoditySpecs, createOrderDto, nowDate);
        Map<String, Object> resultMap = new HashMap<>(2);
        if (this.baseMapper.insert(commodityOrder) > 0) {
            //更新商品库存
            commoditySpecs.setStock(commoditySpecs.getStock() - createOrderDto.getCount());
            commoditySpecsMapper.updateById(commoditySpecs);
 
            //微信支付需要调取小程序微信支付
            String result = getWxPayResult(commodityOrder.getFinalAmount(), commodityOrder.getOpenId(), commodityOrder.getOrderNo(), "购买商品");
            resultMap.put("payResult", result);
            resultMap.put("orderId", commodityOrder.getId());
 
            // 添加微信支付交易流水
            String wxTradeOrderNo = "wx" + Snowflake.getId();
            tradeOrderService.addOrderTradeRecord(user.getUserId(), user.getOpenid(), wxTradeOrderNo, ComBatteryTradeOrder.PayType.WX,
                    commodityOrder.getFinalAmount(), ComBatteryTradeOrder.TradeType.DDC_SHOP, commodityOrder.getId(),
                    commodityOrder.getOrderNo(), user.getUserId(), nowDate);
        }
        return R.ok(resultMap);
    }
 
    /**
     * 初始化订单数据
     *
     * @param commodity      商品数据
     * @param userAddress    用户收货地址信息
     * @param user           用户数据
     * @param commoditySpecs 商品规格数据
     * @param createOrderDto 用户请求参数
     * @param nowDate        操作时间
     * @return 初始化订单数据
     */
    public static ComBatteryCommodityOrder getCreateOrder(ComBatteryCommodity commodity, ComBatteryUserAddress userAddress
            , SysUser user, ComBatteryCommoditySpecs commoditySpecs, UserCreateOrderDto createOrderDto, Date nowDate) {
        ComBatteryCommodityOrder commodityOrder = new ComBatteryCommodityOrder();
        commodityOrder.setUserId(user.getUserId());
        commodityOrder.setOpenId(user.getOpenid());
        commodityOrder.setStoreId(commodity.getStoreId());
        commodityOrder.setCommodityId(commodity.getId());
        commodityOrder.setSpecsId(commoditySpecs.getId());
        commodityOrder.setOrderNo("BS" + Snowflake.getId());
        commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFK);
        commodityOrder.setPayStatus(ComBatteryCommodityOrder.PayStatus.WZF);
        commodityOrder.setIsDel(ComBatteryCommodityOrder.IsDel.NO);
        commodityOrder.setPayType(ComBatteryCommodityOrder.PayType.WX);
        commodityOrder.setCount(createOrderDto.getCount());
        commodityOrder.setPrice(commoditySpecs.getPrice());
        commodityOrder.setAmount(commoditySpecs.getPrice().multiply(BigDecimal.valueOf(createOrderDto.getCount())));
        commodityOrder.setFreight(commodity.getPostage());
        commodityOrder.setFinalAmount(commodityOrder.getAmount().add(commodityOrder.getFreight()));
        commodityOrder.setCreateAt(nowDate);
        commodityOrder.setCreateBy(user.getUserId());
        commodityOrder.setRemark(createOrderDto.getRemark());
        //收货地址
        commodityOrder.setAddressId(userAddress.getId());
        commodityOrder.setReceivingName(userAddress.getName());
        commodityOrder.setReceivingPhone(userAddress.getPhone());
        commodityOrder.setReceivingRegionCode(userAddress.getProvinceAdcode() + "-" + userAddress.getCityAdcode() + "-" + userAddress.getDistrictAdcode());
        commodityOrder.setReceivingRegion(userAddress.getProvinceName() + userAddress.getCityName() + userAddress.getDistrictName());
        commodityOrder.setReceivingAddress(userAddress.getAddress());
        return commodityOrder;
    }
 
    /**
     * 小程序唤起微信支付
     *
     * @param money   需要支付的金额
     * @param openId  用户唤起微信支付的openid
     * @param orderNo 业务订单号
     * @param remark  交易备注
     * @return 小程序支付参数
     */
    private String getWxPayResult(BigDecimal money, String openId, String orderNo, String remark) {
        String result = "";
        // 将剩余金额调起微信支付
        if (isTest) {
            money = BigDecimal.valueOf(0.01);
        }
        // 调用wx支付
//        result = WxPayUtils.getUnifiedorder(appid, mchId, payKey, currencyNotifyUrl + PayCpmstant.BATTERY_STORE_PAY_NOTIFY_URL
//                , remark, openId, orderNo, money,null);
        log.info("用户购买商品微信支付返回参数:" + result);
        return result;
    }
 
    /**
     * 定时关闭5分钟未支付订单
     *
     * @return 操作结果
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public R syncCloseOrder() {
        log.info("定时器定时关闭超过5分钟未支付订单,并返回商品库存");
        Date nowDate = new Date();
        //获取当前时间减30分钟时间
        Date oldDate = DateUtils.addMinutes(nowDate, -5);
        List<ComBatteryCommodityOrder> commodityOrderList = this.baseMapper.selectList(new QueryWrapper<ComBatteryCommodityOrder>()
                .lambda().eq(ComBatteryCommodityOrder::getStatus, ComBatteryCommodityOrder.Status.DFK)
                .eq(ComBatteryCommodityOrder::getPayStatus, ComBatteryCommodityOrder.PayStatus.WZF)
                .eq(ComBatteryCommodityOrder::getIsDel, ComBatteryCommodityOrder.IsDel.NO)
                .lt(ComBatteryCommodityOrder::getCreateAt, oldDate));
        commodityOrderList.forEach(commodityOrder -> {
            commodityOrder.setStatus(ComBatteryCommodityOrder.Status.YGB);
            commodityOrder.setUpdateAt(nowDate);
            this.baseMapper.updateById(commodityOrder);
            //归还库存
            ComBatteryCommoditySpecs commoditySpecs = commoditySpecsMapper.selectById(commodityOrder.getSpecsId());
            if (commoditySpecs != null) {
                commoditySpecs.setStock(commoditySpecs.getStock() + commodityOrder.getCount());
                commoditySpecs.setUpdateAt(nowDate);
                commoditySpecsMapper.updateById(commoditySpecs);
            }
            if(commodityOrder.getActivityId() != null){
                ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(commodityOrder.getActivityId());
                if(!commodityActivity.getType().equals(ComBatteryCommodityActivity.Type.PT)){
                    commodityActivity.setCommoditySaleNum(commodityActivity.getCommoditySaleNum() - commodityOrder.getCount());
                    commodityActivityMapper.updateById(commodityActivity);
                }
            }
        });
        return R.ok();
    }
 
    /**
     * 电动车商城用户确认收货
     *
     * @param id     订单id
     * @param userId 用户id
     * @return 确认结果
     */
    @Override
    public R appletsOrderReceiving(Long id, Long userId) {
        ComBatteryCommodityOrder commodityOrder = this.baseMapper.selectById(id);
        if (commodityOrder == null) {
            return R.fail("未查询到订单信息");
        }
        //确认收货
        commodityOrder.setStatus(ComBatteryCommodityOrder.Status.YWC);
        commodityOrder.setReceivingTime(new Date());
        commodityOrder.setUpdateAt(new Date());
        commodityOrder.setUpdateBy(userId);
        if (this.baseMapper.updateById(commodityOrder) > 0) {
            return R.ok();
        }
        return R.fail();
    }
 
    /**
     * 后台订单发货
     *
     * @param deliverAdminDto 请求参数
     * @return 发货结果
     */
    @Override
    public R orderDeliver(OrderDeliverAdminDto deliverAdminDto) {
        //查询订单
        ComBatteryCommodityOrder commodityOrder = this.baseMapper.selectById(deliverAdminDto.getId());
        if (commodityOrder == null) {
            return R.fail("未查询到订单信息");
        }
        Date nowDate = new Date();
        //判断操作类型
        if (deliverAdminDto.getType().equals(OrderDeliverAdminDto.Type.FH)) {
            commodityOrder.setLogisticsCompany(deliverAdminDto.getLogisticsCompany());
            commodityOrder.setLogisticsNo(deliverAdminDto.getLogisticsNo());
            commodityOrder.setUpdateBy(deliverAdminDto.getUserId());
            commodityOrder.setUpdateAt(nowDate);
            commodityOrder.setDeliveryTime(nowDate);
            commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DSH);
        } else if (deliverAdminDto.getType().equals(OrderDeliverAdminDto.Type.XGWL)) {
            commodityOrder.setLogisticsCompany(deliverAdminDto.getLogisticsCompany());
            commodityOrder.setLogisticsNo(deliverAdminDto.getLogisticsNo());
            commodityOrder.setUpdateBy(deliverAdminDto.getUserId());
            commodityOrder.setUpdateAt(nowDate);
        }
        if (this.baseMapper.updateById(commodityOrder) > 0) {
            return R.ok();
        }
        return R.fail();
    }
 
    /**
     * 电动车商城购买活动商品支付回调
     *
     * @param notifyOrderDTO 请求参数
     * @return 购买商品支付回调
     */
    @Override
    @Transactional(rollbackFor = Exception.class)
    public synchronized R batteryActivityPayNotify(WxPayNotifyOrderDTO notifyOrderDTO) {
        Date payTime = DateUtils.stringToDate(notifyOrderDTO.getPayTime(), new SimpleDateFormat("yyyyMMddHHmmss"));
        Date nowDate = new Date();
        String orderNo = notifyOrderDTO.getOrderTradeNo();
        String payNo = notifyOrderDTO.getWxTradeNo();
        BigDecimal cashFee = new BigDecimal(notifyOrderDTO.getCashFee());
        //查询该订单数据
        ComBatteryCommodityOrder commodityOrder = this.baseMapper.selectOne(new QueryWrapper<ComBatteryCommodityOrder>().lambda()
                .eq(ComBatteryCommodityOrder::getOrderNo, orderNo));
        if (commodityOrder == null) {
            log.error("用户购买商品订单微信支付回调错误,未查询到支付订单记录,支付订单号:" + orderNo);
            return R.fail("未查询到用户购买商品支付订单记录");
        }
        if (!commodityOrder.getPayStatus().equals(ComBatteryCommodityOrder.PayStatus.WZF)) {
            log.error("用户购买商品订单微信支付回调错误,错误原因:支付订单状态已发生改变,不可重复回调,订单号:" + orderNo);
            return R.fail("支付订单状态已发生改变,不可重复回调");
        }
        //更新订单
        if (commodityOrder.getActivityId() != null) {
            switch (commodityOrder.getActivityType()) {
                case ComBatteryCommodityOrder.ActivityType.PT:
                    //拼团订单成功支付处理
                    commodityOrder.setCollageStatus(ComBatteryCommodityOrder.CollageStatus.PTZ);
                    commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DPT);
                    ComBatteryCommodityOrderCollageTeam orderCollageTeam = null;
                    if(notifyOrderDTO.getAttach() != null && notifyOrderDTO.getAttach().equals("1")){
                        //用户开团,创建团队信息
                        orderCollageTeam = getOrderCollageTeam(commodityOrder,nowDate);
                        orderCollageTeamMapper.insert(orderCollageTeam);
                        commodityOrder.setTeamId(orderCollageTeam.getId());
                    }else{
                        //用户参团,查询参加的团队信息
                        orderCollageTeam = orderCollageTeamMapper.selectById(commodityOrder.getTeamId());
                    }
                    if(orderCollageTeam != null){
                        //创建用户开团人员记录
                        ComBatteryCommodityOrderCollageTeamPeople orderCollageTeamPeople = getOrderCollageTeamPeople(commodityOrder.getUserId()
                                ,nowDate,orderCollageTeam,notifyOrderDTO.getAttach());
                        orderCollageTeamPeopleMapper.insert(orderCollageTeamPeople);
                    }
                    break;
                case ComBatteryCommodityOrder.ActivityType.KJ:
                    //砍价订单成功支付处理
                    commodityOrder.setBargainStatus(ComBatteryCommodityOrder.BargainStatus.KJZ);
                    commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DKJ);
                    //创建用户发布待砍价记录
                    ComBatteryCommodityOrderBargain orderBargain = getOrderBargain(commodityOrder,nowDate);
                    orderBargainMapper.insert(orderBargain);
                    break;
                case ComBatteryCommodityOrder.ActivityType.MS:
                    commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFH);
                    break;
                default:
                    break;
            }
        }
        // 更新微信支付流水记录
        tradeOrderService.renewPayTrade(commodityOrder.getId(), cashFee, notifyOrderDTO.getWxTradeNo(), payTime, nowDate);
 
        commodityOrder.setPayStatus(ComBatteryCommodityOrder.PayStatus.YZF);
        commodityOrder.setPayNo(payNo);
        commodityOrder.setPayAmount(cashFee);
        commodityOrder.setUpdateAt(nowDate);
        commodityOrder.setPayTime(payTime);
        this.baseMapper.updateById(commodityOrder);
 
        if(commodityOrder.getTeamId() != null){
            //判断当前拼团人员是否已足够成团
            syncAssortedDoughStatus(commodityOrder.getTeamId(),nowDate);
        }
        if(commodityOrder.getActivityId() != null && commodityOrder.getActivityType().equals(ComBatteryCommodityOrder.ActivityType.PT)){
            //判断当前拼团活动是否已完成
            syncAssortedDoughActivityStatus(commodityOrder.getActivityId(),nowDate);
        }
        return R.ok();
    }
 
    /**
     * 初始化拼团团队数据
     * @param commodityOrder    用户订单数据
     * @param nowDate   操作时间
     * @return  拼团团队数据
     */
    private ComBatteryCommodityOrderCollageTeam getOrderCollageTeam(ComBatteryCommodityOrder commodityOrder,Date nowDate){
        ComBatteryCommodityOrderCollageTeam orderCollageTeam = new ComBatteryCommodityOrderCollageTeam();
        orderCollageTeam.setActivityId(commodityOrder.getActivityId());
        orderCollageTeam.setOrderId(commodityOrder.getId());
        orderCollageTeam.setOrderNo(commodityOrder.getOrderNo());
        orderCollageTeam.setUserId(commodityOrder.getUserId());
        orderCollageTeam.setStatus(ComBatteryCommodityOrderCollageTeam.Status.DDPT);
        orderCollageTeam.setCreateAt(nowDate);
        return orderCollageTeam;
    }
 
    /**
     * 初始化拼团团队人员数据
     * @param userId    用户id
     * @param nowDate   操作时间
     * @param orderCollageTeam  拼团团队数据
     * @param type  拼团类型(1.开团 2.参团)
     * @return  拼团团队人员数据
     */
    private ComBatteryCommodityOrderCollageTeamPeople getOrderCollageTeamPeople(Long userId
            ,Date nowDate,ComBatteryCommodityOrderCollageTeam orderCollageTeam,String type){
        ComBatteryCommodityOrderCollageTeamPeople orderCollageTeamPeople = new ComBatteryCommodityOrderCollageTeamPeople();
        orderCollageTeamPeople.setUserId(userId);
        orderCollageTeamPeople.setTeamId(orderCollageTeam.getId());
        orderCollageTeamPeople.setHeadUserId(orderCollageTeam.getUserId());
        orderCollageTeamPeople.setType(Integer.parseInt(type));
        orderCollageTeamPeople.setCreateAt(nowDate);
        orderCollageTeamPeople.setCreateBy(userId);
        return orderCollageTeamPeople;
    }
 
    /**
     * 同步拼团活动状态
     * @param activityId    活动id
     */
    private void syncAssortedDoughActivityStatus(Long activityId,Date nowDate){
        ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(activityId);
        if(commodityActivity != null){
            //查询该活动已成团数量
            Integer count = orderCollageTeamMapper.selectCount(new QueryWrapper<ComBatteryCommodityOrderCollageTeam>().lambda()
                    .eq(ComBatteryCommodityOrderCollageTeam::getActivityId,activityId)
                    .eq(ComBatteryCommodityOrderCollageTeam::getStatus,ComBatteryCommodityOrderCollageTeam.Status.PTCG));
            if(count >= commodityActivity.getCollageNum()){
                //该活动已达到活动拼团数量,修改为已结束状态
                commodityActivity.setStatus(ComBatteryCommodityActivity.Status.YJS);
                commodityActivity.setUpdateAt(nowDate);
                commodityActivityMapper.updateById(commodityActivity);
            }
        }
    }
 
    /**
     * 判断当前拼团团队是否已满足拼团条件
     * @param teamId    拼团团队id
     * @param nowDate    操作时间
     */
    private void syncAssortedDoughStatus(Long teamId,Date nowDate){
        //查询拼团团队id
        ComBatteryCommodityOrderCollageTeam orderCollageTeam = orderCollageTeamMapper.selectById(teamId);
        if(orderCollageTeam != null){
            ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(orderCollageTeam.getActivityId());
            if(commodityActivity != null){
                Integer count = orderCollageTeamPeopleMapper.selectCount(new QueryWrapper<ComBatteryCommodityOrderCollageTeamPeople>()
                        .lambda().eq(ComBatteryCommodityOrderCollageTeamPeople::getTeamId,teamId));
                if(count >= commodityActivity.getCollagePeopleNum()){
                    //拼团条件满足,将所有已拼单的用户的订单更新为待发货状态
                    //更新拼团团队记录
                    orderCollageTeam.setStatus(ComBatteryCommodityOrderCollageTeam.Status.PTCG);
                    orderCollageTeamMapper.updateById(orderCollageTeam);
                    //查询拼团订单并进行更新
                    List<ComBatteryCommodityOrder> commodityOrderList = this.baseMapper.selectList(new QueryWrapper<ComBatteryCommodityOrder>().lambda()
                            .eq(ComBatteryCommodityOrder::getTeamId,teamId).eq(ComBatteryCommodityOrder::getStatus,ComBatteryCommodityOrder.Status.DPT)
                            .eq(ComBatteryCommodityOrder::getCollageStatus,ComBatteryCommodityOrder.CollageStatus.PTZ)
                            .eq(ComBatteryCommodityOrder::getActivityType,ComBatteryCommodityOrder.ActivityType.PT));
                    commodityOrderList.forEach(commodityOrder -> {
                        commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFH);
                        commodityOrder.setCollageStatus(ComBatteryCommodityOrder.CollageStatus.PTCG);
                        commodityOrder.setUpdateAt(nowDate);
                        this.baseMapper.updateById(commodityOrder);
                    });
                }
            }
        }
    }
 
    /**
     * 初始化砍价记录
     * @param commodityOrder    订单数据
     * @param nowDate   操作时间
     * @return  砍价记录
     */
    private ComBatteryCommodityOrderBargain getOrderBargain(ComBatteryCommodityOrder commodityOrder,Date nowDate){
        ComBatteryCommodityOrderBargain orderBargain = new ComBatteryCommodityOrderBargain();
        BeanUtils.copyProperties(commodityOrder,orderBargain);
        orderBargain.setOrderId(commodityOrder.getId());
        orderBargain.setOrderNo(commodityOrder.getOrderNo());
        orderBargain.setCount(0);
        orderBargain.setCreateAt(nowDate);
        orderBargain.setCreateBy(commodityOrder.getUserId());
        //查询商品信息
        ComBatteryCommodity commodity = commodityMapper.selectById(commodityOrder.getCommodityId());
        if(commodity != null){
            orderBargain.setOriginalPrice(commodity.getPrice());
            orderBargain.setCurrentPrice(commodity.getPrice());
        }
        //查询活动信息
        ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(commodityOrder.getActivityId());
        if(commodityActivity != null){
            orderBargain.setTargetPrice(commodityActivity.getPrice());
        }
        return orderBargain;
    }
 
    /**
     * 创建秒杀订单
     * @param orderDto  请求参数
     * @return  创建订单结果
     */
    @Override
    public R startSeckill(StartSeckillOrderDto orderDto) {
        ComBatteryCommodityActivity commodityActivity = commodityActivityMapper.selectById(orderDto.getActivityId());
        if(commodityActivity == null){
            return R.fail("未查询到秒杀活动");
        }
        if(commodityActivity.getCommodityNum() <= commodityActivity.getCommoditySaleNum()){
            return R.fail("活动商品已售空");
        }
        if(commodityActivity.getEndTime().getTime() - System.currentTimeMillis() <= 0
                || commodityActivity.getStatus().equals(ComBatteryCommodityActivity.Status.YJS)){
            return R.fail("该活动已结束");
        }
        if(commodityActivity.getStatus().equals(ComBatteryCommodityActivity.Status.YXJ)){
            return R.fail("该活动已下架");
        }
        Integer notSaleNum = commodityActivity.getCommodityNum() - commodityActivity.getCommoditySaleNum();
        if(notSaleNum <= orderDto.getCount()){
            return R.fail("活动商品库存不足");
        }
        //查询商品
        ComBatteryCommodity commodity = commodityMapper.selectById(orderDto.getCommodityId());
        if(commodity == null){
            return R.fail("未查询到商品信息");
        }
        //查询商品规格信息
        ComBatteryCommoditySpecs commoditySpecs = commoditySpecsMapper.selectById(commodityActivity.getSpecsId());
        if(commoditySpecs == null){
            return R.fail("未查询到商品规格信息");
        }
        if(commoditySpecs.getStock() < orderDto.getCount()){
            return R.fail("该商品库存不足,无法下单");
        }
        //查询用户信息
        SysUser user = userMapper.selectOne(new QueryWrapper<SysUser>().lambda().eq(SysUser::getUserId,orderDto.getUserId()));
        if(user == null){
            return R.fail("未查询到用户信息");
        }
        //查询用户收货地址
        ComBatteryUserAddress userAddress = userAddressMapper.selectById(orderDto.getAddressId());
        if(userAddress == null){
            return R.fail("未查询到用户收货地址");
        }
        Date nowDate = new Date();
        ComBatteryCommodityOrder commodityOrder = getCreateActivityOrder(commodity,userAddress,user,commoditySpecs,orderDto,nowDate,commodityActivity);
        Map<String,Object> resultMap = new HashMap<>(2);
        if(this.baseMapper.insert(commodityOrder) > 0){
            //更新活动商品库存
            commodityActivity.setCommoditySaleNum(commodityActivity.getCommoditySaleNum() + orderDto.getCount());
            commodityActivityMapper.updateById(commodityActivity);
            //更新商品库存
            commoditySpecs.setStock(commoditySpecs.getStock() - orderDto.getCount());
            commoditySpecsMapper.updateById(commoditySpecs);
            //微信支付需要调取小程序微信支付
            String result = getWxPayResult(commodityOrder.getFinalAmount(),commodityOrder.getOpenId()
                    ,commodityOrder.getOrderNo(),"购买商品");
            resultMap.put("payResult",result);
            resultMap.put("orderId",commodityOrder.getId());
            // 添加微信支付交易流水
            String wxTradeOrderNo = "wx" + Snowflake.getId();
            tradeOrderService.addOrderTradeRecord(user.getUserId(), user.getOpenid(), wxTradeOrderNo, ComBatteryTradeOrder.PayType.WX,
                    commodityOrder.getFinalAmount(), ComBatteryTradeOrder.TradeType.DDC_SHOP, commodityOrder.getId(),
                    commodityOrder.getOrderNo(), user.getUserId(), nowDate);
        }
        return R.ok(resultMap);
    }
 
    /**
     * 初始化活动订单数据
     * @param commodity         商品数据
     * @param userAddress       用户收货地址信息
     * @param user              用户数据
     * @param commoditySpecs    商品规格数据
     * @param orderDto          用户请求参数
     * @param nowDate           操作时间
     * @param commodityActivity           拼团活动数据
     * @return  初始化订单数据
     */
    public static ComBatteryCommodityOrder getCreateActivityOrder(ComBatteryCommodity commodity, ComBatteryUserAddress userAddress
            , SysUser user, ComBatteryCommoditySpecs commoditySpecs, StartSeckillOrderDto orderDto, Date nowDate
            ,ComBatteryCommodityActivity commodityActivity){
        ComBatteryCommodityOrder commodityOrder = new ComBatteryCommodityOrder();
        commodityOrder.setUserId(user.getUserId());
        commodityOrder.setOpenId(user.getOpenid());
        commodityOrder.setStoreId(commodity.getStoreId());
        commodityOrder.setActivityId(commodityActivity.getId());
        commodityOrder.setCommodityId(commodity.getId());
        commodityOrder.setSpecsId(commoditySpecs.getId());
        commodityOrder.setOrderNo("PT" + Snowflake.getId());
        commodityOrder.setActivityType(commodityActivity.getType());
        commodityOrder.setStatus(ComBatteryCommodityOrder.Status.DFK);
        commodityOrder.setPayStatus(ComBatteryCommodityOrder.PayStatus.WZF);
        commodityOrder.setIsDel(ComBatteryCommodityOrder.IsDel.NO);
        commodityOrder.setPayType(ComBatteryCommodityOrder.PayType.WX);
        commodityOrder.setCount(orderDto.getCount());
        commodityOrder.setPrice(commodityActivity.getPrice());
        commodityOrder.setAmount(commodityActivity.getPrice().multiply(BigDecimal.valueOf(orderDto.getCount())));
        commodityOrder.setFreight(commodity.getPostage());
        commodityOrder.setFinalAmount(commodityOrder.getAmount().add(commodityOrder.getFreight()));
        commodityOrder.setCreateAt(nowDate);
        commodityOrder.setCreateBy(user.getUserId());
        commodityOrder.setRemark(orderDto.getRemark());
        //收货地址
        commodityOrder.setAddressId(userAddress.getId());
        commodityOrder.setReceivingName(userAddress.getName());
        commodityOrder.setReceivingPhone(userAddress.getPhone());
        commodityOrder.setReceivingRegionCode(userAddress.getProvinceAdcode() + "-" + userAddress.getCityAdcode() + "-" + userAddress.getDistrictAdcode());
        commodityOrder.setReceivingRegion(userAddress.getProvinceName() + userAddress.getCityName() + userAddress.getDistrictName());
        commodityOrder.setReceivingAddress(userAddress.getAddress());
        return commodityOrder;
    }
}